G-Invoicing: General Terms and Conditions (GT&C) Modified by Changing or Adding an Agency Location Code (ALC) Are Not Interfaced to Oracle (Doc ID 2996555.1)

Last updated on JULY 23, 2024

Applies to:

Symptoms

Modifying the General Terms and Conditions (GT&C) by changing or adding the Servicing Agency Location Code (ALC) is not interfaced to Oracle G-Invoicing.

Steps to Reproduce:

1) Create GT&C for ALC
2) Create an order against the GT&C
3) Interface the GT&C and Order to Oracle and run the ECC load
4) GT&C and Order is tied to ALC
5) Modify the GT&C and add the additional ALC and approve it
6) Servicing Agency Rejects the order. Requesting Agency Modifies the Order and change the ALC on the order.
7) Interface the modified GT&C and updated Order to Oracle and run the ECC load

Expectation is to see both ALC’s in the Req_agency_location_code column in GT&C table and ECC ALC is updated in the orders table and ECC. This is causing an inconsistency in ALC information between G-Invoicing and Oracle and also between the GT&C and the Order.

Cause

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