My Oracle Support Banner

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 later
Information in this document applies to any platform.


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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.