Thursday, 13 July 2023

Tables for the Tax Registrations in Oracle fusion

›
 Here are the tables used for the Tax Registrations for Suppliers and Customers 1. HZ_PARTIES 2. POZ_...

Tables for the Profiles , Profile Options in Oracle fusion

›
 Here are the tables for the Profiles in Oracle fusion. 1. FND_PROFILE_OPTIONS_B 2. FND_PROFILE_OPTION_VALUES 3. FND_PROFI...

Tables for the Users , Roles and Data Access in Oracle fusion.

›
 Here are the tables used for the Users, Roles and Data Access in Oracle fusion. 1. PER_ROLES 2. PER_ROLES_DN_VL 3. PER_U...
Saturday, 10 December 2022

Tables for the Discount Lists in Oracle Fusion.

›
 Here are the following base tables for the Discount Lists in the Oracle Fusion qp_discount_lists_vl q...

Tables for the HCM Employee Information in Oracle Fusion.

›
 This post will provide the details of the base tables that are useful for fetching the Employee Information in the Oracle...
Wednesday, 23 November 2022

Tables for the Item Import in Oracle Fusion

›
 Here are the tables used for the Item Import in Oracle fusion. 1.egp_import_errors 2.egp_system_items_interface And here...

Tables for the FA Interface in Oracle Fusion

›
 Here are the tables used for the FA(Fixed Asset) import in Oracle fusion : 1. FA_MASS_ADDITIONS To check the records whic...
Thursday, 3 November 2022

Tables for the AP Invoice Interfaces and Errors in Oracle Cloud Fusion

›
 In this post, I will provide you the list of the Interface tables for the AP Invoices import in Oracle cloud fusion and ...

Sample SOAP Web service to apply the Oracle AR receipt

›
 Here is the sample SOAP Web service for applying the AR Receipt.  WSDL : <Instance Name>/fscmService/StandardReceip...

Sample Rest Web service Payload to create the Oracle AR Receipt

›
 Here is the sample Rest Web service payload to create the AR Receipt. Do modify the values accordingly and test them. ...
Friday, 16 July 2021

How to Import Project Misc Cost in Oracle Fusion using the FBDI

›
 In this post, we will see how to import the Project Miscellaneous Cost using the Oracle FBDI templates in the fusion. 1. ...
Thursday, 15 July 2021

Tables for the PO Interface Errors in Oracle Fusion.

›
 Here is the post which provides details about the PO Interface Error Table.             PO_INTERFACE_ERRORS Following are...

Tables for the Contract Attachments in Oracle Fusion.

›
 Following are the tables involved in the Contract Attachments in Oracle Fusion. 1. FND_ATTACHED_DOCUMENTS 2. FND_DOCUMENT...

Tables for Contracts in Oracle fusion.

›
 In this post we will see the base tables for the Contracts in Oracle fusion.  These are some of the tables involved in th...

How to Import Journals with the Descriptive Flex Fields in Oracle fusion.

›
In order to import the Import Journals in Oracle fusion along with the Descriptive Flexfields, make sure that you have the...

Import Journals - GL Interface table in Oracle fusion.

›
For the Import Journals - General Ledger, below is the interface table used in Oracle fusion. GL_INTERFACE In order to i...
Thursday, 24 June 2021

Tables for Supplier Bank Accounts in Oracle fusion

›
 Here are the interface tables for the Supplier Bank Accounts in Oracle fusion : 1. IBY_TEMP_EXT_PAYEES This table stores ...

Supplier Banks Accounts - Uploading files into UCM - Oracle fusion

›
 The Supplier Bank Accounts Import has the three different csv files 1. Supplier Bank Accounts 2. Supplier Payees 3. Supplier Accounts...
Thursday, 7 January 2021

Tables for the General Ledger - Journals (GL) in Oracle fusion.

›
Here are the tables for the GL Ledger in Oracle fusion. This tables will store the details of the General Ledger Journals ...

Supplier Site Import Process Not Populating The Tax Registration Number (VAT Registration Number) - Oracle fusion Cloud

›
Supplier Site FBDI has two columns VAT Code and Tax Registration Number. Th ese two fields are   not   imported through the   Supplier   Sit...
Wednesday, 6 January 2021

SQL Query to fetch the Unposted GL Journal Batches in Oracle fusion.

›
 Here is the SQL query to fetch the Unposted GL Journal batches in the Oracle fusion.This query might be helpful in case i...
Wednesday, 18 November 2020

Import Program to Import PO receipts in Oracle fusion.

›
 Here is the quick post to import the Purchase orders(PO) Receipts using the FBDI process. 1. Log in to the application a...