# Oracle EBS Public PL/SQL API Reference (OM, Inventory, PO, AP, AR, TCA, FND)

> Source: https://netray.co/tools/oracle-ebs-public-plsql-api-reference
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

The public PL/SQL APIs EBS developers call most outside HR, with key parameters, the context each needs and how to read its errors.

## Category

developer

## Erp

Oracle E-Business Suite

## Audience

- Oracle EBS developer
- Integration developer
- Technical consultant

## Tool

**Kind:** worksheet

**Mode:** reference

**Columns:**

#### Package.Procedure

**Key:** api

**Type:** text

#### Module

**Key:** module

**Type:** text

#### What it does

**Key:** does

**Type:** text

#### Key IN parameters / record types

**Key:** params

**Type:** text

#### Context required

**Key:** context

**Type:** text

#### Error retrieval

**Key:** errors

**Type:** text

**Rows:**

**Api:** OE_ORDER_PUB.PROCESS_ORDER

**Module:** OM

**Does:** Create, update, cancel or delete orders and lines; can also book via action requests

**Params:** p_api_version_number => 1.0; p_header_rec (OE_ORDER_PUB.HEADER_REC_TYPE); p_line_tbl (LINE_TBL_TYPE); p_action_request_tbl (REQUEST_TBL_TYPE); operation set with OE_GLOBALS.G_OPR_CREATE / G_OPR_UPDATE

**Context:** FND_GLOBAL.APPS_INITIALIZE with an OM responsibility; MO_GLOBAL.INIT('ONT') and MO_GLOBAL.SET_POLICY_CONTEXT('S', org_id)

**Errors:** x_return_status, x_msg_count; loop OE_MSG_PUB.GET(p_msg_index => i, p_encoded => FND_API.G_FALSE)

**Api:** OE_ORDER_PUB.GET_ORDER

**Module:** OM

**Does:** Read a full order into the API record structures

**Params:** p_header_id (or the order number/value parameters); returns x_header_rec, x_line_tbl and other tables

**Context:** APPS_INITIALIZE and MO context for the order's org

**Errors:** x_return_status; OE_MSG_PUB.GET

**Api:** OE_HOLDS_PUB.APPLY_HOLDS / RELEASE_HOLDS

**Module:** OM

**Does:** Apply or release holds on orders, lines or hold sources

**Params:** p_api_version => 1.0; p_hold_source_rec (OE_HOLDS_PVT.HOLD_SOURCE_REC_TYPE: HOLD_ID, HOLD_ENTITY_CODE, HOLD_ENTITY_ID, HEADER_ID, LINE_ID); release also takes p_hold_release_rec (RELEASE_REASON_CODE)

**Context:** APPS_INITIALIZE; MO context

**Errors:** x_return_status, x_msg_count; OE_MSG_PUB.GET

**Api:** WSH_DELIVERIES_PUB.DELIVERY_ACTION

**Module:** Shipping

**Does:** Run delivery actions such as ship confirm, pick release or close

**Params:** p_action_code (for example 'CONFIRM', 'PICK-RELEASE'); p_delivery_id or p_delivery_name; ship confirm options p_sc_action_flag, p_sc_intransit_flag, p_sc_close_trip_flag, p_sc_defer_interface_flag

**Context:** APPS_INITIALIZE with a shipping responsibility

**Errors:** x_return_status, x_msg_count; FND_MSG_PUB.GET

**Api:** WSH_DELIVERY_DETAILS_PUB.DETAIL_TO_DELIVERY

**Module:** Shipping

**Does:** Assign or unassign delivery details to a delivery

**Params:** p_TabOfDelDets (table of DELIVERY_DETAIL_ID); p_action 'ASSIGN' or 'UNASSIGN'; p_delivery_id or p_delivery_name

**Context:** APPS_INITIALIZE

**Errors:** x_return_status; FND_MSG_PUB.GET

**Api:** INV_ITEM_GRP.CREATE_ITEM / UPDATE_ITEM

**Module:** Inventory

**Does:** Create or update an item in an organization

**Params:** p_Item_rec (INV_ITEM_GRP.ITEM_REC_TYPE: ORGANIZATION_ID, SEGMENT1, DESCRIPTION, TEMPLATE_ID and attributes); p_commit; p_validation_level

