FRM-41830 list of values contains no entries
ERROR: FRM-41830 FRM-41830 list of values contains no entries SOLUTION: I have changed the profile option for particular user at the site level so the changes…
Read MoreGather Stats ORA-0000: normal, successful completion
ERROR: Gather Stats ORA-0000: normal, successful completion SOLUTION: Check to see what records will be backed up on the wf_queue_temp_jms_table backup table: set linesize 155; set pagesize 200; set verify…
Read MoreEnable/Disable IR Download button based on User Role
By default IR region allows to either enable Download button to all users or disable Download button to all users. Suppose if there is a requirement to enable/disable download button…
Read MoreCascading Select list in IR Oracle APEX
By default the Interactive Reporting Region allows end users to customize reports. This interactive reporting region allows users to customize the layout of the data by choosing the columns they…
Read MoreWays To find whether the module is installed or not in Oracle Applications
We have 3 ways to find out if a module is installed in oracle apps 1 We can run the following script cd $AD_TOP/sql/adutconf.sql In this script, there is a…
Read More12C : Unified Audit Trial was not captured during successful Login and Failures
From oracle 12.1, unified audit trail has been introduced. To enable this audit_trail parameter should be set to none. However we observed that even though ORA_LOGON_FAILURES was available in AUDIT_UNIFIED_ENABLED_POLICIES…
Read More12C : SQL Tuning Advisor is not Running even though its enabled
Recently I faced a new issue in 12C. In automated maintenance task, sql tuning advisor was already enabled. but its still showing not running. Even I have validated dba_autotask_operation, it…
Read More12.2 E-Business Suite startCD 50 Install Fails with Fatal Error: TXK Install Service oracle.apps.fnd.txk.config.ProcessStateException: OUI process failed Cannot install Web Tier Utilities
APPLIES TO: Oracle Applications DBA - Version 12.2.5 to 12.2.5 [Release 12.2] Oracle Applications Manager - Version 12.2.5 and later Information in this document applies to any platform. SYMPTOMS: E-Business…
Read MoreSQL query to get oracle form personalization details
Overview: Below query give the form personalization details. Query: SELECT DISTINCT a.ID, a.SEQUENCE, a.function_name, a.form_name, a.enabled, c.user_form_name, d.application_name, a.description, a.trigger_event, a.trigger_object, a.condition, ca.* FROM fnd_form_custom_rules a, fnd_form b, fnd_form_tl…
Read MoreR12 E-Business Suite Output Post Processor (OPP) Fails To Pick Up Concurrent Requests With Error ‘Unable to find an Output Post Processor service to post-process request nnnnn’
E-Business Suite R12 Concurrent Processing, Output Post Processing related issues Requests fail during Post Processing with the following errors: ‘Unable to find an Output Post Processor service to post-process request…
Read More