My Oracle Support Banner

PO Change History Not Showing Version Changes If Release Number Greater Than 20 Characters (Doc ID 2695049.1)

Last updated on JULY 28, 2020

Applies to:

Oracle iSupplier Portal - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

Problem Summary
---------------------------------------------------
PO Change History not showing version changes

Problem Description
---------------------------------------------------
PO Change History not showing version changes for PO releases when the concatenated field (PO-Release Number) exceeds 20 characters. Issue in POS_COMPARE_REVISIONS.compare_header package for variable c_po_num of type po_headers_archive_all.segment1%TYPE.

ERROR
-------------------
ORA-06502: pl/sql: numeric or value error: character string buffer too small


STEPS
-------------------
1. Login to the E-Business Suite and choose the Purchasing Module.
2. Navigate to Purchase Orders -> PO Change History
3. Error is shown

Cause

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
Symptoms
Cause
Solution
References


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