Cannot View Document For The Publish Price Book - ORA-06502: PL/SQL: numeric or value error: character string buffer too small

(Doc ID 756044.1)

Last updated on APRIL 12, 2017

Applies to:

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

Symptoms

 -- Problem Statement:

Cannot view document after created the price book, there is no value in view
document. The request has completed with normal, but the error message occurred in log file.

--Error Messages From Log File

QPXPRBKB module: QP: Price Book Generate and Publish
Publish_and_Deliver return status E
Publish_and_Deliver return textJBO-27122: SQL error during statement preparation
...
ORA-06502: PL/SQL: numeric or value error: character string buffer too small

-- Steps To Reproduce:
1.Create price book
2.Publish the price book
   publish option
    Template: Price Book Details[English: United States]
    Data Type: PDF
    Publish: Immediately
3.view document

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