My Oracle Support Banner

NEGOTIATED_ITEM_COST Column Is Not Updated For FUTURE_COST,ITEM_SUPP_COUNTRY_LOC ,ITEM_SUPP_COUNTRY Tables (Doc ID 2404740.1)

Last updated on JUNE 01, 2018

Applies to:

Oracle Retail Merchandising System - Version 14.0.2 and later
Information in this document applies to any platform.

Symptoms

NEGOTIATED_ITEM_COST column is not updated in the FUTURE_COST, ITEM_SUPP_COUNTRY_LOC, ITEM_SUPP_COUNTRY tables.

Steps to Reproduce:

1. Create an item.
2. Create off invoice Promotional Deal with 10% and approve it.
3. Query the Future_cost table and note  NET_COST is updated but the NEGOTIATED_ITEM_COST is not.

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!


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