Thursday, 1 March 2018

Importing Standard Cost In Oracle Fusion Using FBDL

  • Importing Standard Cost In Oracle Fusion Using FBDL
  • navigate to docs.oracle.com and download the FBDI template to load standard costs
  • Link : http://docs.oracle.com/cloud/latest/scmcs_gs/OEFSC/Standard_Costs_Import_300758851_fbdi_42.htm
  • Add details of the standard cost on the spreadsheet and save.
  • Click on Generate CSV button, follow the instructions in the first worksheet.
  • Load the zip file using tools-> File Import export from Navigator menu
  • Run, Load Interface File program against UCM account: scm/standardCost/import
  • Navigate to Costing Accounting Workarea -> Manage Cost Scenario Exceptions page
  • Verify the data is loaded and is in "new" status.
  • Click button "Import Standard Cost", this will move the data from Interface tables to base costing tables.
  • Once the program completes successfully, the records will disappear from Manage Cost Scenario Exceptions page, which means that the records were imported successfully.
  • Go to Manage Cost scenarios and search for your scenarios and from action menu choose Update standard Cost. Update Cost Job gets submitted, Once it completes successfully, Cost scenario status will change form 'In progress' to 'Published' and Standard Cost will be effective from the scenario effective date. The effective start date should not overlap between two scenarios defined for same Item/cost org valuation unit combination.

1 comment:

  1. Simply wish to say your article is as astonishing. The clarity in your post is simply great, and I could assume you are an expert on this subject. Same as your blog i found another one Oracle Fusion SCM .Actually I was looking for the same information on internet for Oracle Fusion SCM and came across your blog. I am impressed by the information that you have on this blog. Thanks a million and please keep up the gratifying work.

    ReplyDelete