G-Invoicing: For Advance Seller Facilitated Orders (SFOs), Advance Performance and Advance Receipt Columns Display Incorrect Amounts at Header on G-Invoicing Dashboard (Doc ID 3046224.1)

Last updated on SEPTEMBER 06, 2024

Applies to:

Symptoms

An SFO has a total Order amount of 80 USD. The Order has 2 lines:
   Line 1: advance performance is submitted for 50 USD.
   Line 2: has amount of 30 USD.

In G-Invoicing Dashboard > Header, data of the SFO shows:

   -The "Advance Performance (Pending)" column displays a negative value of -20 USD.
   -The "Advance Receipt" column displays 80 USD, but it should only be 50 USD.

Steps
=====

1. An SFO has a total Order amount of 80 USD. The Order has 2 lines:
Line 1: advance performance is submitted for 50 USD.
Line 2: has amount of 30 USD.

2. Pull the SFO Advance order in Open Status from G-Invoicing to EBS Projects.

3. Execute the "Projects G-Invoicing ECC Data Load" with Load Type = INCREMENTAL_LOAD.

4. In G-Invoicing Dashboard, when viewing the SFO Header, see the followings:

   -The "Advance Performance (Pending)" column displays a negative value of -20 USD.
   -The "Advance Receipt" column displays 80 USD, but it should only be 50 USD.

Cause

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