PO Creation Process Failed In Sourcing And Creates Document With Negative Numbers

(Doc ID 1479616.1)

Last updated on JULY 07, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Oracle Sourcing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to create a purchase order from an RFQ, the following error occurs.

ERROR
-----------------------
X Error
Purchase Order Creation could not be initiated. Please check with your system administrator.

FND debug log shows the following:

Start of subprogram.
x_from_entity_name = PON_BID_HEADER_ATTRIBUTES
x_auction_header_id = 48002
x_auction_line_number is null
x_bid_number = 31002
x_bid_line_number is null
x_to_entity_name = PO_HEADERS
x_to_pk1_value = 95006
p_auction_payment_id is null
PON_AUCTION_PO_PKG: GET_ATTACHMENT: EXCEPTION handling pk1:48002 pk2: 31002 pk3: attachmentType: PON_BID_HEADER_ATTRIBUTES
x_errorcode = FAILURE
x_errormessage = ORA-06502: PL/SQL: numeric or value error: character string buffer too small



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Sourcing > Negotiations and Select RFQ 35002.1 and try to create PO
2. Select on Actions “Create Purchase Order” and click on “Go”
3. Submit the process
4. See the following error:
Purchase Order Creation could not be initiated. Please check with your system administrator.
5. Change responsibility to core Purchasing and N>Purchase Orders>Purchaser Summary
6. Open and no lines are displayed, PO number is negative -62001

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