declare ln_trx_number VARCHAR2 (50); v_api_version NUMBER := 1.0; — V_init_msg_list VARCHAR2(1) := FND_API.G_FALSE; v_init_msg_list VARCHAR2 (1) := fnd_api.g_true; v_commit VARCHAR2 (1) := fnd_api.g_false; v_validation_level …
Read Moreexec mo_global.set_policy_context(‘S’,:&p_org_id); SELECT DISTINCT gjb.NAME journal_batch_name, gjh.NAME, gjh.default_effective_date gldate, msi.segment1 item, NULL brand, rct.bill_to_site_use_id bill_to_site_use_id, hca.account_number customer, gcc.segment3 “GL ACCT 3”, gcc.segment1 company, rct.interface_header_attribute2 ordertype, rctt.NAME ar_transaction_type, rctl.sales_order order_number, rct.trx_number…
Read MoreIntroduction Integrating our Linux instances with Microsoft Active Directory (AD) can streamline user management, here will walk you through the steps needed to integrate a Linux…
Read MoreLIST OF ALL ACTIVE USERS ALONG WITH THEIR ACTIVE RESPONSIBILITIES Introduction: This query is used to get all active users along with their active responsibilities. SQL Query: Execute the…
Read MoreIntroduction/Issue: As organizations scale their cloud infrastructure, maintaining consistent and effective monitoring becomes crucial. One common issue is the manual setup of monitoring and alerting for each new resource provisioned…
Read MoreQuery to get the Service Contract Details Introduction: This query is used to fetch the service contract details.In this we will be passing contract_number as the parameter. SQL Query:…
Read MoreIntroduction/Issue: In large-scale Kubernetes environments, managing and controlling resource allocation among different namespaces can become challenging. Teams often face issues where one namespace consumes more resources than expected, leading to…
Read MoreIntroduction/Issue While working with Oracle APEX, developers often encounter issues where the application does not behave as expected. These issues can range from errors in PL/SQL processes, unexpected behavior in…
Read MoreIntroduction In Oracle Cloud Infrastructure (OCI), the OCI Stack provides a powerful and streamlined way to manage infrastructure with Terraform directly from the OCI Console. In this document, we will…
Read MoreIntroduction / Issue: While accessing the UAT Oracle APEX application, users encountered a 500 Internal Server Error. This error typically indicates that there is a problem on the server side,…
Read More