Upload OPM Standard Costing
Upload Selected
There is a Process Option for Uploads included in the OPM Standard Costing mode of the Item Cost Wizard as shown below:
In order to conduct an upload, either ‘Create’ or ‘Update’ is required to carry out the load. When performing an upload selected, the user first selects/highlights the rows they wish to upload. This can range from just one record to the entire set of data depicted below:
Once selecting the data, click the ‘Upload’ icon and select ‘Upload Selected’ from the Item Cost Wizard to perform the upload.
This will upload the first two records on the spreadsheet and their associated child records. Alternatively the user is able to select the child records for upload, the Wizard will figure out which header records are associated with the child records selected and perform the upload based on those selected. An example of this is shown below:
Once the data has been selected, the user simply clicks the ‘Upload’ icon and selects ‘Upload Selected’ from the Wizard ribbon. For further instructions see the section below on Upload Messaging.
Upload All
An alternate method of uploading in this mode is to Upload All records. Once a process option has been chosen (Update or Create) the user is able to click the ‘Upload’ icon and select ‘Upload All’.
Upload Messaging
Once an Upload has been initiated the Wizard will then show a processing form for the upload being performed. One of two outcomes is likely from this stage:
1. Error Messages
Once the Upload has begun, the Processing form will handle the outcome of the upload. In this scenario the two OPM costs have failed. The processing form prints this outcome in the Processing Messages section along with the times that these errors occurred.
Once the processing form is closed, error messages associated with the upload are printed into the ‘Upload Error’ column and the Upload Result in this case is Error.
Some error messages that are possible from upload are:
|
Error
|
Meaning
|
|
Error: No Component Cost Details found to update for Component Class Id 4 and Analysis Code BYP.
|
The Component Class Code and Analysis Code do not match with a record in Oracle.
|
|
Costing is not enabled for the item 9060
|
The item being uploaded needs to be Process Costing Enabled in Oracle in order to upload.
|
|
Process Costing is not enabled for the Organization
|
The organization specified does not have the capability to carry out OPM functions.
|
|
Value is not in the List of Values for…..
|
Means the value highlighted does purely not exist in the database or against the dependant values set.
|
2. Upload Successful
Once the Upload has begun the Processing form will handle the outcome of the upload. In this scenario the 23 OPM costs have loaded successfully. The processing form prints this outcome in the Processing Messages section along with the times that the load occurred.
Once the processing form is closed, an Accepted status will be printed in the associated rows that have been uploaded. Furthermore the interface ID is printed in the ‘Item Cost Interface ID’ column.
Refer to section: