My Oracle Support Banner

Receipts Workbench Issue: Datafix: AR Create Accounting Does Not Pick Data For Accounting (Doc ID 2048772.1)

Last updated on JUNE 07, 2021

Applies to:

Oracle Receivables - Version 12 and later
Information in this document applies to any platform.


User is not able to post receipts and transactions to GL and as a result unable to close periods

Few receipts which are using Multi-Fund Account, is not getting accounted because of error message:

0 The subledger journal entry does not balance in the entered currency.
Please verify the entered amounts on the journal entry lines.

Though event is created and stamped on all the AR & XLA tables, no data
exists for that event in xla_events table.

From the the data in xla_events and found that event_id doesn't exist.
There are few events which are having the event_status_code as 'Z'

Same is the issue for the transactions too.

Fix Approach
a. event_id has to be nulled out for such transactions/receipts.
b. New event_id has to be stamped in RA,GLD,CRH.




To view full details, sign in with your My Oracle Support account.

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

In this Document
 Still Have Questions?

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