My Oracle Support Banner

G-invoicing: PARGDR: PRC: Generate Draft Revenue for a Range of Projects Program Generates Revenue for Order Line Schedules That Has No Advance Collected (Doc ID 3022804.1)

Last updated on MAY 15, 2024

Applies to:

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

Symptoms

The "PRC: Generate Draft Revenue for a Range of Projects" program is generating revenue to all the Order Line Schedules even when one of the schedules does not have Advance Performance on it. As a result, the Delivery Performance on those Schedules is being sent to G-Invoicing without a prior Advance Performance.

In addition, the Receivables (AR) Invoice is in Unapplied status.
Subsequent Advance Performance is resulting in the AR Receipt also not getting applied to the prior AR Invoice.

 

Steps
======
1. Create 2 Intragovernmental Transactions (IGT) Orders with One Line, Two Schedules each, with Statutory Authority code as 'Working Capital Fund':
Order 1 Line1 Schedule1 $100
Order 1 Line1 Schedule2 $200
Order 2 Line1 Schedule1 $600
Order 2 Line1 Schedule2 $500

Both IGT Orders are approved in Projects.

2. Advance is collected on 3 of those 4 schedules as follows:
Order 1 Line1 Schedule1 $100
Order 1 Line1 Schedule2 $200
Order 2 Line1 Schedule1 $400 (Partial Advance collected on this schedule)
Order 2 Line1 Schedule2 - No Advance collected on this Schedule

Note:
-All of these Schedules are mapped to One Project and One Top Task.
-The Project has just One Customer, with User Defined Percentages set to 100%.

3. Using a Projects responsibility:
Navigate: Expenditures > Project
Enter an expenditure for $500.

4. Navigate: Other > Requests > Run
Run the "PRC: Generate Revenue for a Range of Projects" program.  Revenue is generating as follows:
Order 1 Line1 Schedule1 $35.72
Order 1 Line1 Schedule2 $71.43
Order 2 Line1 Schedule1 $214.28
Order 2 Line1 Schedule2 $178.57 -- Revenue allocated this Schedule where there was no Advance exists.

 
Revenue should not be generated against Schedules where Advance is not collected. Also, the Revenue generated should be restricted to
the Advance amount available on that Schedule rather than the Total Available Order Amount for allocation.

 

 

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