Incorrect CST_COST_GROUPS Records That Has Duplicate Cost Group Are Created (Doc ID 2277415.1)

Last updated on JUNE 21, 2017

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Actual Behavior
In a special procedure, incorrect cst_cost_groups records that has duplicate Cost Group Name are created.

In normal procedure, the creation using duplicate Cost Group Name is prevented by "The cost group XXXXX already exists" error.

Expected Behavior
Incorrect cst_cost_groups records that has duplicate Cost Group Name should be always prevented in order to prevent choosing the incorrect cost group id from the cost manager.

Steps to Reproduce

  1. Enter Cost Group : AABB in Cost Group form.
  2. Click Accounts field.
  3. Click (B)WIP Accounting Classes.
  4. Enter WIP Accounting Class.
  5. Click "X" icon on WIP Accounting Classes For Cost Group window.
  6. Press "Under" key of keyboard.
  7. Pop-up message "Do you want to save the changes you have made?", then press "No".
  8. Enter Cost Group to same value : AABB (as same value).
  9. Click Save icon in tool bar.
  10. Following error occurs.

    FRM-40400: Transaction complete: 2 records applied and saved.

  11. Created duplicate records with same COST_GROUP in cst_cost_groups

 

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, cost manager gets COST_GROUP_ID that has incorrect account setting for Material transaction then it fails with CST_INVALID_CG occurs. As the result, average costing will stop.

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