My Oracle Support Banner

Purchase Order PO Upload Patch UOM While Uploading Using WEBADI (Doc ID 3054418.1)

Last updated on OCTOBER 21, 2024

Applies to:

Oracle Purchasing - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

Error- PO Upload Patch UOM while uploading WEBADI PO Upload Patch UOM

ERROR
-----------------------
1220000505oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT distinct muc.unit_of_measure unit_meas_lookup_code, muc.unit_of_measure_tl unit_meas_lookup_code_tl, muc.description, muc.uom_class, muom.uom_code FROM mtl_uom_conversions_val_v muc, mtl_units_of_measure muom WHERE (muc.uom_class IN ( SELECT mcc.to_uom_class FROM mtl_uom_class_conv_val_v mcc WHERE mcc.inventory_item_id = :1 ) OR muc.uom_class = :2 OR :3 is null ) AND ( :4 = 'N' OR ( :5 = 'Y' AND :6 = muc.uom_class ) OR :7 = 'Y' ) AND muc.item_id = 0 AND muc.unit_of_measure = muom.unit_of_measure AND ( :8 = 'N' OR (:9 = 'Y' AND muom.ATTRIBUTE_CATEGORY = 'Federal IGT UOM' AND muom.ATTRIBUTE1 = 'Y' ) )) QRSLT WHERE (unit_meas_lookup_code_tl = :8) ORDER BY upper(unit_meas_lookup_code)



STEPS
-----------------------
The issue can be reproduced at will with the following steps :

Navigation:  Purchasing User responsibility - > Buyer Work Center - > Orders
Select Go to Create a new Standard Purchase Order
• Enter Header Information
• Select Save
• Select Lines tab
• Select Update with Excel from the Actions dropdown
• Select Go
Select Create
This screen will appear while the spreadsheet is downloading
Select Open
• Select Enable Content
• Enter Required fields for each line (See below)

(Line Number, Line Type, Item Description, Category, Quantity, Unit of Measure, Unit Price, Need-by-Date, Enter (1) for Schedule Number/Pay Item Number, Enter (1) for Distribution Number, Charge Account (Division, Location, Department, Natural Account, Sub Account, Intercompany, Future)
Note* Double click in the filed for a LOV

• Select Upload from the Oracle tab
• Select Upload
• Confirmation page will appear.
• Close Upload Page and spreadsheet

Once user completes the steps above, the upload does not appear on the line.
Select the incomplete order
Select Excel Import Status.
View details


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


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