Oracle Applications

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

Here is the post on creating a folder in Oracle BI EE 11. I know this is very simple task, but sometimes if you are a new to this of...

Here are the navigation steps to access the "Manage File Import activities" in Oracle cloud applications. 1. Login to Oracle...

Here is the Sample Oracle SQL Query for the STATS collection. select t.last_analyzed, nvl(num_rows,0) num_rows, t.* from all_tables...

Here is the oracle sql query that can be used to find out the time taken in hours, minutes and second. This sql query converts the dat...

Assume you have requirement to validate the start date and end date for each record provided and your validation or check should be that ev...

Here is the sample script to refresh the materialized view. DECLARE BEGIN   DBMS_MVIEW.refresh('EMP_MV');    --'EMP_MV ...

Here is the continuation part of the sample question and answers for the developer foundation training. Note : These are the sampl...