top of page

Oracle Fusion APIs and Security

It's confusing.  Let us help simplify.

Scroll down for all APIs

AP Invoices

APIs

Apply prepayments to an invoice

Method: post

Path: /fscmRestApi/resources/11.13.18.05/invoices/action/applyPrepayments

Calculate tax for the invoice

Method: post

Path: /fscmRestApi/resources/11.13.18.05/invoices/action/calculateTax

 

Cancel an invoice

Method: post

Path: /fscmRestApi/resources/11.13.18.05/invoices/action/cancelInvoice

 

Cancel an invoice line

Method: post

Path: /fscmRestApi/resources/11.13.18.05/invoices/action/cancelLine

 

Create an invoice

Method: post

Path: /fscmRestApi/resources/11.13.18.05/invoices

 

Delete an invoice

Method: delete

Path: /fscmRestApi/resources/11.13.18.05/invoices/{invoicesUniqID}

 

Generate distributions for the invoice

Method: post

Path: /fscmRestApi/resources/11.13.18.05/invoices/action/generateDistributions

 

Get all invoices

Method: get

Path: /fscmRestApi/resources/11.13.18.05/invoices

 

Get an invoice

Method: get

Path: /fscmRestApi/resources/11.13.18.05/invoices/{invoicesUniqID}

 

Reverse distributions for an Invoice

Method: post

Path: /fscmRestApi/resources/11.13.18.05/invoices/action/reverseDistributions

 

Unapply a prepayment from an invoice

Method: post

Path: /fscmRestApi/resources/11.13.18.05/invoices/action/unapplyPrepayments

 

Update an invoice

Method: patch

Path: /fscmRestApi/resources/11.13.18.05/invoices/{invoicesUniqID}

 

Validate an invoice

Method: post

Path: /fscmRestApi/resources/11.13.18.05/invoices/action/validateInvoice

Need a turnkey solution for

AP Invoice Entry and Maintenance?

We have that!

API Security

Service Operations to Privileges Mapping

Operation Name: All Operations

Privilege Code: AP_INV_CREATE_WEB_SERVICE_PRIV

Privilege Name: Create Payables Invoice by Web Service

Description: Allows creation of Oracle Fusion Payables invoices.

Operation Name: All Operations

Privilege Code: AP_CREATE_PAYABLES_INVOICE_PRIV

Privilege Name: Create Payables Invoice

Allows creation of Oracle Fusion Payables invoices.

Operation Name: getInvoiceInterface

Privilege Code: AP_INV_VIEW_WEB_SERVICE_PRIV

Privilege Name: View Payables Invoice by Web Service

Allows viewing of Oracle Fusion Payables invoices using a web service.

Operation Name: findInvoiceInterface

Privilege Code: AP_INV_VIEW_WEB_SERVICE_PRIV

Privilege Name: View Payables Invoice by Web Service

Allows viewing of Oracle Fusion Payables invoices using a web service.

Privileges to Duty Roles Mapping

Privilege Code: AP_INV_VIEW_WEB_SERVICE_PRIV

Granted to Duty Role Code: ORA_AP_PAYABLES_INVOICE_PROCESSING_DUTY

Payables Invoice Processing

Views invoices and related documents and takes action, such as approving and resolving holds.

Privilege Code: AP_CREATE_PAYABLES_INVOICE_PRIV

Granted to Duty Role Code: ORA_AP_PAYABLES_INVOICE_CREATION_DUTY

Payables Invoice Creation

Creates invoices using standard user interface or spreadsheet.

Privilege Code: AP_INV_CREATE_WEB_SERVICE_PRIV

Granted to Duty Role Code: ORA_AP_PAYABLES_INVOICE_PROCESSING_DUTY

Payables Invoice Processing

Views invoices and related documents and takes action, such as approving and resolving holds.

Privilege Code: AP_INV_CREATE_WEB_SERVICE_PRIV

Granted to Duty Role Code: ORA_AP_PAYABLES_INVOICE_IMPORT_SUBMISSION_DUTY

Payables Invoice Import Submission

Submits Oracle Fusion Payables invoice import program.

Duty Roles to Duty or Job Roles Mapping

