Purchase Order number Removed when Updating Using Excel Sheet or BSO Webservice

(Doc ID 2365431.1)

Last updated on APRIL 25, 2018

Applies to:

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

Symptoms

On : 12.2.6 version, HTML Orders

After updating PO using excel sheet, the - in the PO number is no longer visible in the core PO form or in the PO tables

Steps to Reproduce :
-----------------------
1. Create a PO from forms and approve e.g. 081817-TEST is the PO number.
2. Now change the Qty from BWC -> Update from Excel. (Note: PO number is not being changed but the Qty)
3. When checking from form, the PO number changes to 081817TEST without the '-'
4. When checking from BWC, the PO number still shows as 081817-TEST.

The same issue can be seen if the PO is updated using the BSO webservice instead of update from excel

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