ECM: Automated Accounting Abends at Step TR_ACCTG.TRA5000.TRA5011 With a Unique Constraint Error When Two Different Chartfields Are Defined With the Same Value and Both Are Inactive (Doc ID 2972589.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Symptoms

Automated Accounting abends at Step TR_ACCTG.TRA5000.TRA5011 with an error when there are two different chartfields that are defined with the same value and both of the chartfields are Inactive. If one of the chartfields is Active, process will complete to Success.

STEPS
1. Navigate to Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > Define Values > Define ChartField Value > Department
    a. Display Department = 13000
    b. Status = Active
2. Define ChartField Value > Product
    a. Add Product = 13000
    b. Status = Active
3. Navigate to Cash Management > Treasury Accounting > Accounting Templates
    a. Display Accounting Template ID = BSP-BANKTRANFEE
    b. Specify Department = 13000 / Product = 13000
4. Display Department = 13000
    - Change the Status to Inactive
5. Display Product = 13000
    - Change the Status to Inactive
6. Navigate to Banking > Bank Statements > Enter Bank Statements
    a. Enter a Bank Statement for a Bank ID / Account #
    b. Specify Bank ID / Account #
    c. Enter Reference and Transaction Amount
    d. Trans Code = Fee Expense
    e. Activity Type = BKFEE
7. Navigate to Banking > Reconcile Statements > Automatic Reconciliation
    a. Select the above Bank Statement to reconcile
    b. Click Run Recon
    c. Click Refresh
    d. Exceptions link will appear
    e. Click the Exceptions link
8. Automatic Reconciliations Exceptions page will display
   - Bank Statement has the Exception of Miscellaneous Transaction
9. Navigate to Banking > Reconcile Statements > Process Statement Accounting
    - Run Bank Statement Accounting for the above Bank Statement to create External Transactions
10. Navigate to Banking > Analyze Exceptions > Auto Reconciliation Exceptions
      a. External Transactions created
      b. Check the box besides External Transactions
      c. Run Reconcile
      d. Click OK to the message -- 1 transaction with a net difference amount of 0 was forced to reconcile (9550,10)
11. Navigate to Cash Management > Treasury Accounting > Automated Accounting
      a. Run Automated Accounting for Accounting Sources = Bank Statements to create Accounting Entries
      b. Process abends at Step TR_ACCTG.TRA5000.TRA5011 with the above error

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.