Duty Role Code: ORA_AP_PAYABLES_INVOICE_CREATION_DUTY

Granted to Duty or Job Role Code:

ORA_FUN_FSCM_LOAD_INTERFACE_ADMIN_DUTY

FSCM Load Interface Administration

Description: Manages load interface file for import

Duty Role Code: ORA_AP_PAYABLES_INVOICE_IMPORT_SUBMISSION_DUTY

Granted to Duty or Job Role Code:

ORA_FUN_FSCM_LOAD_INTERFACE_ADMIN_DUTY

Granted to Duty or Job Role Name: FSCM Load Interface Administration

Description: Manages load interface file for import

Duty Role Code: ORA_AP_PAYABLES_INVOICE_CREATION_DUTY

Granted to Duty or Job Role Code: ORA_EGP_ITEM_INQUIRY_DUTY

Granted to Duty or Job Role Name: Item Inquiry

Description: Queries and views items in the enterprise.

Duty Role Code: ORA_AP_PAYABLES_INVOICE_PROCESSING_DUTY

Granted to Duty or Job Role Code: ORA_EGP_ITEM_INQUIRY_DUTY

Granted to Duty or Job Role Name: Item Inquiry

Description: Queries and views items in the enterprise.

Duty Role Code: ORA_AP_PAYABLES_INVOICE_CREATION_DUTY

Granted to Duty or Job Role Code: ORA_POZ_USE_REST_SERVICE_VIEW_SUPPLIER_PROFILE

Granted to Duty or Job Role Name: Supplier Profile Viewing Using REST Service

Description: Allows users to call the get method with the Supplier REST service for all rows.

Duty Role Code: ORA_AP_PAYABLES_INVOICE_PROCESSING_DUTY

Granted to Duty or Job Role Code: ORA_POZ_USE_REST_SERVICE_VIEW_SUPPLIER_PROFILE

Granted to Duty or Job Role Name: Supplier Profile Viewing Using REST Service

Description: Allows users to call the get method with the Supplier REST service for all rows.

Duty Role Code: ORA_AP_PAYABLES_INVOICE_CREATION_DUTY

Granted to Duty or Job Role Code: ORA_MANAGE_TRADING_COMMUNITY_IMPORT_BATCH_DUTY_FSCM

Granted to Duty or Job Role Name: Trading Community Import Batch Management

Description: Manages trading community data import batches.

Duty Role Code: ORA_AP_PAYABLES_INVOICE_CREATION_DUTY

Granted to Duty or Job Role Code: ORA_MANAGE_TRADING_COMMUNITY_IMPORT_PROCESS_DUTY_FSCM

Granted to Duty or Job Role Name: Trading Community Import Process Management

Description: Manages trading community data import batch processes.

For more details:

https://docs.oracle.com/en/cloud/saas/financials/24a/farfa/api-invoices.html

https://docs.oracle.com/en/cloud/saas/financials/24a/oeswf/payablesinvoice-d16476e27824.html#Security

image.png

Customers

APIs

Create an organization

Method: post

Path: /crmRestApi/resources/11.13.18.05/hubOrganizations

 

Delete an organization

Method: delete

Path: /crmRestApi/resources/11.13.18.05/hubOrganizations/{PartyNumber}

 

Find duplicates

Method: post

Path: /crmRestApi/resources/11.13.18.05/hubOrganizations/action/findDuplicates

 

Get all organizations

Method: get

Path: /crmRestApi/resources/11.13.18.05/hubOrganizations

 

Get an organization

Method: get

Path: /crmRestApi/resources/11.13.18.05/hubOrganizations/{PartyNumber}

 

Promote the selected account in the duplicate set

Method: post

Path: /crmRestApi/resources/11.13.18.05/hubOrganizations/action/promoteDuplicateParty

 

Update an organization

Method: patch

Path: /crmRestApi/resources/11.13.18.05/hubOrganizations/{PartyNumber}

Create a person

Method: post

Path: /crmRestApi/resources/11.13.18.05/hubPersons

 

Delete a person

Method: delete

Path: /crmRestApi/resources/11.13.18.05/hubPersons/{PartyNumber}

 

