EAR 9.2: ARUPDATE Flags Payment Accounting Entries as "ACTOB" on Group with Foreign Currency, Interunit and 0.01 Cent Rounding Difference (Doc ID 2747332.1)

Last updated on MARCH 01, 2023

Applies to:

Symptoms

AR Update is getting error as Payment Group with Accounting Entries Out Of Balance ACTOB) on a scenario where Foreign Currency, InterUnit, Different Exchange Rates (Item vs Payment), Realized Loss/Gain rows generate a one penny rounding difference (0.01).

ACTOB error is received for an item with too many lines (2388 lines) and is due to a difference of 0.01 as it can be seen in PS_ITEM table.

ERROR
----------
Error Code: ACTOB with below message

REPLICATION STEPS
-----------------------
The issue can be reproduced at will with the following steps:

A. Preparing to run a new test on demo environment for an invoice with 2388 lines:
1. Modified insert SQL statements that customer provided so that they comply with our demo environment data:
Business_Unit as 'IND01'
Cust_ID as 'IND01',
BUSINESS_UNIT_GL as 'IND01'
GROUP_BU as 'IND01'

2. Run them on the database consecutively for ITEM, ITEM_DST, ITEM_ACTIVITY, PENDING_ITEM,PENDING_DST tables - so that we have now in the database problematic item (ITEM ID ABC - 121,440.00 EUR, BU IND01, Customer IND01), the same information that customer has.

B. Setup environment as per customer’s setup:
1. Define Market Rates under Market Rate page (Set Up Financials/Supply Chain / Common Definitions / Market Rates include history)
Check also PS_RT_RATE_TBL table to be as it is on customer’s end
2. Set Up Financials/Supply Chain / Install / Installation Option/Overall - Multibook entries in Subsystem and InterUnit Method is set as Direct
3. General Ledger/Ledgers/Ledger Groups - Definition/Chartfields/Balancing tabs - Setup on our end is with Local
As per our setup, Reporting has to be replaced with Local (as it can be seen in Ledger Group screenshot, we have Local while customer is having Reporting)
UPDATE PS_ITEM_DST
SET LEDGER=’LOCAL’
WHERE LEDGER='REPORTING'
AND ITEM='problematic item';
4. Set Up Financials/Supply Chain > Business Unit Related > General Ledger > General Ledger Definition- Currency Options tab for BU IND01;
5. Set Up Financials/Supply Chain > Business Unit Related > General Ledger > Ledgers For A Unit - check especially Currency Options tab to be similar with customer's;
6. Banking/Bank Account/External Bank Account for Bank Code - GL Unit is setup as IND03 for the back that we will use when creating the deposit (different than BU for item, which is IND01);
7. Set Up Financials/Supply Chain / Common Definitions / Design ChartFields / ChartField Inheritance / ChartField Inheritance / Receivables and Billing -only Project is selected as Always Inherit, the rest are as Do not Inherit;
8. Put traces for ARUPDATE- AR_PGG1, AR_POST1, AR_UPDATE, AR_UPDATE2 -TRACE 391 -TOOLSTRACESQL 135 -TOOLSTRACEPC 4044

C. Replication steps:
1. Create deposit manually having Deposit Unit IND01 and amount as of 124,470.00 EUR and reference the item (Item ID ABC of 121,440.00 EUR)
2. Click on Apply Payment link
3. Click on Build
4. Click on plus button
5. Click on OK
6. Populate new line created with (minus amount) so that Remaining will be 0, populate any value for Item ID field and put the item OA (select Type as OA);
7. Click on Worksheet Action link
8. Select Action as Batch Standard
Click on OK
Click on Save
9. Run ARUPDATE
Group UNIT is IND01, Always is selected
Click on Save
Click on Run
10. ARUPDATE runs with success
11. Go to Payment navigation path under Accounts Receivable/Receivable Update/Correct posting Error/Payment
12. Populate Deposit Unit, Group Unit and Business Unit as IND01 and click on Search
13. Click on Item ID ABC which has Accounting Entries as Incomplete
14. Accounting Entries are not balanced
15. Go to Payment 1 tab under Accounts Receivable/Receivable Update/Correct Posting Error- Error code ACTOB error can be seen for this item
16. There are 11 lines generated:
- 4 for AR type
- 2 as InterUnit Type
- 4 as Real G/L Type
- 1 as Cash Ctrl Type
17. Check data from table:
select * from PS_PENDING_DST where ITEM='ABC' and DOC_TYPE<>'AR-INV'and GROUP_ID='10'

there is 0,01 difference for Sum of Monetary Amount column.

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.