Data Guard New Features in Oracle 18c and 19c Data Guard Oracle Data Guard ensures high availability disaster recovery and data protection for enterprise data Data Guard maintains these standby…
Read MoreGeneral Multimodel partitioning with Hybrid partitioning allowing some partitions in the database and some as external partitions even in hdfs New ALTER SYSTEM statement clause FLUSH PASSWORDFILE_METADATA_CACHE Clear flashback logs…
Read More1. Overview This document will be helpful to validate the Interactive Grid column values without editing the IG region. 2. Technologies and Tools Used The following technology has been used to…
Read MoreWhile execution the query with arithmetic calculation exception will throw divisor is equal to zero error.In this situation we can use below logic. CREATE OR REPLACE FUNCTION divisorzero (p_divited NUMBER,…
Read Morecreate or replace PACKAGE BODY XX_Ar_Collector_Assign_Pkg AS PROCEDURE update_collectors(errbuf OUT VARCHAR2, retcode OUT NUMBER, p_oracle_user_id VARCHAR2) IS l_oracle_user_id NUMBER; l_update_rowcount NUMBER; v_customer_profile_rec_type hz_customer_profile_v2pub.customer_profile_rec_type; v_latest_ver_num NUMBER; x_return_status VARCHAR2 (10); x_msg_count NUMBER;…
Read MoreDoyensys is always up for new challenges and interesting projects that come our way. It is a belief that such opportunities give us a platform to demonstrate our capabilities and…
Read Moredeclare l_request_req_id NUMBER; begin BEGIN l_request_req_id := apps.fnd_request.submit_request (application => ‘PO’ –Application, , program => ‘REQIMPORT’ –Program, , argument1 => ” –Interface Source code, , argument2 => 1032 –Batch ID,…
Read MoreCREATE OR REPLACE PROCEDURE_iso_gst_tax_prc (p_trx_number VARCHAR2) AS CURSOR c IS SELECT prla.requisition_header_id, prla.requisition_line_id, prla.source_organization_id, prla.destination_organization_id, prla.item_id, jtd.trx_id, jtd.trx_line_id, DECODE (SUBSTR (DECODE (organization_code, ’05’, ‘111’, ’08’, ‘222’, organization_code ), -1, 1…
Read MorePipeline function to return Week Start Date and End Date of a particular month based on inputs parameter Overview: This document talks about how to return Week Start Date and End Date of a particular month…
Read More1. Overview This document will be helpful to find the query in the IR report when the filter condition is applied dynamically. (Source code should be in SQL format ). 2.…
Read More