G-Invoicing: Quantity Values for Receivables Invoice And G-Invoicing Performance Do Not Match
(Doc ID 2929972.1)
Last updated on FEBRUARY 21, 2023
Applies to:Oracle Project Billing - Version 12.2.7 and later
Information in this document applies to any platform.
Quantity values for Receivables (AR) invoice and G-Invoicing performance do not match.
1. Create a G-INV Order. Line 1 has 2 schedules with UOM-Each
2. Pull the Order into Oracle and create a billing event:
Project Billing Super User → Billing → Events
Created a manual event with amount $120.
3. Run the below programs:
-PRC: Generate Draft Invoices for a Single Project. A new draft invoice got created for an amount of $120.
-PRC: Generate Draft Revenue for a Single Project. A new draft revenue got created for an amount of $120.
4. Transfer the invoice to Receivables:
Run the programs:
-PRC: Interface Invoices to Receivables
-Autoinvoice Import Program
-PRC: Tieback Invoices from Receivables
5. AR Invoice line has:
Quantity = 1
Unit Price = $120.00
6. Run "PRC: Process Mass Submission Performances for G-Invoicing" program.
7. PA.PA_PROJ_GINV_PERF_DETAIL table:
select * from PA.PA_PROJ_GINV_PERF_DETAIL
where perf_header_id = <perf_header_id>
order by LAST_UPDATE_DATE desc;
QUANTITY = 120
The G-Invoicing performance is created with:
Quantity = 120
Unit Price = 1
Total Amount = 120
The quantity and unit price are switched between Receivables invoice and G-Invoicing performance.
In other words, the quantity in Receivables and G-Invoicing are not matching.
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