26130622 Revision Not Appearing When Updating PO With Excel In BWC
(Doc ID 2281937.1)
Last updated on MARCH 15, 2022
Applies to:
Oracle Purchasing - Version 12.2.6 and laterInformation in this document applies to any platform.
Symptoms
Cannot update PO Line with item with revision with Excel in BWC using WEB ADI
Line with item with item Revision does not get processed.
Web ADI process ends with warning.
Error in Purchase Orders Spreadsheet Import output file:
6574oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement
preparation. Statement: SELECT * FROM (SELECT revision,
max(effectivity_date) effectivity_date
FROM mtl_item_revisions mir,
org_organization_definitions ood,
financials_system_parameters fsp
WHERE... ..
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 |