My Oracle Support Banner

Create Accounting Revenue Errors - The Subledger Journal Entry Does Not Balance in the Entered Currency. Please Verify the Entered Amounts on the Journal Entry Lines. (Doc ID 2886775.1)

Last updated on AUGUST 17, 2022

Applies to:

Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.


PRC: Create Accounting in the Projects module completes.  The Subledger Accounting Program Report display the following error:

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

Original transactions were reversed previously which made the original and reversed transactions as net zero.  Cost had been distributed on all original and reversal transactions, but the revenue on two reversed transactions show as "Event is invalid in Subledger Accounting'.

Running the following SQL shows the problem revenue.

select *
  from pa_draft_revenues_all b
 where b.event_id in (select event_id
  from xla_events
  where event_type_code in ('REVENUE', 'REVENUE_ADJ')
  and event_status_code = 'U'
  and process_status_code = 'I'
  and event_id = &event_id
  and application_id = 275);


> Projects responsibility > Other > Requests > Run.

In the Submit Request screen, pull up the process name, PRC: Create Accounting.  Enter Revenue for the Process Category.  Enter all the other required parameters.



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

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