Integration 3rd party Sales invoices in Oracle ERP

Scope:  Integrate inhouse system with Oracle ERP. All sales invoices created in inhouseshould be linked in Oracle ERP.

Process:               Invoices created in inhousewill be created in Oracle ERP thru Sales order creation to cash flow in Order Management via API. Service_invoice_id will be the link between ERP and inhouse. This field will be entered in custome_PO field in sales order.

Below will be the steps:

1. Required validated data will be pumped by inhouse system in the table BU_ZFSP_SALESORDER_TO_ERP.
2. Business user will do post to oracle, at this time he will select Order Type, customer, Bill To, Ship To and sales person.
3. Oracle API will create the sales order in ERP.
4. Each service_invoice_id will create one sales order.
5. service_invoice_id is unique .
6. User will reserve book the order.
7. Invoice will be created in ERP.
8. ATTRIBUTE4 in sales order header will have Customer/Contractor  Name
9. ATTRIBUTE3 in sales order header will have service invoice id.

Exceptions: Below are the exceptions where this procedure may fail:

1. Customer not correct as per ERP
2. Order Type not correct
3. Price List not correct
4. Sales person not define
5. Service invoice id should be unique
6. Service invoice number should be unique
7. Item should be active and assigned to selected organization
8. Onhand should be available in selected subinventory and locator
9. Item should be define in selected price list
10. Sales order should not go on HOLD (payment term should be Immediate.)
11. Inventory period should be open.
12. Receivable period should be open for invoice creation
13. Workflowbackground process should be running
14. Autoinvoice request should be running

Steps in Oracle:

1. Staging Table
2. Procedure

1. Create Sales Order
2. Reserve Sales Order
3. Book Sales Order
4. Create_Reserve_Book Sales Order

3. Schedule Procedure