Friday, 16 October 2020

Supplier Interface error tables in Oracle Cloud Fusion.

›
In this post, I will provide you the list of the Interface tables for the Suppliers import in Oracle cloud fusion and also...
Wednesday, 7 October 2020

Tables for the AP Invoice in Oracle fusion

›
Here are the tables for the AP Invoice in Oracle fusion. This tables will store the details of the Invoice information and...

Tables for the PO Receipts in Oracle fusion

›
Here are the tables for the PO Receipts in Oracle fusion. This tables will store the details of the  PO Receipts informati...
Tuesday, 6 October 2020

Tables for the Projects Module in Oracle fusion

›
Here are the tables for the Project modules in Oracle fusion. This tables will store the details of the  Project informati...

Tables for the PO(Purchase Order) in Oracle fusion

›
Here are the tables for the PO(Purchase Order) in Oracle fusion. This tables will store the details of the  Purchase Order...

Tables for the Items in Oracle fusion

›
Here are the Oracle tables for the Items in Oracle fusion. This tables will store the details of the  Items and related It...

Tables for the Sales Contracts in Oracle fusion

›
Here are the tables for the Contract in Oracle fusion. This tables will store the details of the  Contract information. 1...
Monday, 5 October 2020

Oracle SQL - Interview Questions

›
 In this post, we provide the list of Basic SQL Interview questions. 1.       What is the difference between Delete and T...
Friday, 2 October 2020

How to create an ESS Job in Oracle fusion for a BIP report

›
This post provides the details about how to create an ESS job for the Oracle BIP report. Below are the steps mentioned b...
Thursday, 1 October 2020

Oracle SQL Query to get the Contract Attachments/Documents Details in Oracle fusion.

›
Here is the SQL Query to get the Contract Attachments/Documents details in Oracle fusion. This query can be modified accor...

Tables for the Contract Documents/Attachments in Oracle fusion

›
Here are the tables for the Contract Documents/Attachments in Oracle fusion. This tables will store the primary and secondary ...
Tuesday, 29 September 2020

IN and NVL Function in Oracle BIP Data model SQL Query.

›
Here is the sample query where you can use IN clause and NVL Function in the SQL Query - where clause in the Oracle BIP report...

Sample General Ledger ( GL ) Journal - SQL Query - Oracle Cloud Fusion.

›
  Here is the sample SQL Query to fetch the basic General Ledger( GL ) - SQL Query in the Oracle Cloud fusion. This query may ...
Wednesday, 19 August 2020

SQL Query to get the Supplier Site Assignment - Oracle Fusion.

›
 Here is the generic SQL Query to get the Supplier Site Assignment details as per the FBDI template in the Oracle Fusion. se...

SQL Query to get the Supplier Contact Details - Oracle Fusion.

›
 Here is the generic SQL Query to get the Supplier Contact details as per the FBDI template in Oracle fusion. select...

SQL Query to get the Supplier Address Details - Oracle Fusion.

›
Here is the generic Suppliers Address Details as per the FBDI Template. SELECT     hp.party_name           ,psa.pa...