Redwood: Review Cost Accounting Distributions

The Costing Transactions and Distributions page provides detailed insights into cost information and distributions for each transaction. This also includes visibility into receipt layers for receipt transactions and depletion layers for issue transactions. You can now perform all the focused search operations which includes search by reference number, item number, costing status, transaction type and accounting status using the new Redwood page.
You can only review the data for the cost organizations you've access to.

Search by Options and Data Categorization

The page offers versatile search options to locate transactions efficiently. You can search by the following options to review the details of the transactions and distributions:

  • Reference Number: Search based on specific reference numbers, such as purchase orders, transfer orders, sales orders, work orders, or transaction references.
  • Item Number: Find transactions within a specific period for a particular item.
  • Costing Status: Identify transactions based on their costing status. You can use this for spotting transactions that haven't been costed or are in error status.
  • Transaction Type: Filter transactions within a specified date range and by transaction type.
  • Accounting Status: You can use this to locate transactions that aren't accounted for or are in error status to resolve reconciliation issues. Supported statuses include Error, Not Accounted, Draft Accounted, Final Accounted, Multiple, Not Applicable, and Excluded from Accounting.

Each search by option has corresponding mandatory filters. After you set the mandatory filters, the results are categorized under different tabs:

  • Cost Transactions: Includes inventory and intercompany physical and logical transactions.
  • Cost Adjustments: Includes manual or automatic cost adjustments to receipt costs and inventory value.
  • COGS Transactions: Includes cost of goods sold recognition transactions.
  • Work Order Transactions: Includes resource, operation scrap, and work-in-process job close transactions.

From this page, you can run the Cost Distribution Details Report, which offers a list of cost distributions and accounting information alongside basic transaction information in a spreadsheet. This report can be generated for all search options except Accounting Status. You can also review the cost distributions, transaction details or errors for a specific transaction.

Costing Transactions and Distributions page

Costing Transactions and Distributions page

Transaction Details

Transaction details provide you more insights about the transaction parameters and all the essential information for the transaction are at one place. The information is categorized and presented in the Costing Information, Transaction Information, Inventory Control Attributes, and Fiscal Document Details sections.

Transaction Details Drawer

Transaction Details Drawer

Distributions Page

Cost Distributions page provides you details about the costing and accounting distributions created for a particular transaction. You can find the following information for the transaction on this page.

  • Distributions Summary: You can now view the summary of all the distributions for a particular transaction by accounting line type and accounted amount.  This can help you to quickly identify anomalies, if any. You can also view detailed distributions.
  • Layer Details: This section is collapsed by default. You can expand it to get visibility into receipt layers for receipt transactions and depletion layers for issue transactions. You can view the cost information for the particular layer. You can also directly view journal entries for a particular layer for the transaction.
  • Distribution Details: You can now view details of all the distributions created for the transaction. By default, you will see distributions for all the layers of the transaction, but you can use the filter for layer identifier to filer the distributions for a particular layer. You can also export all the distribution lines into a spreadsheet for offline analysis.


Cost Distributions Page

Cost Distributions Page

Some of the benefits of this feature include:

  • Improved Efficiency & Accuracy: Quickly track cost distributions, identify errors, and ensure accurate financial reporting.
  • Faster Period Close: Enhanced visibility into unaccounted transactions helps streamline reconciliation and period closing processes.
  • Actionable Insights for Decision-Making: Real-time costing status, drill down capabilities, and detailed reporting improve financial control.
  • Better User Experience: Intuitive search, filtering, and navigation reduce manual effort and increase productivity.
  • Seamless Navigation from Other Pages: Easily access the page from related cost management pages, ensuring a smooth workflow and reducing time spent switching between screens.
  • Summary Scorecards for Distributions: Offers a consolidated view of cost distributions enabling faster analysis and issue identification.

Steps to Enable

  1. In the Setup and Maintenance work area, search for and select the Manage Administrator Profile Values task.
  2. On the Manage Administrator Profile Values page, search for and select the ORA_CST_REVIEW_COST_ACCOUNTING_DISTRIBUTIONS_REDWOOD_ENABLED profile option code.
  3. In the Profile Values section, set the Site level to Yes. The default value is No.
  • Yes = enables the feature
  • No = disables the feature
  1. Click Save and Close. Changes in the profile value will take effect the next time you sign in.

After you've set the profile value correctly, the task pane under Cost Accounting would show the task menu link as Costing Transactions and Distributions. Using this link, you can access the Redwood page.

Tips And Considerations

  • The page has been renamed to Costing Transactions and Distributions in Redwood. In the existing UI, the page name still remains the same.
  • Classic search isn't available in the Redwood page. You can only perform a focused search using one of the search by options.
  • Navigate to this page directly with the filters carried forward form the parent page. Navigations are available from the following pages:
    • Work Order Costs
    • Maintenance Work Order Costs
    • Item Costs
    • Inventory Valuation
    • Gross margins
  • On the Cost Distributions page, by default, you will see distributions for all the layers of the transaction, but you can use the filter for layer identifier to filter the distributions for a particular layer.
  • You can provide guidance such as tutorials, company policies, and best practices in the context of the page using guided journey tasks.

Key Resources

  • Oracle Fusion Cloud SCM: Implementing Manufacturing and Supply Chain Materials Management Guide, available on the Oracle Help Center.
  • Oracle Fusion Cloud SCM: Using Cost Management Guide, available on the Oracle Help Center.

Access Requirements

Users who are assigned a configured job role that contains the following privilege can access this feature:

  • Review Cost Distribution (CST_REVIEW_COST_DISTRIBUTIONS)
  • Review Cost Distribution by Web Service (CST_REVIEW_COST_DISTRIBUTIONS_WEB_SERVICE)