**Context:** APPS_INITIALIZE with an inventory responsibility

**Errors:** x_return_status and x_Error_tbl (INV_ITEM_GRP.ERROR_TBL_TYPE) with MESSAGE_TEXT per error

**Api:** EGO_ITEM_PUB.PROCESS_ITEM

**Module:** Inventory / PIM

**Does:** Create or update an item; the API Oracle positions for item maintenance in R12

**Params:** p_api_version => 1.0; p_transaction_type 'CREATE' or 'UPDATE'; item columns as named parameters (p_segment1, p_organization_id, p_description, p_template_id and others)

**Context:** APPS_INITIALIZE

**Errors:** x_return_status, x_msg_count; ERROR_HANDLER.GET_MESSAGE_LIST for the messages

**Api:** INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES

**Module:** Inventory

**Does:** Return on-hand, reservable, reserved and available-to-transact quantities

**Params:** p_organization_id, p_inventory_item_id, p_tree_mode, p_is_revision_control, p_is_lot_control, p_is_serial_control, p_revision, p_lot_number, p_subinventory_code, p_locator_id; OUT x_qoh, x_rqoh, x_qr, x_qs, x_att, x_atr

**Context:** None beyond a database session for most uses; clear cache with INV_QUANTITY_TREE_PUB.CLEAR_QUANTITY_CACHE between calls

**Errors:** x_return_status, x_msg_count, x_msg_data

**Api:** INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS

**Module:** Inventory

**Does:** Process rows already inserted into MTL_TRANSACTIONS_INTERFACE online

**Params:** Function returning NUMBER; p_api_version 1.0; p_table 1 (interface table); p_header_id = TRANSACTION_HEADER_ID of your rows; OUT x_trans_count

**Context:** APPS_INITIALIZE

**Errors:** Return value non-zero or x_return_status; ERROR_CODE and ERROR_EXPLANATION on the interface rows

**Api:** INV_RESERVATION_PUB.CREATE_RESERVATION

**Module:** Inventory

**Does:** Create a reservation against a demand such as a sales order line

**Params:** p_rsv_rec (INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE); p_serial_number; p_partial_reservation_flag; p_force_reservation_flag; OUT x_quantity_reserved, x_reservation_id

**Context:** APPS_INITIALIZE

**Errors:** x_return_status, x_msg_count; FND_MSG_PUB.GET

**Api:** INV_LOT_API_PUB.CREATE_INV_LOT

**Module:** Inventory

**Does:** Create a lot number for a lot-controlled item

**Params:** Overloaded; key values are organization, inventory item and lot number plus lot attributes

**Context:** APPS_INITIALIZE

**Errors:** x_return_status, x_msg_count; FND_MSG_PUB.GET

**Api:** BOM_BO_PUB.PROCESS_BOM

**Module:** BOM

**Does:** Create, update or delete bills, revisions and components

**Params:** p_bom_header_rec (BOM_BO_PUB.BOM_HEAD_REC_TYPE); p_bom_component_tbl (BOM_COMPS_TBL_TYPE); TRANSACTION_TYPE 'CREATE', 'UPDATE', 'DELETE' in each record

**Context:** APPS_INITIALIZE; ERROR_HANDLER.INITIALIZE before the call

**Errors:** x_return_status, x_msg_count; ERROR_HANDLER.GET_MESSAGE

**Api:** PO_DOCUMENT_CONTROL_PUB.CONTROL_DOCUMENT

**Module:** Purchasing

**Does:** Cancel, close or finally close a PO, release, line or shipment

**Params:** p_doc_type ('PO', 'PA', 'RELEASE'); p_doc_subtype ('STANDARD', 'BLANKET' and others); p_doc_id or p_doc_num; line and shipment IDs or numbers; p_action ('CANCEL', 'CLOSE', 'FINALLY CLOSE' and others); p_action_date; p_cancel_reason

**Context:** APPS_INITIALIZE; MO_GLOBAL.SET_POLICY_CONTEXT('S', org_id)

**Errors:** x_return_status; FND_MSG_PUB.GET

**Api:** PO_CHANGE_API1_S.UPDATE_PO

**Module:** Purchasing

