Issues With Future Cost Data When Trying To Change The ACTIVE_DATE Of A Future Approved Deal (Doc ID 2223163.1)

Last updated on APRIL 07, 2017

Applies to:

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

Symptoms

Following error is noticed with future_cost table update if user changes the active_date of a future deal which is already approved :

Steps To Reproduce :

  1. Find an existing approved deal with active_date in future.
  2. Open the deal in edit mode on the Deal Maintenance [dealmain] screen and change the active date on the deal by bringing it to worksheet.
  3. Submit and approve the deal.
  4. Run fcthreadexec, pre fcexec, and fcexec batches.
  5. Fcexec batch fails with the above error in COST_EVENT_RESULT table.

Changes

 

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