1. Using Supply Chain Cost Management
  2. Import Standard Costs Using File-Based Data Import

Import Standard Costs Using File-Based Data Import

You can use the Standard Costs Import Open Interface to import standard costs from external sources into Cost Management. Once loaded, view the data in the Cost Accounting work area, on the Manage Standard Cost Import Exceptions page.

Click Import Standard Costs to validate the data using the Interface Standard Costs process. You can view any errors resulting from the validation process on the Manage Standard Cost Import Exceptions page. If there are any errors, take the necessary corrective actions and rerun the Interface Standard Costs process.

After validation is complete, the data is loaded to the Standard Costs Interface table, and to the Manage Standard Costs page in Cost Accounting.

For more information on file-based data import, see the chapter on Standard Costs Import in the File Based Data Import guide for Oracle Supply Chain Management Cloud.

Complete these tasks before importing data using file-based data import:

  • Set up the Default Cost Profile for Cost Accounting in the Setup and Maintenance work area, and set the New Item Profile Creation option to Automatic.

  • Set up a valuation unit using the Manage Valuation Units task in the Setup and Maintenance work area. Make a note of the Valuation Unit Code, which is required for the CSV file.

  • Set up overhead cost elements for Cost Accounting in the Setup and Maintenance work area using the Manage Cost Elements task.

To Import Standard Costs Using File-Based Data Import

To import standard costs using File-Based Data Import, complete these steps.

  1. In the Cost Accounting work area, click the Manage Cost Scenarios task.

  2. Click the Add icon and create a cost scenario.

    Make a note of the scenario number, which is required for the CSV file.

  3. Open the Standard Costs Import file-based data import template.

  4. Complete the Standard Cost Headers and Standard Cost Details tabs using the instructions in the spreadsheet.

  5. On the CSV Generation tab, click Generate CSV File.

  6. From the Scheduled Processes work area, run the Interface Standard Costs process.

    The process validates the data, creates the required cost profiles, and imports the costs into the Manage Standard Costs page.

  7. Review the imported data in the Cost Accounting work area, on the Manage Standard Cost Import Exceptions page.

    Correct any costs that have the status as Error, and then click Import Standard Costs.

  8. Publish the cost scenarios to make the costs available for costing transactions.

Related Topics