**Does:** Change quantity, price, promised date or need-by date on an approved PO and optionally re-approve

**Params:** Function returning NUMBER (1 success); X_PO_NUMBER, X_RELEASE_NUMBER, X_REVISION_NUMBER, X_LINE_NUMBER, X_SHIPMENT_NUMBER, NEW_QUANTITY, NEW_PRICE, NEW_PROMISED_DATE, NEW_NEED_BY_DATE, LAUNCH_APPROVALS_FLAG, UPDATE_SOURCE, VERSION, X_OVERRIDE_DATE, X_API_ERRORS

**Context:** APPS_INITIALIZE; MO context for the PO's org

**Errors:** X_API_ERRORS (PO_API_ERRORS_REC_TYPE) message_text table

**Api:** AP_VENDOR_PUB_PKG.CREATE_VENDOR / CREATE_VENDOR_SITE / CREATE_VENDOR_CONTACT

**Module:** Payables

**Does:** Create suppliers, supplier sites and contacts

**Params:** p_api_version => 1.0; p_vendor_rec (AP_VENDOR_PUB_PKG.R_VENDOR_REC_TYPE), p_vendor_site_rec (R_VENDOR_SITE_REC_TYPE), p_vendor_contact_rec (R_VENDOR_CONTACT_REC_TYPE); OUT x_vendor_id, x_party_id, x_vendor_site_id

**Context:** APPS_INITIALIZE; MO context for sites

**Errors:** x_return_status, x_msg_count; FND_MSG_PUB.GET

**Api:** AP_CANCEL_PKG.AP_CANCEL_SINGLE_INVOICE

**Module:** Payables

**Does:** Cancel one invoice as the Invoice Workbench cancel action does

**Params:** Function returning BOOLEAN; P_invoice_id, P_last_updated_by, P_last_update_login, P_accounting_date, plus several OUT parameters including P_message_name and P_Token, and P_calling_sequence

**Context:** APPS_INITIALIZE; MO context

**Errors:** Returns FALSE; read P_message_name and P_Token. Signature differs across 12.x patch levels, so check the package spec

**Api:** AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE

**Module:** Receivables

**Does:** Create one invoice, debit memo or credit memo transaction without AutoInvoice

**Params:** p_batch_source_rec; p_trx_header_tbl; p_trx_lines_tbl; p_trx_dist_tbl; p_trx_salescredits_tbl; OUT x_customer_trx_id

**Context:** APPS_INITIALIZE; MO_GLOBAL.INIT('AR') and SET_POLICY_CONTEXT

**Errors:** x_return_status, x_msg_count; validation errors also in AR_TRX_ERRORS_GT

**Api:** AR_CREDIT_MEMO_API_PUB.CREATE_REQUEST

**Module:** Receivables

**Does:** Create a credit memo request against an invoice; with workflow skipped it creates the credit memo directly

**Params:** p_customer_trx_id; p_line_credit_flag; p_line_amount, p_tax_amount, p_freight_amount; p_cm_reason_code; p_skip_workflow_flag; p_batch_source_name; OUT x_request_id

**Context:** APPS_INITIALIZE; MO context

**Errors:** x_return_status, x_msg_count; FND_MSG_PUB.GET

**Api:** AR_RECEIPT_API_PUB.CREATE_CASH / APPLY

**Module:** Receivables

**Does:** Create a cash receipt; apply a receipt to a transaction (CREATE_AND_APPLY does both)

**Params:** CREATE_CASH: p_amount, p_receipt_number, p_receipt_date, p_customer_id, p_receipt_method_id, p_currency_code; OUT p_cr_id. APPLY: p_cash_receipt_id, p_customer_trx_id, p_amount_applied

**Context:** APPS_INITIALIZE; MO context

**Errors:** x_return_status, x_msg_count; FND_MSG_PUB.GET

**Api:** HZ_PARTY_V2PUB.CREATE_ORGANIZATION

**Module:** TCA

**Does:** Create an organization party

**Params:** p_organization_rec (HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE: ORGANIZATION_NAME, CREATED_BY_MODULE); OUT x_party_id, x_party_number, x_profile_id

**Context:** APPS_INITIALIZE; CREATED_BY_MODULE must be a valid lookup value

**Errors:** x_return_status, x_msg_count; FND_MSG_PUB.GET

