After Patch 14383315 Cannot Submit for Approval BPAs/POs when Buyer Has no Username Associated APP-PO-14142 Unexpected Error (Doc ID 1512512.1)

Last updated on AUGUST 21, 2016

Applies to:

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

Symptoms

After applying <Patch 14383315>:R12.PO.B, when attempting to approve a Blanket Purchase Agreement (BPA) or Purchase Order (PO) with a buyer who does not have any username associated, the following errors occur:
 
In Purchase Orders form:

APP-PO-14142: In Exception of
Start_WF_Process()-PO_REQAPPROVAL_INIT1.Start_WF_Process: In
Exception handler: ORA-01403: no data found

Cause: A SQL error has occurred in In Exception of
Start_WF_Process(). The SQL error is ORA-01403: no data found

Action:
Take note of both this error number and the actions you were trying to
perform. Contact your system administrator for further assistance.

 
In Buyer Work Center:

Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.

 
After clicking the here link:

 

Steps
The issue can be reproduced at will with the following steps:

1. Navigate through Purchase Orders > Purchase Orders
2. Create Blanket Purchase Agreement or PO
3. Enter a buyer who does not have any username attached
4. Click the OK button

1. Navigate through Buyer Work Center > Agreements
2. Create Blanket Purchase Agreement or PO
4. Enter a buyer who does not have any username attached
5. Click the Submit button
 

Changes

 Applied <Patch 14383315>:R12.PO.B.

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