My Oracle Support Banner

AIF/PMO: Why Are Prices in W_RTL_PRICE_IT_LC_G Not Flowing into PRO_PRICE_COST? (Doc ID 3035912.1)

Last updated on AUGUST 09, 2024

Applies to:

Oracle Retail AI Foundation Cloud Service - Version 24.1 and later
Oracle Retail Lifecycle Pricing Optimization Cloud Service Advanced Edition - Version 24.1 and later
Information in this document applies to any platform.

Goal

Prices in the W_RTL_PRICE_IT_LC_G table are showing the correct price amounts. However, when looking up some items in PRO_PRICE_COST, the price does not match the price shown in W_RTL_PRICE_IT_LC_G. This is affecting the Oracle Lifecycle Pricing Optimization (LPO) UI with incorrect prices in some cases.

Example:
select * from PRO_PRICE_COST where PROD_HIER_ID = <PROD_ID>

In the UI, check the Reg Price column, for some items the price is not displaying the expected price.

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.