**Api:** HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT

**Module:** TCA

**Does:** Create a customer account, optionally creating the party and profile

**Params:** p_cust_account_rec; p_organization_rec (or p_person_rec); p_customer_profile_rec; p_create_profile_amt; OUT x_cust_account_id, x_account_number, x_party_id

**Context:** APPS_INITIALIZE

**Errors:** x_return_status, x_msg_count; FND_MSG_PUB.GET

**Api:** HZ_LOCATION_V2PUB.CREATE_LOCATION

**Module:** TCA

**Does:** Create an address location

**Params:** p_location_rec (ADDRESS1, CITY, POSTAL_CODE, COUNTRY, CREATED_BY_MODULE); OUT x_location_id

**Context:** APPS_INITIALIZE

**Errors:** x_return_status; FND_MSG_PUB.GET

**Api:** HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE

**Module:** TCA

**Does:** Link a location to a party as a party site

**Params:** p_party_site_rec (PARTY_ID, LOCATION_ID, CREATED_BY_MODULE); OUT x_party_site_id, x_party_site_number

**Context:** APPS_INITIALIZE

**Errors:** x_return_status; FND_MSG_PUB.GET

**Api:** HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE / CREATE_CUST_SITE_USE

**Module:** TCA

**Does:** Create the account site in an operating unit and its BILL_TO or SHIP_TO use

**Params:** p_cust_acct_site_rec (CUST_ACCOUNT_ID, PARTY_SITE_ID, ORG_ID); OUT x_cust_acct_site_id. p_cust_site_use_rec (SITE_USE_CODE, CUST_ACCT_SITE_ID); OUT x_site_use_id

**Context:** APPS_INITIALIZE; MO_GLOBAL.SET_POLICY_CONTEXT('S', org_id) because account sites are org-striped

**Errors:** x_return_status; FND_MSG_PUB.GET

**Api:** GL_DAILY_RATES_INTERFACE (insert)

**Module:** GL

**Does:** Load daily exchange rates; there is no separate public procedure, the interface trigger processes the insert

**Params:** FROM_CURRENCY, TO_CURRENCY, FROM_CONVERSION_DATE, TO_CONVERSION_DATE, USER_CONVERSION_TYPE, CONVERSION_RATE, MODE_FLAG 'I'

**Context:** Plain insert as APPS

**Errors:** Rows left in the table with ERROR_CODE

**Api:** FND_FLEX_EXT.GET_CCID

**Module:** FND / GL

**Does:** Return the CODE_COMBINATION_ID for a segment string, creating it if dynamic insert is allowed

**Params:** Function returning NUMBER; application_short_name 'SQLGL', key_flex_code 'GL#', structure_number (CHART_OF_ACCOUNTS_ID), validation_date (character in FND_FLEX_EXT.DATE_FORMAT), concatenated_segments

**Context:** APPS_INITIALIZE for cross-validation and security rules

**Errors:** Returns 0 on failure; FND_FLEX_EXT.GET_MESSAGE

**Api:** FND_GLOBAL.APPS_INITIALIZE

**Module:** FND

**Does:** Set user, responsibility and application context in a database session

**Params:** user_id, resp_id, resp_appl_id (optional security_group_id)

**Context:** Call first in any script that uses APIs or WHO columns

**Errors:** No return; verify with FND_GLOBAL.USER_ID afterwards

**Api:** MO_GLOBAL.INIT / SET_POLICY_CONTEXT

**Module:** FND

**Does:** Initialise Multi-Org Access Control and set the operating unit for secured synonyms

**Params:** INIT(p_appl_short_name, for example 'ONT', 'PO', 'AR'); SET_POLICY_CONTEXT(p_access_mode 'S' single or 'M' multiple, p_org_id)

**Context:** After APPS_INITIALIZE

**Errors:** Raises an exception if the OU is not accessible

**Api:** FND_REQUEST.SUBMIT_REQUEST

**Module:** FND

**Does:** Submit a concurrent request from PL/SQL

**Params:** Function returning NUMBER; application (short name), program (short name), description, start_time, sub_request (FALSE), argument1 to argument100; call FND_REQUEST.SET_ORG_ID first for org-aware programs

