Oracle Applications

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...

  Here is the sample SQL Query to fetch the basic General Ledger( GL ) - SQL Query in the Oracle Cloud fusion. This query may ...

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

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

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

Here is the generic Supplier Site Details as per the FBDI template in the Oracle fusion.  select psv.vendor_name  ,pssam.ven...

Here is the generic SQL Query to fetch the basic Suppliers Details as per the Oracle FBDI template.   SELECT pos.vendor_n...

Here is the SQL Query to get the Supplier Basic information such as Supplier Name, Supplier Site, Vendor Site ID. Use this query, modi...

Here is the quick SQL Query to get the Purchase Order(PO) FBDI Import Error details for all the PO's which are errored out....

Here is the SQL Query to get the Legal entity in Oracle fusion. SQL Query SELECT * FROM XLE_ENTITY_PROFILES where TRUNC (...

Here is the quick post to import the Purchase orders using the FBDI process. 1.  Log in to the application and click on navigator i...

Here is the Rest API for the Oracle fusion to delete the UnProcessed Projects Costs. The input for this Rest API is the Transactio...

Here is the table name in the Oracle fusion cloud application, where the TaxPayer ID gets stored.                              POZ_...

VAT Code and Tax Registration Number at the Supplier Site FBDI upload. These two columns are dummy columns and are not uploaded th...

Here is the query to find the Supplier Site Service Tolerance and Quantity Tolerances configuration setups in Oracle fusio...

Here is the import program to purge the PO receipts interface table : " Purge Receiving Interface" Th...

Here is the table name where the exclusive_payment_flag of the supplier site is stored : iby_external_payees_all

Here is the SQL Query to fetch the Project Contracts Billing Cycle setup details in Oracle cloud. SELECT 'Billing Cycle' ...

Here is the SQL Query to fetch the Project Billing Currency Type codes in Oracle cloud fusion. SELECT 'Billing Currency Type...

Here is the SQL Query to fetch the payment terms setups in Oracle cloud. SELECT 'PAYMENT TERM' "SETUP_NAME",  ...

Here is the SQL Query to get the Contract Party Role Setup details in Oracle cloud fusion. SELECT  'Party Role Code' ...

Here is the SQL Query to get the Organization ID in Oracle cloud fusion. This query can be tweaked accordingly for the further req...