My Oracle Support Banner

R12: Revenue Amounts DOUBLED On Projects And Posted To GL - Data Corruption (Doc ID 2599929.1)

Last updated on DECEMBER 21, 2020

Applies to:

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

Symptoms

A number of projects were revenue generated, accepted, and transferred to GL.  A number of projects shows the revenue amount is DOUBLED on what it should be. On the projects identified so far, all seem to have similar symptoms:

1. EVENT amount doubled on Draft Revenue line.
2. EVENT amount on Event Inquiry screen look fine/normal and tie out appropriately to the amount expected them to be.
3. 1 random item on the Draft Revenue has a LARGELY inflated revenue amount that makes no mathematical sense for the given item.

All revenues generated without error. Transferred and accounted without error.

Found/followed 3 MOS notes that seem to suggest this is related to customer Bill To sites. Have confirmed for the ones identified so far, that it SEEMS this is related to the fact that Customer Bill TO address was changed recently,
so that the site now has TWO records that indicate "Bill To" site use and BOTH of those customer account site use records are ACTIVE.


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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