**Context:** APPS_INITIALIZE; COMMIT after the call or the request never runs

**Errors:** Returns 0 on failure; FND_MESSAGE.GET

**Api:** FND_CONCURRENT.WAIT_FOR_REQUEST

**Module:** FND

**Does:** Wait for a request to complete and return its phase and status

**Params:** Function returning BOOLEAN; request_id, interval (seconds), max_wait (seconds, 0 = no limit); OUT phase, status, dev_phase, dev_status, message

**Context:** Request must be committed first

**Errors:** dev_phase 'COMPLETE' with dev_status 'NORMAL', 'WARNING' or 'ERROR'

**Api:** FND_USER_PKG.CREATEUSER / ADDRESP

**Module:** FND

**Does:** Create an application user; assign a responsibility

**Params:** CREATEUSER: x_user_name, x_owner, x_unencrypted_password, x_start_date, x_email_address. ADDRESP: username, resp_app, resp_key, security_group, description, start_date, end_date

**Context:** Run as APPS; commit afterwards

**Errors:** Raises exceptions; check FND_USER and FND_USER_RESP_GROUPS_DIRECT

**Api:** FND_PROFILE.VALUE / SAVE

**Module:** FND

**Does:** Read a profile value in the current context; set a value at a level

**Params:** VALUE(name). SAVE returns BOOLEAN: x_name, x_value, x_level_name ('SITE', 'APPL', 'RESP', 'USER'), x_level_value, x_level_value_app_id

**Context:** VALUE needs APPS_INITIALIZE to resolve user and responsibility levels; SAVE needs a COMMIT

**Errors:** SAVE returns FALSE on failure

**Api:** WF_ENGINE.CREATEPROCESS / STARTPROCESS / COMPLETEACTIVITY / HANDLEERROR

**Module:** Workflow

**Does:** Create and start a workflow item; push a blocked activity forward; retry or skip an errored activity

**Params:** CREATEPROCESS(itemtype, itemkey, process, user_key, owner_role); STARTPROCESS(itemtype, itemkey); COMPLETEACTIVITY(itemtype, itemkey, activity, result); HANDLEERROR(itemtype, itemkey, activity, command 'RETRY' or 'SKIP', result)

**Context:** APPS session; activity is the instance label, optionally prefixed with process name and colon

**Errors:** Raises WF_CORE exceptions; check WF_ITEM_ACTIVITY_STATUSES

**Api:** FND_MSG_PUB.GET / COUNT_MSG

**Module:** FND

**Does:** Read messages from the standard API message stack

**Params:** GET(p_msg_index, p_encoded => FND_API.G_FALSE, p_data OUT, p_msg_index_out OUT); FND_MSG_PUB.INITIALIZE clears the stack

**Context:** Same session as the API call

**Errors:** Use in a loop from 1 to x_msg_count

**Notes:** Scope: non-HR public APIs in EBS 12.1 and 12.2 (HR APIs are in a separate reference). Parameter lists are abbreviated to the ones you usually set; always check the package specification on your instance or the Integration Repository before coding.

## Content

**Intro:** A reference of the public PL/SQL APIs EBS 12.1/12.2 developers call most often outside HR: Order Management, Shipping, Inventory, BOM, Purchasing, Payables, Receivables, TCA, AOL and Workflow. Each row gives the key parameters, the session context it needs and how to read its errors.

**Sections:**

#### The standard calling pattern

**Body:** Most Oracle public APIs follow the same contract. IN parameters start with p_api_version (or p_api_version_number), p_init_msg_list (FND_API.G_TRUE to clear old messages) and p_commit (FND_API.G_FALSE so you control the transaction). OUT parameters include x_return_status, x_msg_count and x_msg_data. x_return_status is 'S' (FND_API.G_RET_STS_SUCCESS), 'E' (expected validation error) or 'U' (unexpected error). Business data is passed as record or table types declared in the package spec, such as OE_ORDER_PUB.HEADER_REC_TYPE; initialise them from the package's G_MISS constants (for example OE_ORDER_PUB.G_MISS_HEADER_REC) so unset columns mean 'not supplied'. A few older APIs are functions returning BOOLEAN or NUMBER instead, such as PO_CHANGE_API1_S.UPDATE_PO and AP_CANCEL_PKG.AP_CANCEL_SINGLE_INVOICE.

