26130622 Revision Not Appearing When Updating PO With Excel In BWC (Doc ID 2281937.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle Purchasing - Version 12.2.6 and later
Information 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

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