My Oracle Support Banner

G-Invoicing : Unable To Pull Order From G-Invoice To ECC Dashboard When Postal Code Has '-' in The Middle With Error ORA-06502 Populated in GT_DOCUMENT_REQUESTS.INTERNAL_DOCUMENT_STATUS (Doc ID 3078552.1)

Last updated on MARCH 28, 2025

Applies to:

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

Symptoms

Request agency created an order with 9 digit Ship To Postal code (22041-3803). When user runs the "Intragovernmental Orders Interface Program" to pull the order, it is not getting populated in ECC dashboard.
IGT_DOCUMENT_REQUESTS.INTERNAL_DOCUMENT_STATUS is populated with error:

ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind


Steps to reproduce:

  1. Request agency create an order with 9 digit postal code.
  2. Run Intragovernmental Orders Interface Program.

 

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