How To Create An OCM Response File.
During patching, Opatch tool may ask for an OCM (Oracle configuration manager) response file. OCM can collect the configuration of your servers and send it to Oracle support. Oracle support…
Read MoreOpatch fails with Lock file error
While applying Oracle Patch, Opatch reports the below error : OUI-67064:OPatchSession cannot load inventory for the given Oracle Home /ora01/app/oracbr/product/11.2.0/dbhome_1. Possible causes are: …
Read MoreINCOIN The concurrent program for your request exited without calling standard Application Object Library exit routines or the process could have been terminated by the operating system
1.Check with the DBA about the field LFILE_SIZE in the table FND_CONCURRENT_REQUESTS is set to what value. 2.Check if log file is created properly with LFILE_SIZE > 0. If…
Read MoreQuery To Get Internal Manager (ICM) Log File Location
Query To Get Internal Manager (ICM) Log File Location ———————————————————————– SELECT ‘ICM_LOG_NAME=’ || fcp.logfile_name FROM fnd_concurrent_processes fcp, fnd_concurrent_queues fcq WHERE fcp.concurrent_queue_id = fcq.concurrent_queue_id AND fcp.queue_application_id = fcq.application_id AND …
Read MoreTNS-00583: Valid node checking: unable to parse configuration parameters
TNS-12560: TNS:protocol adapter error TNS-00583: Valid node checking: unable to parse configuration parameters I Received following errors when trying to startup my listener. I verified the listener.ora and sqlnet.ora files…
Read MoreTroubleshooting ASM Proxy instance startup
I had trouble starting ASM proxy instance on one of the nodes in my 2 node flex cluster having nodes host01 and host02. As a result I could not access…
Read MoreDynamic Row Adding and Inserting using JSON
Objective: To achieve, Dynamically adding or removing parent rows and include or exclude ‘n’ number child rows for the particular parent in the form. Apex Steps: 1. Create HTML table structure…
Read MoreMERGE,NESTED LOOPS,MERGE SORT
Merge Statement :- ØThe MERGE statement reduces table scans and can perform the operation in parallel if required. ØIt helps us to conditionally insert or update data depending on the condition.…
Read MoreHow to get the output xml file (.out) file of the specific concurrent request in application R12.
How to get the output xml file (.out) file of the specific concurrent request in application R12. Requirements: 1.Concurrent program Request ID. 2.Output file destination. Steps: 1.End user ask for…
Read MoreQuery to check assigned responsibility of FND User.
Query to check assigned responsibility of FND User. —————————————————————- select usr.user_id, usr.user_name, res.RESPONSIBILITY_ID, res.RESPONSIBILITY_NAME from apps.FND_USER usr, apps.FND_RESPONSIBILITY_TL res, apps.FND_USER_RESP_GROUPS grp where upper(res.RESPONSIBILITY_NAME) like upper(‘%’ || NVL(‘&EnterResponsibilityName’, ‘INV’)|| ‘%’) and…
Read More