Create Internal Orders fails with Error: 'Error updating req headers' 'ORA-01733: virtual column not allowed here'
(Doc ID 2986135.1)
Last updated on NOVEMBER 15, 2023
Applies to:
Oracle Purchasing - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
The create Internal Orders program completes with an error even after solution from Doc ID 2862799.1 implemented and the program log file shows the below error :
Begin create internal sales order
Updating Req Headers
Error updating req headers
In raw trace, error ORA-01733 is captured for the following statement:
PARSE ERROR #140356485928128:len=486 dep=1 uid=118 oct=6 lid=118 tim=20264022057557 err=1733
UPDATE PO_REQUISITION_HEADERS PRH SET PRH.TRANSFERRED_TO_OE_FLAG = 'I' WHERE PRH.AUTHORIZATION_STATUS = 'APPROVED' AND PRH.REQUISITION_HEADER_ID IN (SELECT /*+ index ( PRL po_requisition_lines_f5 ) */ DISTINCT PRL.REQUISITION_HEADER_ID FROM PO_REQUISITION_LINES PRL WHERE NVL(PRL.LINE_LOCATION_ID,- 999) = - 999 AND PRL.SOURCE_TYPE_CODE = 'INVENTORY' AND NVL(PRL.TRANSFERRED_TO_OE_FLAG,'N') = 'N' AND NVL(PRL.CANCEL_FLAG,'N') = 'N' AND NVL(PRL.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED')
The issue can be reproduced at will with the following steps:
1. Responsibility: Purchasing
2. Reports/Run - Single Request - Create Internal Orders
3. Review the Concurrent Request Log - and note the error
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 |
| Cause |
| Solution |
| References |