EAR9.0+: Automatic Maintenance Worksheet Is Generating Unbalanced Accounting Entries. (Doc ID 1939646.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9 version, Automatic Maintenance

ACTUAL BEHAVIOR
---------------
Automatic Maintenance Worksheet is generating unbalanced accounting entries for entry use ID MT-01.
PS_PENDING_DST is having incorrect FOREIGN_CURRENCY where SYSTEM_DEFINED = 'Y'.

EXPECTED BEHAVIOR
-----------------------
Automatic Maintenance Worksheet should generate balanced accounting entries for entry use ID MT-01.

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

Setup:

Replication steps:

  1. Create a foreign currency debit bill for business unit US001 and customer CAN01.
    • Item currency is CAD.
    • Make sure Rate Type = AVG.
    • Entry Type = IN.
  2. Add 2 lines.
    • 1st line has PC Bus Unit, Project, Activity populated, 2nd line has PC Bus Unit, Project, Activity and Source populated.
    • Enter Acctg – AR Offset and make sure to enter Dept.
    • Enter Acctg – Rev Distribution and make sure to enter Dept.
  3. Change bill status to RDY.
  4. Run Finalize and Print Invoices.
  5. Run Load Invoices to AR.
  6. Run ARUPDATE.
  7. Adjust entire bill, Credit Entire Bill.
  8. Run Finalize and Print Invoices.
  9. Run Load Invoices to AR.
  10. Run ARUPDATE.
  11. Run Automatic Maintenance process.
  12. Run ARUPDATE.
  13. Maintenance worksheet is not balanced and is in Error (ACTOB).


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use Automatic Maintenance to offset debit to credit.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms