Pages

Aug 31, 2011

Export Compliance Flow in Oracle Order Management.

This is a short post about Export Compliance Functionality available in Oracle Order Management via Oracle Order Line workflow.





As shown in the above workflow, export compliance process executed as soon as we book our sales Order.
Export Compliance Workflow Sub process Name - Export Compliance Screening - Line


First Activity in the export Compliance sub process is  “Export Compliance Screening” , it get the data from the Order Management and Validate it .If Validation fails then it make the workflow outcome as INCOMPLETE and progress to activity “Export Compilance Screening –Eligible “ and hence required manual Intervention at the same time it also mark the status of order line to Export Screening Data Error.

On the Other Hand If validation outcome is successful then it mark the workflow outcome as NOTIFIED and workflow remain at the “Export Compliance Screening” but Order line status become “Awaiting Export Screening” , at the same time this activity populate the table WSH_ITM_REQUEST_CONTROL (Pls note data in this table will be process by ITM adapter).

Once the ITM adapter process the data it mark the process flag is this table to 1 and execute the Order Management API (ONT_ITM_PKG.WSH_ITM_ONT) and based on the response from ITM (Override/Error/Success) Order management API progress to workflow to Next activity “Update Screening Result”. But if no response received from the ITM adapter then workflow remain at “Export Compliance Screening” or “Export Compilance Screening –Eligible" activity.

In this “Update screening Result(OE_EXPORT_COMPLIANCE_WF.UPDATE_SCREENING_RESULTS)” activity,  system validates the response received from ITM adapter, if validation fails, workflow outcome mark as “Incomplete” and workflow progress to activity “Update Screening Results – Eligible” and Order line status marked as “Export Screening Data Error “, on the other hand if validation outcome is success, workflow progress to End activity and finally to next sub process and Order line status marked as “Export Screening Completed”

Hope that helps