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.


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.

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

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


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.