Posts by Jilani Basha

User is not as employee roles in Oracle Cloud

Introduction: This blog has the SQL query that can be used to pull the data for the oracle cloud users having what roles & for which BU it is assigned…

Read More

Cloud Critical Users Roles with respective BU Wise

Introduction: This blog has the SQL query that can be used to pull the data for the oracle cloud critical users having what roles & for which BU it is…

Read More

Supplier Unmasked bank details Report Query

Supplier Unmasked bank details Report Query Introduction:   This SQL query is used to fetching the data of supplier unmasked bank details to identify if there were any setup was…

Read More

Customer collector name at site level query

Customer collector name at site level query Introduction:   This SQL query is used to fetching the data of customer and collector name at site level.   Cause of the…

Read More

Query to get details of all Concurrent programs used by a Request Set

Introduction:-This script will provide all concurrent programs under request set Code:- SELECT rs.user_request_set_name “Set_Name”, rs.request_set_name “Set_code”, rs.description “Description”, rss.display_sequence Seq, cp.user_concurrent_program_name “Conc_Program”, ap.application_name “Application”, e.executable_name “Executable”, e.execution_file_name “Executable File”, lv.meaning…

Read More

Country wise Catalog and Non Catalog Po’s in Oracle EBS

Introduction:- Using the below SQL script we can get the Catalog and Non Catalog Po’s details from country wise. Code:- SELECT P.SEGMENT1 “PO Number” ,PL.LINE_NUM “PO Line”,TO_CHAR(P.CREATION_DATE,’DD-MON-RRRR HH24:MI:SS’) “PO Created…

Read More

Query to get Payment Reversal

Introduction Business requested to provide the Payment reversal information   Cause of the issue: Business want to cross check with Payment reversals   How do we solve: We have created…

Read More

Query to get AR Adjustments

Introduction Business requested to provide the date for AR Adjustments for a particular period   Cause of the issue: Business want to tally the data with uploaded Adjustments.   How…

Read More

Customer Contact Extraction Query in Fusion FSCM

Introduction:   This SQL query is used to fetching the data of Customer contact details like Customer Name, Contact Name, Email Address Contact Number and Dunning Letters etc… In this…

Read More

Customer CIF Extraction Query in Fusion FSCM

Introduction:   This SQL query is used to fetching the data of Customer CIF information to identify whether we have any duplicate CIF numbers exists or not.   Cause of…

Read More