API

Give example of 2 APIs in Oracle and explain their purpose

OE_ORDER_PUB

USE	SCRIPT
To Create an Order with one Line	oeorderpubprocessorder-sample-script.html
To Update Order Header Details	update-order-header-details-using-api.html
To Add New Line to an Existing Sales Order	add-new-line-to-existing-order-using.html
To Delete a Sales Order line	delete-order-line-using-api.html
To Cancel a Sales Order line	cancel-order-line-using-api.html
To Book a Sales order	book-sales-order-using.html
To Delete a Sales Order	api-to-delete-sales-order.html
To Cancel a Sales Order	api-to-cancel-sales-order.html
To Apply hold on a sales order	oeorderpubprocessorder-to-apply-hold-on.html
To Release hold on a sales order	oe-order-pub-process-order-to-release.html

HR_EMPLOYEE_API

Create Employee

HR_PERSON_API

Update Person

HR_CONTACT_REL_API

Create contact

Interface Errors:

OM Interface tables:

OE_HEADERS_IFACE_ALL, OE_LINES_IFACE_ALL

Error tables:

OE_PROCESSING_MSGS, OE_PROCESSING_MSGS_TL

SELECT OPT.*

FROM OE_PROCESSING_MSGS OPM
       ,OE_PROCESSING_MSGS_TL OPT

WHERE OPM.TRANSACTION_ID = OPT.TRANSACTION_ID
AND ORIGINAL_SYS_DOCUMENT_REF = dof_ref;

From Oracle front end:

Order Management Super User > Import Orders > Corrections

AR:

Interface tables:

RA_ INTERFACE_LINES_ALL

Error tables:

RA_INTERFACE_ERRORS_ALL

From Oracle front end:

Receivables > Control > Autoinvoice > Interface Exceptions