My Oracle Support Banner

R12.2: Update_Project API Errors Out If Projects Have Customer Name Longer Than 80 Characters (Doc ID 2153027.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Foundation - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On 12.2.4:

Customer is using standard Oracle APIs.
They execute two APIs one by one: create_project with customer name more than 80 characters and then update_project and after that receives the following error:

"ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind in Package PA_TOP_TASK_CUST_INVOICE_PVT Procedure Get_Highest_Contr_Cust ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind in Package PA_PROJECT_PUB Procedure update_project"

-Issue only happens with projects created from API.  Also, only happens when customer name is more than 80 characters.

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!


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