My Oracle Support Banner

G-Invoicing - Intragovernmental Agreements (GT&C) Interface Prog Errors When There Are Multiple Requesting Agency ALCs: PL/SQL: numeric or value error: character string buffer too small (Doc ID 2862125.1)

Last updated on APRIL 11, 2022

Applies to:

Oracle Project Billing - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

GT&Cs cannot be pulled into the servicing side (Projects) when the GT&C contains multiple ALCs (Agency Location Code) for the requesting agency.

This feature has been available since Phase II of the G-Invoicing solution.

However, when looking up the record type IGT_GTC_REC in the package PA_IGT_GTC_PKG, it is defined as type VARCHAR2(8), which can accommodate only one ALC.

Reproduce By Steps

1. Create a new GT&C with multiple ALCs for Servicing Agencies
2. Place an Order against this GT&C and pull GT&C, Order
3. Run the concurrent program Intragovernmental Agreements (GT&C) Interface Prog and receive the following error.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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