My Oracle Support Banner

Receives Error ORA-06502 When Calling the API QP_PRICE_BOOK_PUB.Get_Price_Book (Doc ID 1900301.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Advanced Pricing - Version 12.1.3 and later
Information in this document applies to any platform.


On :  12.1.3 version, Price Book

When attempting to run wrapper code to call API QP_PRICE_BOOK_PUB.Get_Price_Book ,
the following error occurs.

ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
ORA-06512: at "APPS.QP_PRICE_BOOK_PUB", line 699
ORA-06512: at line 34

The issue can be reproduced at will with the following steps:
1. Run wrapper code that calls the API QP_PRICE_BOOK_PUB.Get_Price_Book

The issue has the following business impact:
Due to this issue, users cannot use the API to query an existing price book.

This is impacting their development phase


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.