My Oracle Support Banner

Booking Large Order: Exception In QP_PREQ_PUB.Populate_buy_line_price_flag ORA-56502 (Doc ID 2274528.1)

Last updated on NOVEMBER 21, 2018

Applies to:

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


Book an order with over 1000 lines and receive the following error message.
There is a promotional good modifier (PRG) being applied.
This modifier has been working for years with normal size orders (under 100 lines). Now we want to use it on these large orders (over 1000 lines).
Small/larges orders have same customer and order type and modifier on a small test order works.


Exception in QP_PREQ_PUB.Populate_buy_line_price_flag ORA-56502 PL/SQL numeric or value error: character string buffer too small.


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

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