Procedure to create Quality Test Values alone in OPM through API
Introduction: This blog has the PLSQL query that can be used to create Quality Test Values alone using oracle seeded API. Cause of the issue: Business will…
Read MoreProcedure to create Quality Test & Quality Test Values in OPM through API
Introduction: This blog has the PLSQL query that can be used to create Quality Test & Quality Test Values using oracle seeded API. Cause of the issue:…
Read MoreProcedure to create Quality Spec WIP Validity Rule in OPM through API
Introduction: This blog has the PLSQL query that can be used to create Quality Spec WIP Validity Rule using oracle seeded API. Cause of the issue: Business…
Read MoreProcedure to create Quality Spec INV Validity Rule in OPM through API
Introduction: This blog has PLSQL query that can be used to create Quality Spec INV Validity Rule using oracle seeded API. Cause of the issue: Business will…
Read MoreProcedure to create Quality Spec & Quality Spec Values in OPM through API
Introduction: This blog has the PLSQL query that can be used to create Quality Spec & Quality Spec Values using oracle seeded API. Cause of the issue:…
Read MoreUser 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 MoreCloud 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 MoreSupplier 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 MoreCustomer 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 MoreQuery 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