PAXACCPB 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 JULY 10, 2023

Applies to:

Symptoms

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);

Navigation:

> 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.

Cause

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