Cause The issued was found to have been caused by the FND_NODES table having incorrect node entries (old node from the source instance) and that no Service Manager was found…
Read MoreTo check SQL Profile : select NAME,SIGNATURE ,STATUS,FORCE_MATCHING from dba_sql_profiles; ENABLE/DISABLE/DROP EXEC DBMS_SQLTUNE.ALTER_SQL_PROFILE(‘coe_5273fz2cqkk80_3455548535′,’STATUS’,’DISABLED’); exec dbms_sqltune.drop_sql_profile(‘coe_5273fz2cqkk80_3455548535’); SQL Profiles for a sql_id set lines 1000 pages 9999 col name for a30 col…
Read Moreone script to Identify all performace issue related to sql query Set echo off set trimspool on set define on column filename new_val filename select to_char(sysdate, ‘yyyymmdd-hh-mi-ss’ ) filename from…
Read MoreUndo Related Queries To check retention guarantee for undo tablespace select tablespace_name,status,contents,logging,retention from dba_tablespaces where tablespace_name like ‘%UNDO%’; To show ACTIVE/EXPIRED/UNEXPIRED Extents of Undo Tablespace select tablespace_name, status, count(extent_id) “Extent…
Read MoreLong running Concurrent Requests:- 1.How to Determine Which Manager Ran a Specific Concurrent Request? col USER_CONCURRENT_QUEUE_NAME for a100 select b.USER_CONCURRENT_QUEUE_NAME from fnd_concurrent_processes a, fnd_concurrent_queues_vl b, fnd_concurrent_requests c where a.CONCURRENT_QUEUE_ID =…
Read MoreHow to add legal entity to bank account Solution: 1. Using below navigation, please check if Workflow background engine is up and running: System Administrator -> Oracle application Manager ->…
Read MoreHow to change read write the Permissions on Concurrent Log and Output Files Solution Add umask 002 in .bash_profile(Linux). And then bounce the services.
Read MoreWhen an Expense Report has a status of ‘Pending System Administrator Action’ a notification has usually been sent to the System Administrator for action to be taken. The reason for…
Read MoreWhen there is a genuine issue with a particular invoice in Payment Process Request(PPR), all other invoices are getting rejected with reason ‘Document payable was failed because of rejection level…
Read More1.Overview The definition of SQL/XML is driven in part by the SQLX Group. Oracle supports several SQL/XML features which are subject to change as the standard evolves. SQL/XML Functions XMLELEMENT…
Read More