G-Invoice Seller Servicing Organization Group and Billing Frequency are Null for Oracle Contracts (OKC) Related Agreement (Doc ID 2961947.1)

Last updated on APRIL 15, 2024

Applies to:

Symptoms

G-Invoice Seller Servicing Organization Group and Billing Frequency are becoming null for Oracle Contracts (OKC) related project agreement.

Sequence of events:

1. The Requesting Agency Order came with period of performance 01-APR-2021 – 31-MAR-2026.
2. Servicing Agency created the project with start date of 17-JAN-2023 – 31-MAR-2026.
3. The Project Contract Integration created the project and the OKC agreement and projects agreement with 17-JAN-2023 – 31-MAR-2026.
4. LINK_IGT_AGREEMENT Application Product Interface (API) was submitted and it was successful.
5. IGT_ORDER_ASSOCIATE_PRJ was submitted but it failed with the error that project start date should be on or before the period of performance (POP) start date.
6. The user went in and corrected the project start date and end date to match POP dates.
7. The user went in and corrected the OKC contract and funding start and end date to match POP dates and used the create update agreement from Project Contracts.
8. IGT_ORDER_ASSOCIATE_PRJ was re-submitted and it worked.
9. IGT_UPD_POBG_HEADER worked.
10. IGT_UPD_POBG_LINES failed with Treasury Account Symbol (TAS) error, as the query is looking at PA_AGREEMENT_VERSIONS.SER_GROUP_ID.
    
    
    

Cause

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