Oracle Cloud ERP - Payable invoice FBDI interface, Error and Base tables

Here, we will share the details for different ERP tables used for Payable invoice FBDI import.

As follows:

Entity	UCM	Import Process	Interface Table	Base Table/View
Headers	fin/payables/import	Import Payables Invoices	AP_INVOICES_INTERFACE	AP_INVOICES_ALL
Lines	fin/payables/import	Import Payables Invoices	AP_INVOICE_LINES_INTERFACE	AP_INVOICE_LINES_ALL
			*Interface table not there**	AP_INVOICE_DISTRIBUTIONS_ALL
Error Table				AP_INTERFACE_REJECTIONS

ERP - Sample supplier callback payload from Oracle cloud erp

Sample supplier callback:

<ns01:onEvent xmlns:ns01="http://xmlns.oracle.com/cloud/adapter/erp/receiveSuppliersCallbackSD_REQUEST/types">

  <ns0:ErpImportBulkDataEvent xmlns:ns0="http://xmlns.oracle.com/apps/financials/commonModules/shared">

  <ns0:SUMMARYSTATUS>SUCCEEDED</ns0:SUMMARYSTATUS>    <ns0:DOCUMENTID>20208094</ns0:DOCUMENTID>

    <ns0:JOBS>

      <ns0:CHILD>      <ns0:JOBPATH>/oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader</ns0:JOBPATH>       

<ns0:REQUESTID>20948508</ns0:REQUESTID>

       <ns0:JOBNAME>Transfer File</ns0:JOBNAME>

        <ns0:STATUS>SUCCEEDED</ns0:STATUS>

      </ns0:CHILD>

      <ns0:CHILD>

        <ns0:JOBPATH>/oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader</ns0:JOBPATH>

        <ns0:REQUESTID>20948509</ns0:REQUESTID>

        <ns0:JOBNAME>Load File to Interface</ns0:JOBNAME>

        <ns0:STATUS>SUCCEEDED</ns0:STATUS>

      </ns0:CHILD>

      <ns0:JOBPATH>/oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader</ns0:JOBPATH>

      <ns0:REQUESTID>20948507</ns0:REQUESTID>

      <ns0:JOBNAME>Load Interface File for Import</ns0:JOBNAME>

      <ns0:DOCUMENTNAME>PozSuppliersInt2023-03-10T07:31:44.756Z.zip</ns0:DOCUMENTNAME>

      <ns0:STATUS>SUCCEEDED</ns0:STATUS>

    </ns0:JOBS>

    <ns0:JOBS>

      <ns0:JOBPATH>/oracle/apps/ess/prc/poz/supplierImport</ns0:JOBPATH>

      <ns0:REQUESTID>20948510</ns0:REQUESTID>

      <ns0:JOBNAME>Import Suppliers</ns0:JOBNAME>

      <ns0:STATUS>SUCCEEDED</ns0:STATUS>

    </ns0:JOBS>

    <ns0:JOBS>

      <ns0:JOBPATH>/oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader</ns0:JOBPATH>

      <ns0:REQUESTID>20948512</ns0:REQUESTID>

      <ns0:JOBNAME>Upload Interface Error and Job Output File to Universal Content Management</ns0:JOBNAME>

      <ns0:STATUS>SUCCEEDED</ns0:STATUS>

    </ns0:JOBS>

    <ICSFile xmlns="http://xmlns.oracle.com/cloud/ics/file/v1/types">

      <FileReference>file:/5dc58116-b7eb-4275-82b8-4cb202ee6dc5@_@FWuOVOF4UhKKvvPWIeKnwpHZg3AqNgjOdJL7GmRMald1FkKH0AU2ieloHd8JJgbKOkUK0TIag6REcUqA2J81kw==</FileReference>

    </ICSFile>

  </ns0:ErpImportBulkDataEvent>

</ns01:onEvent>

Oracle Cloud ERP - which role required to show suppliers section under procurement

Usecase: Here, we will discuss which roles are required to be able to create suppliers or to show suppliers section under procurement.

Resolution:

User with "Supplier Administrator" role is able to access Supplier link in the Navogator but the create supplier option is not available in the Tasks ot Actions. User should have "Supplier Manager" role.

Note: we can add "account Payable Manager" role for payable invoice section.

Steps to add role to the assigned user:

Navigation >> Tools >> Security console >> users >> search user and click the user >> edit >> add role 

Added " account Payable Manager" role for payable invoice section.

OIC - ERP - Supplier import failed due to Supplier type is inactive or invalid | VENDOR_TYPE_LOOKUP_CODE

Usecase: We were trying to import a supplier to oracle cloud ERP and we have observed its failed due to the follow error : 

• Rejection Remarks: " Supplier  Type is inactive or invalid " 
• Attribute: VENDOR_TYPE_LOOKUP_CODE
• Value: Supplier

Here, we will show you how to overcome this issue.

Error details:

Navigation >> Tools >> Scheduled Processes >> Import Suppliers in error

ERP setup / configuration:

Home Navigation >> others >> setup and maintenance >> setup : Procurement >> Functional areas: Suppliers >> Manage Supplier Type Lookup >> enable the supplier code which is required(in my case i have enabled supplier).

Success import status:

Navigation >> Tools >> Scheduled Processes >> Import Suppliers as succeeded.

We can also track imported supplier

Procurement >> Suppliers >> Manage Suppliers >> search with Supplier number or other details.

OIC - Create an ERP cloud adapter connection in oracle integration

Usecase: Here, we will show you how to create an ERP cloud connection in OIC instance.

Steps:

OIC instance >> Integrations >> Connections >> Search Oracle Cloud ERP >> provide connection name >> provide connection details(ERP Host, Security policy as Username password token)

Test >> save

Oracle Cloud ERP : Missing Scheduled Processes function while creating an integration user

Issue: 

Missing 'Scheduled Processes' function under the Navigator > Tools

Investigation:  

Default installation does not assign roles such as employee, contigent worker  applocation admin etc to the SuperUser Account.

Solution:

Simply assign the Employee role to that user using superUser Account. Logout and login with the user and navigate to Tools >> nlw you will be able to see the function "Scheduled Processes".

Role :

Name: Employee

Code: ORA_PER_EMPLOYEE_ABSTRACT 

SOA_ADMIN_ROLE

Code: SOA_ADMIN_ROLE

Navigation >> Tools >> Security Console >> Users

Save and close

Now run the Retrieve Latest LDAP changes to reflect the roles.

Tools >> Scheduled Processes >> Scheduled New Process >> submit the job : Retrieve Latest LDAP Changes

Once the sync roles job succeeded, login the ERP with the created User and verify if scheduled processes and Reports and Analytics exist under Tools.

ERP - Register the CSF key | subscribe to Oracle Fusion Cloud | Subscribe to Fusion Business Events and FBDI Callback

Usecase: To Subscribe to Fusion Business Events and FBDI Callback: 

In a FA-based SaaS instance, the outbound call of a webservice uses a OWSM security policy which retrieves the credentials for the call from a CSF Key. This means that you need to register a CSF key for every connection to an external system

Register CSF key(Identity domain and OIC Service name) under Manage Security of SOA Composer in Fusion SaaS.

Detailed Steps with screenshots:

Login to soa composer

https://<Oracle Fusion ERP Cloud Instance>/soa/composer

Manage Security

Provide the CSF key details. The details will be fetched from OIC instance >> profile >> about 

CSF key: concating with Identity domain and OIC Service instance name

And provide OIC instance user and password details.

Note: to know how to create an integration user in ERP, follow my below link:

https://soalicious.blogspot.com/2023/03/erp-create-integration-user-with.html