R12: CE: Create Accounting Program Report Errors: 0, 95274, 95300, 95308, 95311, 95313, 95325, 95334, 95337, 95340, 95353, 95357, and 95937 (Doc ID 1271906.1)

Last updated on MARCH 13, 2024

Applies to:

Symptoms

1: Error Number 0:

1. Create a bank account transfer between a USD (USD Functional ledger) bank account and a SGD (SGD Functional Ledger) bank account. The Transfer process works fine but when the cashflows are cleared via reconciliation the accounting does not generate for the FX Gain/Loss account.

Line Error Number Error Message
2      0 The account on the gain or loss line is invalid. If you have a gain/loss journal line type defined, please verify the account derivation rule attached to it on the journal line definition. If not, verify the value of the source mapped to the accounting attributes Exchange Gain Account and Exchange Loss Account.

Error Number       Error
------------------ -------------------------------------------------------------------------------------------------

0    There is no entered amount for the subledger journal entry line. Please inform your system administrator or support representative that:

The source assigned to the accounting attribute Entered Amount has no value for extract line number 0.  
Using the Accounting Attribute Assignments form, assign a source to the accounting attribute Entered Amount that provides a valid value.

3. Import Application Accounting Definitions Report errors as follows:

Error Number       Error
------------------ -------------------------------------------------------------------------------------------------
0                  Errors occurred while uploading Application Accounting Definition data from the data file
                   /app01/SCPR/apps/apps_st/appl/ce/12.0.0/patch/115/import/US/CEXLAAAD.  Please review the log from
                   concurrent request 3792150 for additional information.

Steps to Reproduce:
Cash Management > Bank Account Transfers > Create Transfer between USD and SGD account > Apply and Validate Transfer > Reconcile Bank Account Transfer to Bank Statement > Create Account > Accounting completes with the above error message.

2: Error Number 95334:

Bank transfers are not getting accounted when the bank account currency is different from the Ledger currency to which the bank account is associated.
You defined 2 cash pool accounts for your bank accounts.The bank account currency is defined as EUR and the the ledger associated with this bank account has USD as its currency.
when you generate cash flows using sweep generation program and reconcile and try to run create accounting for these transactions you encounter the following error message:

95334 A conversion type is required when the entered currency is different from the ledger currency. Please enter a conversion type for line -1..

Steps:
1.Navigate to any cash responsibility
2.create a bank account with eur currency
3.associate this bank account to a ledger having different currency.
4.Run the sweep generation program
5.run auto reconciliation program
6.the sweep transaction will be reconciled
7.run the create accounting program and the create accounting ends in warning and you get to see the above error message.

3: Error Number 95300:

The access set XXXX assigned to the system profile option GL: Data Access Set does not include read and write privileges for the ledger YYYYYY and the balancing or management segment value. Please use the Data Access Sets window in General Ledger to include read and write privileges for the ledger and segment values or assign a different ledger access set to the system profile option.

4: Error Number 95313:

The entered amount and accounted amount for line 4 are not equal. The entered amount and accounted amount must be equal when the entered currency is the same as the ledger currency. Please update the entered or accounted amount for line 4.

5: Create Accounting program error Number 95274:

95274: There is no application accounting definition available for the application Cash Management and the subledger accounting method Encumbrance Accrual owned by Oracle. Either no application accounting definition is assigned to the subledger accounting method, or the GL date of the accounting event does not correspond to the effective date range of any application accounting definitions assigned to the subledger accounting method. Please assign an application accounting definition to the subledger accounting method or update the effective date range of any application accounting definitions contained in the subledger accounting method.

6: Create Accounting program error Number 95937:

There are either non-accountable events existing in the system, or events which could not be processed because no data could be found on transaction objects. Please enable the profile option SLA: Enable Diagnostics,create accounting again, and run the report Transaction Objects Disagnostics to identify the problem.

7: 95325 - The GL date is not in an open or a future enterable period. Please select a valid GL date or open the period.

8: 95353 - Sub ledger Accounting was unable to derive an accounting code combination using the account derivation rule Cashflow Offset Account owned by Oracle. Please review the account derivation
rule and make sure it derives a valid accounting flex field combination for the source values passed for the transaction.

9: 95340 The total debits and the total credits do not balance for this subledger journal entry.

Please ensure that the application accounting definition Cash Management Standard Accounting owned by Oracle contains journal line types for the event class Bank Account Transfers and event type Bank Account Transfer Cleared that can create a balanced entry. Also verify that any conditions associated with a journal line type are correct.

10: 95357 There is a missing system source value.  

Please inform your system administrator or support representative that: There are no values for the system source Transaction Number used by Oracle Subledger Accounting.

11: Create Account process for Cash Management has the following error: An internal error has occurred in the program xla_accounting_pkg.ValidateAAD. ORA-0000: normal, successful completion.

The application accounting definition Cash Management Standard Accounting owned by Oracle is not validated. Please validate the application accounting definition or update the application accounting definitions contained in the subledger accounting method Standard Accrual.

or

Please validate the application accounting definition or update the application accounting definitions contained in the subledger accounting method Encumbrance Accrual.

12: Subledger Accounting Program Report shows: Error Message: 95937 There are either non-accountable events existing in the system, or events which could not be processed because no data could be found on transaction objects.

Please enable the profile option SLA: Enable Diagnostics,create accounting again, and run the report Transaction Objects Diagnostics to identify the problem.

(2). Files involved:
CEXLAAAD.ldt:
cexlaevt.ldt:
cevw.odf

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.