EAR 9.2: AR Update Is Placing Payment Groups Into Error Code ACTOB "Accounting Entries Out of Balance (6035,4)" When the Payment Worksheet Involves an Item, and On Account Item With Foreign Currency From a Different Business Unit. (Doc ID 2877829.1)

Last updated on NOVEMBER 22, 2023

Applies to:

Symptoms

AR Update is placing Payment Groups into Error Code ACTOB (Accounting Entries Out of Balance) when the Payment Worksheet involves an Item with foreign currency, different Business Unit, and a newly created On Account transaction balancing the amounts.

REPLICATION STEPS:

    1.- Log into the FSCM Online Application as a Receivables User
    2.- Navigate to: Accounts Receivable > Pending Items > Online Items > Online Item Group Entry
    3.- Create a new Pending Item Group under FRAE1 Business Unit, with an Item for 239.20 EUR (200.00 base, and 39.20 VAT) for Customer ID FRA01
    4.- Set the new Pending Item Group into a Post Action of Batch Standard
    5.- Navigate to: Accounts Receivable > Receivables Update > Request Receivables Update
    6.- Define a new Run Control ID with the Pending Items option selected, Business Unit FRAE1, and launch the process
    7.- Navigate to: Accounts Receivable > Payments > Online Payments > Regular Deposit
    8.- Create a new Regular Deposit under Business Unit US001, using Bank Code USBNK, Bank Account CHCK, and for an amount of 250 EUR, with an Exchange Rate of 1.10 USD per 1 EUR
    9.- At the Payments tab, define Business Unit FRAE1, Customer ID FRA01, and the Item previously created
    10.- Navigate to: Accounts Receivable > Payments > Apply Payments > Apply Payments Worksheet
    11.- Build a new Payment Worksheet for the Regular Deposit and Payment transaction previously entered
    12.- At the Worksheet Application tab, follow the below steps in the sequential order listed:
         a) Find the Item in question, select it, and modify the amount from 239.20 EUR to only 200.00 EUR
         b) Create a new row in the Payment Worksheet
         c) Populate the Pay Amt field with -50.00
         d) Click the look-up from Entry Type, and choose the value OA (On Account)
         e) Click the look-up from Business Unit, and choose the value US001
         f) Click YES on the Warning Message (6040,618)
         g) Click the look-up from Reason Code, and choose the value DUET
         h) Save the Payment Worksheet at this stage
    13.- Once balanced, place the Payment Worksheet into a Post Action of Batch Standard
    14.- Navigate to: Accounts Receivable > Receivables Update > Request Receivables Update
    15.- Define a new Run Control ID with the Payments option selected, add Business Units FRAE1 and US001, and launch the process
    16.- Confirm that AR_UPDATE AE Program has completed successfully
    17.- Navigate to: Accounts Receivable > Receivables Update > Correct Posting Errors > Payment
    18.- Verify that the Payment Group has not been posted, and instead, both the original Item (Business Unit FRAE1), and the new On Account Item (Business Unit US001), have been flagged with Error Code ACTOB

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps PDF Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

ERROR MESSAGE:

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.