1) Seeded Transaction Types are Not Available in the Transaction Types Form
After
creating a new organization or updating an existing organization, you
find that when you query the existing Transaction Types, there are no
seeded types returned. Oracle Receivables provides the
1. Invoice
2. Credit Memo
3. Projects Credit Memo
4. Projects Invoice
5. Intercompany
When
you cannot view the seeded Transaction Types, use the following
navigation to execute the Replicate Seed Data concurrent program:
Responsibility: System Administrator
Navigation: Requests > Run
1. Select Replicate Seed Data for the organization just updated
2. Verify the concurrent process completed successfully under View My Requests
2) When Defining Transaction Types, Legal Entity Has No List of Values
In Release 12 the Transaction Types form reflects the Legal Entity:
When
the List of Values (LOV) for the Legal Entity does not show any values,
you need to verify the setup. Use the following queries in SQL*Plus to
verify the set of books setup:
Verify the SET_OF_BOOKS_ID:
Select SET_OF_BOOKS_ID, ORG_ID
From AR_SYSTEM_PARAMETERS_ALL
Where ORG_ID = <enter the ORG_ID for the problem OU>;
Verify the LEDGER_ID:
Select a.LEDGER_ID, a.LEGAL_ENTITY_ID
From XLE_LE_OU_LEDGER_V a
Where OPERATING_UNIT_ID=<enter the ORG_ID for the problem OU>;
The
SET_OF_BOOKS_ID from the Receivables System Options should reflect the
same as the LEDGER_ID. The form will not return a LOV for the Legal
Entity when the setup is incorrect. To correct setups over again
starting with the Ledger, Legal Entity, Operating Unit and AR Setups
Verify the Transaction Types form Operating Unit List of Values.
3) Cannot Open Transaction Types Form after Defining a New Organization
After
defining a new organization, the Transaction Types form does not open.
The Auto Accounting form opens and presents the following error:
ERROR
FRM-40735: WHEN_CREATE_RECORD trigger raised unhandled exception ORA-20002
When you review the Forms Runtime Diagnostics (FRD) for this error, you find the following errors:
Executing USER_EXIT Built-in:
In Argument 0 - Type: String Value: FND MESSAGE_NAME "AR_NO_ROW_IN_GL_SET_OF_BOOKS" "AR"
Unhandled Exception ORA-20002
State Delta:
FORM RAXSUAGL
BLOCK AUTOGL
STATUS QUERY
RECSTATUS INSERT
FIELD ORG_ID
VALUE 126
FIELD OPERATING_UNIT
VALUE "CGNU AGI Operating Unit"
Error Message: FRM-40735: WHEN-CREATE-RECORD trigger raised unhandled exception ORA-20002.
Note: The following is the meaning for the AR_NO_ROW_IN_GL_SET_OF_BOOKS error message:
"Internal
Error: We have determined an inconsistency between the setup of the
Receivables System Options and General Ledger: the set of books id on
the system options record does not belong to a administrator."
When
this issue is experienced, verify that the setup for the Set of Books
associated to the System Options is correct. To do so:
Responsibility: Receivables Responsibility*
Navigation: Setup > System > System Options
* Ensure that you use the Receivables Responsibility associated to the newly defined organization.
Verify that the Set of Books is correct, and appears as it is defined in the General Ledger setup for the Set of Books.
4) Get APP-FND-01564: ORACLE error 900 in FDFGDF When Saving Transaction Type
When attempting to save a new Transaction Type, you receive the following error:
ERROR: APP-FND-01564: ORACLE error 900 in FDFGDF
Cause: FDFGDF failed due to ORA-00900: invalid SQL statement.
The SQL statement being executed at the time of the error was:
00000 and was executed from the file &ERRFILE
This
occurs when the Accounting Flexfield has been defined incorrectly. The
Accounting Flexfield has a segment defined with a Value Set Associated.
The Value Set is defined having a Default Value, 'SQL Statement' as
shown in the screen shot below:
Responsibility: Receivables Responsibility
Navigation: Setup > Financials > Key > Segments > Query the Accounting Flexfield
To
correct this, if applicable, change the Default Type from 'SQL
statement' to 'Constant', recompile your Accounting flexfield and verify
the issue
5) New Balancing Segment Not Available When Defining Transaction Type Accounts
You
are trying to enter the Accounting information when entering a new
Transaction Type. When trying to enter the Balancing Segment, you find
that a new value is not listed in the list of values.
When this is experienced, you need to execute the following steps to submit the General Ledger Accounting Setup Program:
Responsibility: General Ledger Responsibility
Navigation: Setup > Financials > Accounting Setup Manager > Accounting Setups
1. Query the Ledger
2. Click the Update Accounting Options Pencil Icon
3. For the primary ledger, click on the Update icon for "Balancing Segment Value Assignments"
4. In the following page, click "Complete"
5. This will trigger the request "General Ledger Accounting Setup Program".
6. Once the request completes, confirm that all the values are now populated in GL_LEDGER_SEGMENT_VALUES:
select *
from GL_LEDGER_SEGMENT_VALUES
where LEDGER_ID = &LEDGER_ID;
7. Retest the issue. The List of Values should now show all the Balancing Segment values.
6) Error When End Dating a Transaction Type: This Combination Has Expired
When trying to inactivate a Transaction Type, by entering the end date and saving, the following error is experienced:
This combination has expired.
The
change to the Transaction Type cannot be completed. There may have been
an invalid code combination associated to the Transaction Type. So a
work around was applied, in order to allow end date. The work around is
to remove the accounting code combinations associated to the Transaction
Type (i.e. Receivable, Revenue, Tax, etc). Then save the Transaction
Type
7) Operating Unit List of Values is Null or Errors When Entering Transaction Types
Ø No Operating Unit Is Displayed
After
setting up a new Operating Unit, you are trying to setup a new
transaction type in Oracle Receivables. Upon navigating to the
Transactions Type form, the Operating Unit field is null or does execute
the following script to verify the FND_APPLICATION details:
If the query returns the following records, then a data fix is required:
APPLICATION_ID
|
APPLICATION_SHORT_NAME
|
222
| |
111
|
Execute the following steps to correct this issue when the RA application reflects in the query results:
1. Back up the FND_APPLICATION table:
Create table FND_APPLICATION_BK as (select * from FND_APPLICATION);
2. Delete the invalid record:
Delete FND_APPLICATION where APPLICATION_ID = 111;
3. Save the changes Applied and verify the Transaction Type Form:
Commit;
Ø Operating Unit List of Values Shows: FRM-41830: List Of Values Contains No Entries
If
the previous section does not resolve the issue with the Operating Unit
List of Values in the Transitions Type Form, then the setup for the
Operating Unit needs to be verified. Use the following Receivables
Responsibility
Navigation: Setup > System > Organizations > Organizations
1. In Find Organization window, enter Name = (Operating Unit). Click the Find button.
2. Select the Location Address if missing.
3. Under Organization Classification - From the list of values select the following:
· 'GRE / Legal Entity', check Enabled box, then click Others button and select 'Employer Identification' and enter a number.
· Under
'GRE / Legal Entity' again, select 'Legal Entity Accounting’, click in
field and another window should popup. Enter the Set of Bookstand VAT
Registration Number (this field is not
· Under
'Operating Unit' click on Others button and select 'Operating Unit
Information' and then click in the field. Make sure Legal Entity and Set
of Books are filled-in.
· Back to Organization Classification, select 'Business Group', click on the Others button and enter Business Group Information
· Select
'Inventory Organization' Classification, click on the Others button,
Select Accounting Information, and enter Set of Books and Organization
name.
4. Then run Replicate Seed Data:
Responsibility: System Administrator
Navigation: Request > Run
1. Select Replicate Seed Data for the organization just updated.
2. Verify the concurrent process completed successfully under View My Requests
No comments:
Post a Comment