Sales Order Integration

 Sales Order Integration -Inbound

AppDriven Based on Business Event  :

Prelude: A Sales order of type Replinishment Prepaid when ever created in Fusion OM.SO to PO Integeration will be created scheduled for every 10 min. SO Line EFF details are updated after 

After Receving Goods,

Create Receiving Receipt Event - ERP Cloud integration

SO of different of order type as BILL and Reload

Assign From Lookup to Variables Audit Integration is invoked for storing - instance id , rundate, end date , status set to new, int Name,

Logger To verify Type of order,

define main scope

Payloads and Files will be set to Object Storage

XML-File reference  --> stage write -> XML to XSD online compailer, 

Namespace, Bucket , Filename are mandatory parameters

Invoke DB procedure to Load From Object Storage to DB in order to minimise performance issues

dbms_cloud.

get object --> Credential Name, Complete URL of  Object Storage -- get lob

to_clob()-> to convert lob to clob

Poulated into ATP-- generic Table

Actual Integration:

Cost Collector Integration is invoked 

Dependent Jobs has to be completed -- before creating SO.

Transfer Transaction from receving to costing

Transfer Trasaction from inv to costing

Create Cost accounting Distributions

While Loop -->  Ess Job Status -- BIP Report Called to Get Job set Status,

Ess Request History-- 

Switch Condition

Status --Success or Warning -> BIP Report for Fetch additional Details not present in Response of Businees Event.

Parameters- P_Source PO Type / TO Type

                    PO/TO LineID 

                    Shipment Line ID

SWITCH -- Source Order Number != null

branch1: Scope level Fault handler is added Notification as Errored

Sales Order Generated and Notification as Success

 branch2:  Call Audit Integration and update status as Success