Find duplicates

Method: post

Path: /crmRestApi/resources/11.13.18.05/hubPersons/action/findDuplicates

 

Get a person

Method: get

Path: /crmRestApi/resources/11.13.18.05/hubPersons/{PartyNumber}

 

Get all persons

Method: get

Path: /crmRestApi/resources/11.13.18.05/hubPersons

 

Update a person

Method: patch

Path: /crmRestApi/resources/11.13.18.05/hubPersons/{PartyNumber}

 

Customer Accounts

WSDL URL https://servername/crmService/CustomerAccountService

                     foundationParties/CustomerAccountService

http://xmlns.oracle.com/apps/cdm/foundation/parties/customerAccountService/}CustomerAccountSiteUse

Customer Profiles

WSDL https://servername/fscmService/ReceivablesCustomerProfileService

https://www.ateam-oracle.com/post/a-simple-guide-to-erp-cloud-customer-creation-through-integration

Need a turnkey solution for

Customer Entry and Maintenance?

We have that!

Security

Operation Name: getOrganizationsFilteredByPartyUsageFilterRuleCode

HZ_VIEW_TRADING_COMMUNITY_ORGANIZATION_PRIV

View Trading Community Organization

Allows exporting, searching, and viewing of organization details such as addresses, classifications, identifiers, and names.

 

Operation Name: createOrganization

HZ_ENTER_TRADING_COMMUNITY_ORGANIZATION_INFORMATION_PRIV

Enter Trading Community Organization Information

Allows the specification of organization information.

 

Operation Name: All Operations

HZ_ENTER_TRADING_COMMUNITY_ORGANIZATION_INFORMATION_PRIV

Enter Trading Community Organization Information

Allows the specification of organization information.

 

Operation Name: getOrganization

HZ_VIEW_TRADING_COMMUNITY_ORGANIZATION_PRIV

View Trading Community Organization

Allows exporting, searching, and viewing of organization details such as addresses, classifications, identifiers, and names.

 

Operation Name: updateOrganization

HZ_UPDATE_TRADING_COMMUNITY_ORGANIZATION_PRIV

Update Trading Community Organization

Allows the update of the organization relationship information. If assigning, also assign the ability to view the trading community organization relationship.

Operation Name: deleteOrganization

HZ_REMOVE_TRADING_COMMUNITY_ORGANIZATION_PRIV

Remove Trading Community Organization

Allows the removal of organizations. If assigning, also assign the ability to view the trading community organization.

 

Operation Name: findOrganization

HZ_VIEW_TRADING_COMMUNITY_ORGANIZATION_PRIV

View Trading Community Organization

Allows exporting, searching, and viewing of organization details such as addresses, classifications, identifiers, and names.

 

Operation Name: processCSOrganization

HZ_UPDATE_TRADING_COMMUNITY_ORGANIZATION_PRIV

Update Trading Community Organization

Allows the update of the organization relationship information. If assigning, also assign the ability to view the trading community organization relationship.

 

Operation Name: processCSOrganization

HZ_ENTER_TRADING_COMMUNITY_ORGANIZATION_INFORMATION_PRIV

Enter Trading Community Organization Information

Allows the specification of organization information.

 

Operation Name: getOrganizationByOriginalSystemReference

HZ_VIEW_TRADING_COMMUNITY_ORGANIZATION_PRIV

View Trading Community Organization

Allows exporting, searching, and viewing of organization details such as addresses, classifications, identifiers, and names.

 

Operation Name: mergeOrganization

HZ_UPDATE_TRADING_COMMUNITY_ORGANIZATION_PRIV

Update Trading Community Organization

Allows the update of the organization relationship information. If assigning, also assign the ability to view the trading community organization relationship.

 

Operation Name: mergeOrganization

HZ_ENTER_TRADING_COMMUNITY_ORGANIZATION_INFORMATION_PRIV

Enter Trading Community Organization Information

Allows the specification of organization information.

 

Operation Name: getOrganizationsFilteredByPartyUsageCode

HZ_VIEW_TRADING_COMMUNITY_ORGANIZATION_PRIV

View Trading Community Organization

