R12.2: Update_Project API Errors Out If Projects Have Customer Name Longer Than 80 Characters
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.
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.
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