> For the complete documentation index, see [llms.txt](https://doc.duaer.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://doc.duaer.com/guides/oracle-ebs-purchase-to-pay-order-to-cash.md).

# Oracle EBS purchase to pay and order to cash: see where each order waits

Connect Oracle E-Business Suite (R12) to Duaer. A read-only database user reads the steps of each purchase or sales order.
## What does Duaer read from Oracle EBS?

Each purchase order (PO_HEADERS_ALL) or sales order (OE_ORDER_HEADERS_ALL) is a case, with the supplier or customer, the operating unit, currency and amount. The steps are:

- Purchase to pay: Requisition created, Order created, Goods received (RCV_TRANSACTIONS), Invoice posted (AP_INVOICES_ALL), Paid (AP_CHECKS_ALL).
- Order to cash: Order created, Delivery created (WSH_NEW_DELIVERIES), Goods issued, Invoice created (RA_CUSTOMER_TRX_ALL), Paid (AR_CASH_RECEIPTS_ALL).
- Canceled documents are left out. The steps match the purchase to pay or order to cash template.

## How do you connect Oracle EBS to Duaer?

1. In the EBS database, create a read-only user with SELECT on these APPS tables (PO, RCV, AP, OE, WSH, RA, AR, HZ and HR_OPERATING_UNITS).
2. If the database is only inside your network, start the Duaer on-premises data gateway (0.2.0 or later) there with tcp://database-host:port in ALLOWED_TARGETS; the credential's host and port must match it.
3. In Duaer, create an Oracle Database Credentials API credential for this user.
4. As an owner or admin, open Data sources in the sidebar, select Add source, choose Oracle EBS under Purchase to pay or Order to cash, choose the credential and select Check connection. Any table it cannot read is listed.
5. The mapping is fixed. Preview, set the schedule and who sees the cases, and confirm.

## How often does it read, and how much?

Each run reads a few streams by last update (LAST_UPDATE_DATE): orders, receipts or shipments, invoices, and payments or cash receipts, one page each at most. Each stream reads a time window to its end, then goes on from there; a first read covers all past data and finishes over several runs. A step is never written twice. Queries only: Duaer never writes to EBS.

## What are the limits?

- The tables, views, models and fields read follow the vendor's published documentation and are not yet checked against a real system; the first real read may need adjustments.
- Each source reads one process; add purchase to pay and order to cash separately.
## Questions

### Is this for Oracle Fusion too?

No. Oracle Fusion Cloud has its own source, which reads the REST API.

## Related

- [Add a process source in Duaer](https://doc.duaer.com/build/process-sources.md)
- [See the process in your data and generate workflows in Duaer](https://doc.duaer.com/build/process.md)
- [Process findings and SOP conformance in Duaer](https://doc.duaer.com/build/process-findings.md)
- [Oracle Fusion purchase to pay and order to cash: see where each order waits](https://doc.duaer.com/guides/oracle-fusion-purchase-to-pay-order-to-cash.md)
- [SAP ECC purchase to pay and order to cash: see where each order waits](https://doc.duaer.com/guides/sap-ecc-purchase-to-pay-order-to-cash.md)