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

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 hundreds of Community platforms