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 if it is not an employee.   Cause [...]

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 assigned.   Cause of the issue: [...]

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 missed for [...]

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 issue: User’s unable [...]

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”, [...]

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

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 below [...]

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 do we solve: [...]

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

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 the issue: [...]