Allows exporting, searching, and viewing of organization details such as addresses, classifications, identifiers, and names.

 

Operation Name: processOrganization

HZ_UPDATE_TRADING_COMMUNITY_ORGANIZATION_PRIV

Update Trading Community Organization

Allows the update of the organization relationship information. If assigning, also assign the ability to view the trading community organization relationship.

 

Operation Name: processOrganization

HZ_ENTER_TRADING_COMMUNITY_ORGANIZATION_INFORMATION_PRIV

Enter Trading Community Organization Information

Allows the specification of organization information.

Operation Name: getCustomerAccountSiteUseByKey

HZ_VIEW_CUSTOMER_ACCOUNT_PRIV

View Customer Account

Allows the viewing of customer account information.

 

Operation Name: getCustomerAccount

HZ_VIEW_CUSTOMER_ACCOUNT_PRIV

View Customer Account

Allows the viewing of customer account information.

 

Operation Name: findCustomerAccountSiteUse

HZ_VIEW_CUSTOMER_ACCOUNT_PRIV

View Customer Account

Allows the viewing of customer account information.

 

Operation Name: findCustomerAccount

HZ_VIEW_CUSTOMER_ACCOUNT_PRIV

View Customer Account

Allows the viewing of customer account information.

 

Operation Name: createCustomerAccount

HZ_ENTER_CUSTOMER_ACCOUNT_PRIV

Enter Customer Account

Allows the update of customer account information. If assigning, also assign the ability to view the customer account.

 

Operation Name: processCustomerAccount

HZ_UPDATE_CUSTOMER_ACCOUNT_PRIV

Update Customer Account

Allows the update of customer account information. If assigning, also assign the ability to view the customer account.

 

Operation Name: processCustomerAccount

HZ_ENTER_CUSTOMER_ACCOUNT_PRIV

Enter Customer Account

Allows the update of customer account information. If assigning, also assign the ability to view the customer account.

 

Operation Name: getCustomerAccountByOriginalSystemReference

HZ_VIEW_CUSTOMER_ACCOUNT_PRIV

View Customer Account

Allows the viewing of customer account information.

 

Operation Name: processCSCustomerAccount

HZ_UPDATE_CUSTOMER_ACCOUNT_PRIV

Update Customer Account

Allows the update of customer account information. If assigning, also assign the ability to view the customer account.

 

Operation Name: processCSCustomerAccount

HZ_ENTER_CUSTOMER_ACCOUNT_PRIV

Enter Customer Account

Allows the update of customer account information. If assigning, also assign the ability to view the customer account.

 

Operation Name: deleteCustomerAccount

HZ_REMOVE_CUSTOMER_ACCOUNT_PRIV

Remove Customer Account

Allows the removal of customer accounts. If assigning, also assign the ability to view the customer account.

 

Operation Name: mergeCustomerAccount

HZ_UPDATE_CUSTOMER_ACCOUNT_PRIV

Update Customer Account

Allows the update of customer account information. If assigning, also assign the ability to view the customer account.

 

Operation Name: mergeCustomerAccount

HZ_ENTER_CUSTOMER_ACCOUNT_PRIV

Enter Customer Account

Allows the update of customer account information. If assigning, also assign the ability to view the customer account.

 

Operation Name: updateCustomerAccount

HZ_UPDATE_CUSTOMER_ACCOUNT_PRIV

Update Customer Account

Allows the update of customer account information. If assigning, also assign the ability to view the customer account.

For more details:

https://docs.oracle.com/en/cloud/saas/sales/faaps/api-hub-organizations.html

https://www.ateam-oracle.com/post/a-simple-guide-to-erp-cloud-customer-creation-through-integration

https://docs.oracle.com/en/cloud/saas/sales/oesws/tradingcommunityorganization-d41e154968.html#Security

 

https://docs.oracle.com/en/cloud/saas/sales/oesws/tradingcommunitycustomeraccount-d41e157556.html#Security

​​

Learn more

API Wizard

The Oracle Fusion Cloud Apps and EBS Productivity Platform

Stamford, CT, USA

1.800.691.8714

Content copyright 2024, API Wizard.  All rights reserved.

image.png
bottom of page