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

Using below query we can get dunning contact information.       SELECT      account_number customer_number,      party_name     customer_name,      (          SELECT              [...]

Using Below script we can update payment terms for suppliers.       DECLARE      p_customer_profile_rec         hz_customer_profile_v2pub.customer_profile_rec_type;      [...]