My Oracle Support Banner

Cost_event Is Failing For Deal Close Date Modifcation And Not Updating In Future_cost Table (Doc ID 2880248.1)

Last updated on JUNE 29, 2022

Applies to:

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

Symptoms

When an approved deal Close date is modified, it is inserting REM and MOD records in COST_EVENT and COST_EVENT_RESULT. But REM record is processed successfully and MOD record errored with error "@0NO_FC_RECORDS"

Actual result: MOD record is errored in COST_EVENT_RESULT with error "@0NO_FC_RECORDS"
Expected Result: MOD record also need to be processed and Active date of New Close_date+1 need to be present in future_cost table

Steps to recreate:

  1. Modify Close date of an approved Deal
  2. Click on Save and Close
  3. Validate records in COST_EVENT, COST_EVENT_RESULT and COST_EVENT_THREAD
  4. Validate date in FUTURE_COST

 

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.