Importing Onhand quantity in fusion Using FBDL template.

Step:- 1

Download template From Fusion Apps OER for Cloud Release 12

http://docs.oracle.com/cloud/farel12/scmcs_gs/OEFSC/Inventory_Transaction_303532727_fbdi_19.htm#303532727

Note : download template for appropriate release of instance

Fill the template with appropriate Data. And click on generate CSV in first tab.

Step:- 2

Login to application

Navigate to Tools---> File Import and Export.

Click on Actions--> Upload.

Click on Actions -->Upload.

Browse the file generated in step-1  and  account mentioned in Fusion Apps OER.

Step:- 3

Navigate to Tools à Schedule processes.

Click on Schedule new Process and Search for schedule process “Load Interface File for Import”.

select Import Process mentioned in Step:- 1, Select file imported in Step:- 2.

If the process completes with Success Status then  follow step -3 else correct the data in the template in repeat the steps.

Step:- 4

Navigate to Tools à Schedule processes.

Click on Schedule new Process Schedule and Search for schedule process “Manage Inventory Transactions”.

This Program will trigger another process “Create Inventory Transactions”.

Check for log of Create Inventory Transactions.

If the record is not processed.

Check for the error in reports and analytics

select * from INV_TRANSACTIONS_INTERFACE where LOAD_REQUEST_ID=:request_id_Load_Interface.