Form Personalization on Purchasing Receipt Standard Form
Header : How to apply Form Personalization on Purchasing Receipt Standard Form Usage of Heading : Useful in the purchasing module in receipt of goods Description of post : Form…
Read MoreQuery to check if DMZ is enabled
Query to check if DMZ is enabled select p.user_profile_option_name “Profile Name”, decode(v.profile_option_value, 1, ‘Admin’, 2, ‘Normal’, 3, ‘External’, ‘Unknown’) Value, decode(v.level_id, 10001, ‘SITE’, 10002, (select ‘App:’||a.application_short_name from fnd_application a where…
Read MoreQuery To Get Archive Log Apply Rate Speed of a Standby Database
Query To Get Archive Log Apply Rate Speed of a Standby Database set linesize 180 col Values for a70 col Recovery_start for a21 select to_char(START_TIME,’dd.mm.yyyy hh24:mi:ss’) “Recovery_start”, to_char(item)||’ =…
Read MoreQuery to check user session statistics
Query to check user session statistics col pid format 9999 heading ‘PID’ col spid format a6 heading ‘SERVER|PID’ col sid format 9999 heading ‘SID’ col serial# format 99999 heading ‘SERIAL’…
Read Moreadpatch Fails After Restart With Error: “Unable to read file format id from file adainit.rf9”
Error: adpatch Fails After Restart With Error: “Unable to read file format id from file adainit.rf9” Solution: cd <$APPL_TOP>/admin/AXMD/restart/ Rename the file adainit.rf9 mv adainit.rf9 adainit.rf9.org
Read MoreGoldengate Extract Abends with “CACHESIZE TOO SMALL” upon Startup but Succeeds upon Immediate Restart
Issue : Goldengate Extract Abends with “CACHESIZE TOO SMALL” upon Startup but Succeeds upon Immediate Restart Observation : Multiple Goldengate Extract and Datapump processes processes abend with “CACHESIZE TOO…
Read MoreGoldenGate Extract Abends With Errors OGG-01417 OGG-01262
Issue : GoldenGate Extract Abends With Errors OGG-01417 OGG-01262 Observation : Using the extract parameter TRANLOGOPTIONS _DISABLESTREAMLINEDDBLOGREADER does not work the issue around. Reason : The issue is similar to…
Read MoreReplicat Is Abending With OGG-00660 Could not find unique key column within table definition When FUNCTION BASED INDEX and BATCHSQL Is Used
Issue : Replicat Is Abending With OGG-00660 Could not find unique key column within table definition When FUNCTION BASED INDEX and BATCHSQL Is Used Note : The issue was on…
Read MoreReplicat Abends With ERROR OGG-01029 Extract Reposition err – CDR Info sequence 0, rba 0
Issue : Replicat Abends With ERROR OGG-01029 Extract Reposition err – CDR Info sequence 0, rba 0 Observation : Replicat Abending with Error “OGG-01029 Extract reposition err – CDR Info sequence 0, rba 0.” This happens in Oracle GoldenGate –…
Read MoreInclude or Exclude column in Report download
1. Overview This document talks about how to User can include or exclude the columns while downloading the reports 2. Technologies and Tools Used The following technology has been used…
Read More