Unapply Incorrect Closed Claims
Introduction: We have a Receipt with a “Claim Investigation” where the Claim # was not populated. The below script will help to resolve that issue. w do we solve:…
Read MoreApplying Claim in AR Receipts
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 MoreGL Data Extract in EBS for both Receivables and Payables
exec 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 MoreIntegrating Active Directory (AD) with a Linux Instance
Introduction 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 MoreOrcale EBS-Query to get active users along with their active responsibilities
LIST 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 MoreAutomating Infrastructure Monitoring with Datadog and Terraform
Introduction/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 MoreOracle EBS-Query to get Service Contract Details
Query 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 MoreOptimizing Kubernetes Resource Management with ResourceQuotas
Introduction/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 MoreUsing Debug Mode to Troubleshoot Issues in Oracle APEX
Introduction/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 MoreSimplify Cloud Automation: How to Use Terraform with OCI Stacks
Introduction 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 More