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:

Symptoms

Quantity values for Receivables (AR) invoice and G-Invoicing performance do not match.

Reproducible Steps
==============

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

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

Cause

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