PO Upload With New Item/Location Runs Long - Missing JOIN On SUPS When Bracket Costing (Doc ID 3015962.1)

Last updated on APRIL 17, 2024

Applies to:

Symptoms

On : 16.0.3 version, Other

PO Upload with New Item/Location Runs Long - Missing JOIN on SUPS when Bracket Costing

When uploading a Purchase Order that contains item(s) not yet ranged to the purchase order location and Bracket Costing is enabled, the ranging of the new item/location runs long due to a missing join in the ITEM_SUPP_COUNTRY_BRACKET_COST processing.

Bad SQL from NEW_ITEM_LOC_SQL.PERSIST_ITEM_SUPP_COUNTRY_LOC with missing join on SUPS in the MERGE INTO ITEM_SUPP_BRACKET_COST.


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

1) Create an ODS file containing a purchase order with at least one item not yet ranged to the location on the purchase order.
2) Tasks -> Orders -> Upload Orders From File
3) Template -> Purchase Order, Source -> Choose file from Step #1, Destination -> RMS Tables -> Press Upload
4) Notice SQL ID runs long.

Cause

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