Home › Discussions › Questions & Answers › Audit Trail for Standard Cost Changes and Item Attributes

Audit Trail for Standard Cost Changes and Item Attributes

Avatar photoCustomer July 14, 2019 at 5:43 pm

We recently performed a large standard cost update. We need a report that shows items with recent cost changes, comparing the new standard cost against the prior and current frozen costs, along with related item controls.

Viewing 4 reply threads
  • Author
    Replies
    • Support July 15, 2019 at 2:51 pm  

      Run the CAC New Standard Item Costs report. This report shows items with recent cost changes, based on a required ‘Cost Update Date From’ and ‘Cost Update Date To’ date range.

    • Avatar photoCustomer July 17, 2019 at 12:34 am  

      We are specifically concerned with ensuring that items that require a Bill of Materials (BOM) or Routing actually have them defined before the cost was frozen. Does the report show this?

    • Support July 17, 2019 at 5:10 pm  

      Yes, the report includes columns indicating whether BOMs, Routings, or (inventory organization) Sourcing Rules exist for the item. This helps validate the necessary controls are in place for accurate cost calculation.

    • Avatar photoCustomer July 18, 2019 at 10:47 pm  

      If an item cost was directly entered into the Frozen Cost Type without running a formal cost update, will those related submission columns be empty?

    • Support July 19, 2019 at 6:03 pm  

      That is correct. If an item cost was directly entered into the Frozen Cost Type (allowed only if there are no onhand or intransit quantities), the ‘Cost Update Request Id’, ‘Cost Update Description’, ‘Cost Update Status’, and related cost update submission columns will be blank or empty.

  • Author
    Replies
Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with:
Popular Posts
How to track master data changes using Oracle EBS Audit function and Blitz Report™ 123746

Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 19796

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14614

How to check if a patch is applied in Oracle EBS 12.2 14387

Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS R12.1.3 14072

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 11965

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 9898

Migration to Java Web Start in Oracle EBS 12.2 instance 9890

Securing sensitive data with Oracle VPD 7793

EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536 6448

Blog Archive
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
Recent Events
2026
2025
2024
2023
2022
2021
2020
2019
2018