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 MoreIntroduction: 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 MoreIntroduction: 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 MoreSupplier 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 MoreCustomer 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 MoreIntroduction:-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 MoreIntroduction:- 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 MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction: 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 MoreIntroduction: 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