**Bullets:**

- Use named notation (p_header_rec => l_hdr) so signature changes between patch levels fail loudly
- Commit or roll back yourself after checking x_return_status
- Run as APPS, never as a product schema

#### Setting the context

**Body:** An API called from SQL*Plus or a database job has no user, responsibility or operating unit until you set them. Call FND_GLOBAL.APPS_INITIALIZE(user_id, resp_id, resp_appl_id) with a user and responsibility that could do the task in the forms; this sets WHO columns and profile values. For org-striped data call MO_GLOBAL.INIT with the product short name and then MO_GLOBAL.SET_POLICY_CONTEXT('S', org_id). Missing context is the most common reason an API returns 'E' with a vague message, or succeeds but creates data in the wrong operating unit. For concurrent requests submitted from PL/SQL, also call FND_REQUEST.SET_ORG_ID before SUBMIT_REQUEST when the program is org-aware. Inside a concurrent program the manager has already set context, so do not reset it.

#### Where to find APIs: the Integration Repository

**Body:** Oracle publishes supported interfaces in the Integration Repository, reached in 12.2 through the Integrated SOA Gateway responsibility. Search by product family or by name to see each PL/SQL package marked as public, with procedures, parameters and descriptions. Anything not listed there, or marked private (packages ending in _PVT), is not supported for customer use and can change in a patch. On a running instance the package spec in ALL_SOURCE (WHERE NAME = 'OE_ORDER_PUB' AND TYPE = 'PACKAGE') is the final word on the signature at your patch level. Product implementation and API guides on Oracle Help Center give worked examples for OM, TCA, Receivables and Purchasing APIs.

#### Worked error loop

**Body:** After calling an API that uses the FND message stack, read every message, not just x_msg_data: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN FOR i IN 1 .. l_msg_count LOOP l_msg := FND_MSG_PUB.GET(p_msg_index => i, p_encoded => FND_API.G_FALSE); DBMS_OUTPUT.PUT_LINE(i || ': ' || l_msg); END LOOP; ROLLBACK; END IF. Order Management keeps its own stack, so use OE_MSG_PUB.GET with the same arguments after PROCESS_ORDER. BOM and EGO APIs use ERROR_HANDLER, and INV_ITEM_GRP returns an error table. In production code, write messages to your own log table with the source record key rather than DBMS_OUTPUT, so a failed batch can be reworked row by row.

**Cta:** If you want a private AI agent that prepares these API calls from plain-English requests and waits for a human approval before anything is written to EBS, we can build that on your own servers.

**Faq:**

#### What are APIs in Oracle Apps R12?

**Answer:** They are Oracle-supported PL/SQL packages, mostly named with a _PUB suffix, that create or change EBS data with the same validation as the forms. Examples are OE_ORDER_PUB.PROCESS_ORDER for sales orders, AP_VENDOR_PUB_PKG for suppliers and HZ_ V2PUB packages for customers. Public ones are listed in the Integration Repository.

#### Which API creates a credit memo in Oracle EBS?

**Answer:** AR_CREDIT_MEMO_API_PUB.CREATE_REQUEST creates a credit memo request against an existing invoice using p_customer_trx_id, amounts and a reason code; with p_skip_workflow_flag set to 'Y' it creates the credit memo without the approval workflow. AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE can also create transactions of a credit memo type.

#### Why does my API return success but nothing is created?

**Answer:** Usually because p_commit was FND_API.G_FALSE and the session ended without a COMMIT, or the data went to another operating unit because MO context was set to a different org. For FND_REQUEST.SUBMIT_REQUEST, the request ID is returned but the request is invisible until you commit.

#### Are these APIs safe to call from an external integration?

**Answer:** Yes, through a supported channel: a PL/SQL wrapper called by your middleware, or the REST or SOAP services Integrated SOA Gateway can deploy over the same public packages in 12.2. Always run with a dedicated integration user and responsibility, log every call, and never call private _PVT packages.

## Search terms

oracle ebs api list, oracle ebs apis, oracle ebs api reference, api in oracle apps r12, oracle ebs integration apis, create credit memo api oracle ebs, oe_order_pub.process_order example, fnd_request.submit_request

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json