Oracle Cloud – Supplier FBDI Interface, Base Table, Error Table Details

Reference:

http://oratrainings.com/oracle-cloud-supplier-fbdi-interface-base-table-error-table-details/

Entity	UCM	Import Process	Interface Table	Base Table/View
Suppliers	prc/supplier/import	Import Suppliers	POZ_SUPPLIERS_INT	POZ_SUPPLIERS
Supplier Addresses	prc/supplier/import	Import Supplier Addresses	POZ_SUP_ADDRESSES_INT	POZ_SUPPLIER_ADDRESS_V
Supplier Site Import	prc/supplier/import	Import Supplier Sites	POZ_SUPPLIER_SITES_INT	POZ_SUPPLIER_SITES_ALL_M
Supplier Site Assignments	prc/supplier/import	Import Supplier Site Assignments	POZ_SITE_ASSIGNMENTS_INT	poz_site_assignments_all_m
Supplier Contacts	prc/supplier/import	Import Supplier Contacts	POZ_SUP_CONTACTS_INT POZ_SUP_CONTACT_ ADDRESSES_INT	poz_supplier_contacts

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.