With valid costing information on the spreadsheet we are able to perform a cost roll up. In order to use this functionality the Wizard will need to be in ‘Discrete Standard Costing’ mode and we will need the following columns with the following values:
Field
Value
Rollup Option
‘Single level rollup’ or ‘Full cost rollup’
Cost Rollup
‘Yes’
Assignment Set (Not Required)
By flagging the ‘Cost Rollup’ column as ‘Yes’ this will tell the Wizard that we are performing a cost roll up. Once this is flagged as Yes the Rollup Option field will become mandatory.
From here, run an upload as per normal and given the above field ‘Cost Rollup’ is set to ‘Yes’ the upload will perform the cost rollup rather than a Cost Create/Update.
Note: If the rolled-up costs get removed when doing a 'Create and Update'; This is because of the limitation of the Oracle Interface. The workaround for this is to run the Cost Rollup again. The Cost Rollup can be run via Oracle EBS or ran through Item Cost Wizard.
