R12: PA: Project Accounting: Revenue Adjustments Error (Doc ID 1915742.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 02-FEB-2016***

Symptoms

On : 12.1.3 version, Revenue

ACTUAL BEHAVIOR
---------------
Project Accounting: Revenue Adjustments error

While preparing for the July month-end, users have noticed that they have several PA events that haven't been posted to the General Ledger. In total, they have 95 events in 8 different ledgers, which are all revenue adjustments.
The 'PROCESS_STATUS_CODE' of the XLA_EVENTS table is "I" and the error in the XLA_ACCOUNTING_ERRORS table is "The subledger journal entry does not balance in the entered currency. Please verify the entered amounts on the journal entry lines."

Error Codes
---------------------------------------------------
No code - error message is "The subledger journal entry does not balance in the entered currency. Please verify the entered amounts on the journal entry lines"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the process PRC: Generate Draft Revenue

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
This is a production issue and users will not be able to close the month of July if these issues are not fixed.
It affects 8 ledgers and 95 events in total.
They need to solve this as soon as possible or they may encounter problems closing their books for the month of July.

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