My Oracle Support Banner

When Attempting to Create a Backorder on a PO using the Create Backorder button the system gives an error "A SQL error occurred. Please consult your system log for details" (Doc ID 2924664.1)

Last updated on JANUARY 30, 2023

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When creating a PO backorder for an Item on a PO, we enter a Due Date , Qty then click on the 'Apply Backorder and Save' button the system generates an error. 



The issue can be reproduced at will with the following steps:
1. Navigate to Add/Update POs (Purchasing-->Purchase Orders--> Add/Update POs)
2. Add a new PO with Multiple Lines
3. Save the PO
4. Click on Dispatch button from within the PO
5. Click Ok then Yes to wait for the PO
6. Navigate to Add/Update Receipt  (Purchasing-->Receipts-->Add/Update Receipts)
7. Search Criteria enter the BU and PO
8. Click Search
9. Select the PO
10. Receive the PO but for the last line only receive part of the Qty.
11. Navigate to Add/Update POs (Purchasing-->Purchase Orders--> Add/Update POs)
12. Search for the PO from Step 1 above.
13. Click on the Create Backorder link
14. Enter a Due Date and Qty
15. Click on Apply Backorder and Save button
16. Receive an error
A SQL error occurred. Please consult your system log for details.

Changes

 

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
Changes
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.