1) Tax is empty when create a tax jurisdiction
Oracle E-Business Tax - Version: 12.0.2
Information in this document applies to any platform.
Goal
Q1: Created a new Tax Regime, Tax and Tax Status in E-Business Tax.
Now want to create a Tax Jurisdiction that can be linked up to a Rate so that I can complete the configuration.
When I go to select the Tax value on the "Create Tax Jurisdiction" page, nothing is listed in the LOV.
As a result, cannot complete the Tax Jurisdiction configuration.
What am I missing?
Q2: For the Taxes that got migrated as part of the upgrade from 11.5.9 to R12, tax jurisdiction values does not exist. Is this intended?
Solution
A1: Check your tax setup. Have you defined geography type? If not, you will be not be able to tie the geography based setting of tax jurisdictions, without first defining this.
A2: Yes, this is correct, this is the intended functionality. Please see comment from development in Bug 5713854:
"Only for migrated records, we cannot derive jurisdiction for a tax. So only for migrated records, system allows tax definition without having associated jurisdictions."
2)Geography Name is empty when create a tax juristiction
Oracle Project Costing - Version: 12.0 to 12.1
This problem can occur on any platform.
Symptoms
In a fresh release 12 environment, when creating a new jurisdiction, the Geography values (state, province, city, etc) cannot be found in the list of values (LOV). No records are retured or in some cases only some are returned.
Changes
Geography hierarchy was defined for a new country from scratch
Cause
The Geography start dates were set to be 30-Dec-2008 but the Tax and Jurisdictions were being defined with back dated dates of 01-Jan-2000. Since the geographies were not active on that earlier date they did not show up in the list of values.
Solution
Resolution for this was to change the start date of the tax and jurisdiction to be on or after the start date of the geography values.
3)Receivable Activities
Error: Please define a party tax profile for operating unit &ORG_ID
Oracle Receivables - Version: 12.0 to 12.0
This problem can occur on any platform.
ARXSUMRT.fmb
Symptoms
Unable to setup Receivables Activities. When attempt to navigate to
form.
Navigator drop-down > Setup, Receivable, Receivable Activities
Error: Please define a party tax profile for operating unit &ORG_ID
Cause
The issue is caused by the following setup:
Did not setup Operating Unit owning Tax Content Profile
This issue is described in Bug 5899659 - RECEIVABLES ACTIVITY ERROR PLEASE DEFINE PARTY TAX PROFILE FOR &ORDID
Solution
To implement the solution, please execute the following steps:
1. Go into the responsibility: Tax Managers
2. Navigate to Parties -> Party Tax -> Profiles
3. Party Type: Operating Unit Owning Tax Content
Party Name: populate your Operating Unit Name
You should have a result to this query.
If you do not make sure you create a Party Tax Profile for your operating Unit of the
Type: First Party Legal Entity.
4. Verify the each component of location address associated with your organization is valid
5. Retest the issue.
6. Migrate the solution as appropriate to other environments
4)Unable to create a party tax profile for a newly defined operating unit
Oracle E-Business Tax - Version: 12.0 to 12.1
This problem can occur on any platform.
Symptoms
After setting up a new operating unit, theoperating unit can be selected in the party tax profile form within EB Tax buta profile cannot be created as the create button is not displayed.
Changes
Occurs when a new operating unit is defined
Cause
This occurs when the location address associated to the new operating unitis defined incorrectly. The sql used to select operating units in EBTax validates that the country code is correct. Unfortunately theLocations form allows a user to enter the country code free-form thus if a user enters "United States" instead of US the operating unit will not be displayed.
Solution
-- To implement the solution, please execute the following steps::
1. Go into the responsibility: Receivables Manager
2. Navigate to Setup > System > Organizations > Locations
3. Query the Location that you have defined for the new operating unit
4. Open the address and change the country from to use the proper 2 digit abreviationSave
5. Return to tax manager and verify that you can now set the party tax profile
5)Unable to See the Legal Entity List of Value in the Bank Account Owner Field
Oracle Cash Management - Version: 12.0 to 12.0
This problem can occur on any platform.
AccountOwnerUsePG 120.8
Symptoms
Unable to create a new bank account in release 12 in Cash Management. The list of value in the Bank account Owner does not bring the information of the Legal Entities that have been created.
Cause
This is not a bug, it isa setup issue. Cash Management responsibility mustbe assigned the Legal Entities that you want to grant the access to all bank accounts.
Solution
Please do the following to assign Legal Entities to the Cash Management responsibility :
1. Log in as Sysadmin.
2. Go to the User Management Responsibility.
3. Path: Roles & Role Inheritance
4. In the Type field select Roles and Responsibilities
5. Wait until a new field appears, you will see the category field, please select Miscellaneous
6. In the Application select 'Cash Management' and click on GO button.
7. Search your Cash Management responsibility or role that you are using to create your bank account.
8. Clickon theupdate icon.
9. A new window will be displayed, please click in the Security wizard button.
10. For CE UMX Security wizard clickon the Run Wizard.
11. In this window you should add the legal entities that you want to grant the access to all the
bank accounts within a legal entity and choosethe privilagesthat you want to assign to this role on the
bank accounts such as: USE, MAINTENANCE and BANK ACCOUNT TRANSFERS.
12. Save and apply the changes and then verify in Cash management responsibility if you now are
able to see that legal entity in the bank account creation form.
6)ARXSUDRC: Cannot Open Receipt Class Form - FRM-40735, ORA-6502
Oracle Receivables - Version: 12.0.5
This problem can occur on any platform.
Symptoms
When attempting to enter the Receipt Classes form, the following error occurs.
FRM-40735: PRE-FORM trigger raised unhandled exception ORA-06502
The issue can be reproduced at will with the following steps:
1. Log into application and select Receivables responsibility
2. NAV:Setup->Receipts->Receipt Classes
Due to this issue, users cannot complete the setup
Cause
Replicate Seed Data has not been executed. Running Replicate Seed Data process will create the seed data for the new Operating Unit
Solution
To implement the solution, please execute the following steps:
1.Connect to the application with System Administrator responsibility
2. Run concurrent program 'Replicate Seed Data'
7)Receivable Activities screen when opened throws error ORA-01422: exact fetch returns more than requested number of rows.
Oracle Receivables - Version: 12.0 to 12.0.6
This problem can occur on any platform.
Receivables Activities Form.
Symptoms
Symptoms:
When opening the Receivable Activities screen it triggers.
ORA-01422: exact fetch returns more than requested number of rows.
Cause
The cause of the issue is invalid / incorrect data in <ar_system_parameters_all>.
Found that there were duplicate records for the ORG_ID with set_of_books_id = -1.
Solution
Execute the below scripts in the TEST INSTANCE and retest the issue before migrating the changes to PRODUCTION.
create table AR_SYSTEM_PARAMETERS_ALL_bckup_82
as select * from AR_SYSTEM_PARAMETERS_ALL
where SET_OF_BOOKS_ID = -1
and ORG_ID = <&enter_org_id for operating_unit>;
delete from AR_SYSTEM_PARAMETERS_ALL
where SET_OF_BOOKS_ID = -1
and ORG_ID = <&enter_org_id for operating_unit>;
COMMIT;
After executing the scripts, log out of ORACLE Applications and log in again so that the parameters get affected.
Click on Receivables Responsibility and Navigate to Set up -> Receipts -> Receivables Activities and retest the issue.
分享到:
相关推荐
EBS R12 解决方案: •案例介绍及Oracle工程制造整体解决方案; •Oracle项目制造解决方案; •Oracle采购解决方案; •Oracle设备管理解决方案; •Oracle财务解决方案; •Oracle R12产品趋势
EBS R12 通知列表设置 通过个性化配置,实现通知列表首页展示
EBS R12 总账 应收 应付 税 基本设置
ORACLE EBS R12 安装步骤详解,讲述ORACLE EBS R12的详细安装步骤,感觉不错,和大家一块分享
Oracle EBS R12环境搭建及维护讲座,详细阐述了EBS环境的搭建及维护
ORACLE EBS-R12-设置文档_税信息设置详细手册_V1.0
本文详细描述EBS R12设置文档,包含SYS,GL,INV,AP,PO,AR,OM模块的设置步骤
EBS R12安装,EBS R12安装EBS R12安装windows
Oracle EBS R12中的配置文件及中文说明
修改EBS R12服务器域名的操作方法,包括AP服务器和DB服务器,域名、IP都可以改,改IP相对容易一些,改域名就要牵涉到很多配置,该文档都讲到了,按照上面介绍的操作错不了的。
Oracle EBS R12与11i文件系统差异
Oracle EBS R12 升级 流程图
EBS R12 INVENTORY 培训教材(英文)
Oracle EBS R12 DBA 原厂教材
Oracle EBS R12 FIN,MFG,OM 三個模塊的新功能介紹
应用开发员手册_R12-官方文档,是EBS 开发人员必备手册.版本为R12版本。
Oracle EBS R12系统管理员,内部培训交流
Oracle EBS R12安装手册 Solaris,作者:Nolem
Oracle EBS R12 FIN,MFG,OM 三個模塊的新功能
ORACLE EBS R12用户指南中文 Oracle® Cost Management User's Guide Release 12 Part No. B31271-02