Query: select name,argument_text from (SELECT prog.user_concurrent_program_name || DECODE (req.description, NULL, NULL, ‘:’ || req.description) name, req.request_id, req.parent_request_id, req.request_date, DECODE (req.request_type, ‘P’, actual_start_date, requested_start_date), req.actual_completion_date, FLOOR( ( (actual_completion_date – DECODE (req.request_type,…
Read MoreQuery: SELECT rs.user_request_set_name “Request Set”, rss.display_sequence seq, cp.user_concurrent_program_name “Concurrent Program”, e.executable_name, e.execution_file_name, lv.meaning file_type, fat.application_name “Application Name” FROM fnd_request_sets_vl rs, fnd_req_set_stages_form_v rss, fnd_request_set_programs rsp, fnd_concurrent_programs_vl cp, fnd_executables e, fnd_lookup_values lv,…
Read MoreWhen we use SSH keys for authenticating third party servers, the Public key will be configured in third party server whereas Private key will be configured in Oracle BI Publisher…
Read MoreACFS concept was introduced in 11.2.0.1 it only manages the non-database files. Oracle ACFS (Automatic Storage Management Cluster File System) is the preferred file manager for non-database files. It is…
Read MoreIt’s a secure access credential used in the Secure Shell (SSH) protocol. This is one of the authentication methods that Oracle uses to communicate with third party server such as sFTP. Steps…
Read MorePlease use the below. CREATE TABLE DBA.STATS$TOTALUSERS ( MEASURED_DATE DATE, TOTAL_USERS NUMBER, ACTIVE_USERS NUMBER ) TABLESPACE USERS PCTUSED 0 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K…
Read MorePlease use the below query. set line size 750 pages 9999 col box for a30 col username for a30 col spid for a30 col program for a30 col os_user for…
Read Morewhen attempting to execute “adop phase=fs_clone”, the following error occurs: # Calling ApplyAppsTier… # Creating the FMW Home from ApplyAppsTier Creating FMW Home. Running /u01/app/fs1/EBSapps/comn/clone/FMW/pasteBinary.sh -javaHome /u01/app/fs1/EBSapps/comn/clone/FMW/t2pjdk -al /u01/app/fs1/EBSapps/comn/clone/FMW/FMW_Home.jar -tl…
Read MoreThere are so many commands we use while working with vi editors. Here I have shared some commands. i – for insert mode. I – inserts text at…
Read MoreThe following query will help you to find the history of concurrent programs run in your EBS environment. You should connect to ‘apps’ user for executing this query and query…
Read More