RCG Oracle EBS Customers System API - Implementation Template
Prerequisites
This implementation template has the following dependencies:
- Oracle EBS Instance with access to PL/SQL APIs
- Read Access to Oracle EBS Database - HZ_CUST_ACCOUNTS and HZ_PARTIES tables
- Deploying the PL/SQL services. More details can be found in the documentation here.
Please review the use cases described on the MuleSoft Accelerator for Retail solution pages for more information about dependencies on other APIs and services.
Oracle EBS PL/SQL APIs
The following table lists the Oracle EBS PL/SQL APIs used by this implementation:
| API Endpoint | Oracle EBS PL/SQL APIs - Operation |
|---|---|
| get:/customers/{customerId} | Query on HZ_CUST_ACCOUNTS table in Oracle EBS DB, accel_person_business_object - GET_PERSON_BO, accel_organization_business_object - GET_ORGANIZATION_BO |
| get:/customers | Query on HZ_CUST_ACCOUNTS & HZ_PARTIES tables in Oracle EBS DB, accel_person_business_object - GET_PERSON_BO, accel_organization_business_object - GET_ORGANIZATION_BO |
| post:/customers | accel_person_business_object - CREATE_PERSON_BO, accel_organization_business_object - CREATE_ORGANIZATION_BO, accel_customer_account_business_object - CREATE_CUST_ACCT_V2_BO |
| patch:/customers/{customerId} | accel_customer_account_business_object - GET_CUST_ACCT_V2_BO, accel_person_business_object - GET_PERSON_BO, accel_person_business_object - UPDATE_PERSON_BO, accel_organization_business_object - GET_ORGANIZATION_BO, accel_organization_business_object - UPDATE_ORGANIZATION_BO, accel_customer_account_business_object - UPDATE_CUST_ACCT_V2_BO |
Oracle EBS PL/SQL APIs Alias Names
The following table lists the Service Alias Name for Oracle EBS PL/SQL APIs that are used in the implementation:
| PLSQL API Internal Name | Service Alias Name |
|---|---|
| HZ_PERSON_BO_PUB | accel_person_business_object |
| HZ_ORGANIZATION_BO_PUB | accel_organization_business_object |
| HZ_CUST_ACCT_BO_PUB | accel_customer_account_business_object |
Next steps
Refer to the Deployment page for instructions on how to configure and deploy this application.