Thursday, April 29, 2010

R12: Error 95353 When Running Create Accounting Program

Symptoms
When running Create Accounting using SLA with the profile option FA: Use Workflow Account Generation set to Yes at the Site level, the following error occurs:

ERROR
Error Number Error Message
95353 Subledger Accounting was unable to derive an accounting code combination using the account derivation rule Assets Book Default Account for Offset owned by Oracle. Please review the account derivation rule and make sure it derives a valid accounting flexfield combination for the source values passed for the transaction.

FND logging of the accounting program reveals: 'ERROR: XLA_AP_CCID_NULL'




Solution
1. Alter the XXX Generate Default Account process including sub processes XXX: Generate Book Level Account and XXX: Generate Category Level Account, exchanging all NLS Accounting flexfield names used in it with the English name used in the XXX Accounting Flexfield.

2. Save a copy of the altered process on the desktop (FA_ACCOUNTS.wft) and save it also in the database. In the Account Generation Processes window, choose the XXX Generate Default Account process for the FA Account Generator and save it.

3. Run Generate Accounts.

4. Verify that the default AAD (Application Accounting Definition) is still valid.

5. Run Create Accounting.

6. To apply the solution on other instances, it will only be necessary to load FA_ACCOUNTS.wft into the database and perform steps 2 to 5.


for more information refer here
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=553091.1

No comments:

Post a Comment

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...