foalabs

Query to check AD and TXK Delta Version Applied in Oracle Apps Query: sqlplus apps/apps select  ABBREVIATION, NAME, codelevel FROM apps.AD_TRACKABLE_ENTITIES where abbreviation in ('txk','ad'); If you like please follow and comment

PROCESS and DISCARD folders are not accessible by the Oracle Workflow mailer Even after creating the PROCESS and DISCARD folders under the dedicated email account, we were getting the error as "The FOLDER DOES NOT EXIST for THE NOMINATED MAIL ACCOUNT" Error: Validation failed for the following parameters -> {DISCARD=The folder does not exist for the nominated mail account., PROCESS=The folder does not exist for the nominated mail account., INBOX=The folder does not exist for the nominated mail account.}.  Parameters were -> {RESET_NLS=N, FROM=Workflow , INBOUND_MAX_RET_EMAIL_SIZE=100, INBOX at oracle.apps.fnd.cp.gsc.SvcComponentContainer.handleComponentEvent(SvcComponentContainer.java:2221) at oracle.apps.fnd.cp.gsc.SvcComponentContainer.onBusinessEvent(SvcComponentContainer.java:301) at oracle.apps.fnd.wf.bes.DispatchThread.run(DispatchThread.java:57) Solution: 1) Login into MAIL SERVER IMAP using the telnet telnet abc.mailer.com 143 Connected to abc.mailer.com E...

How to Access IMAP server from the command line using OpenSSL  If you are running Linux, you should have openssl installed. We can connect directly from the openssl to imap server from the command line.    Various Methods That can be done here are     1) Connect    Run the following command to begin an SSL session with the IMAP server openssl s_client -crlf -connect outlook.office365.com:993 You’ll get an output such as the following that can be suppressed by adding the -quiet option to the command above 2) Login Run the following command tag login user@outlook.com password tag before login command is some character sequence required to be used before each subsequent IMAP command. 3) List Mailboxes Run the following command tag LIST "" "*" Output: * LIST (\HasNoChildren) "/" Archive * LIST (\HasNoChildren) "/" "Archived Processed" * LIST (\HasChildren) "/" Calendar * LIST (\HasNoChildren) "/" Calendar/Birthdays * LIS...

How to reduce LVM partition size in RHEL and OEL If observe a particular file system is not used fully and a lot of free space is available then we can make some free space in the volume group by reducing the LVM using lvreduce command. Example :  To reduce /oracle mount by 2GB which is on LVM partition & formated as ext4 [root@funebs122 ~]# df -h /oracle/  Filesystem            Size  Used Avail Use% Mounted on  /dev/mapper/vg_funebs122-lvol1                        12G   9.2G  1.9G  84%  /oracle     Steps :         1. Umount the file system [root@funebs122 ~]# umount -v /oracle/ 2. Check the file system for Errors using e2fsck command [root@funebs122 ~]# e2fsck -f /dev/mapper/vg_funebs122-lvol1  e2fsck 1.41.12 (17-May-2010)  Pass 1: Checking inodes, blocks, and sizes  Pass 2: Checking dire...

ORA-39168: Object path STATISTICS was not found during datapump impdp Error: ORA-39168: Object path STATISTICS was not found REASON: Expdp directory=DIR_NAME dumpfile=DUMPFILE_NAME.dmp logfile=LOGFILE_NAME.log schemas=SCHEMA_NAME exclude=statistics export Done successfully without any errors When trying the import the same into my target database Impdp directory=DIR_NAME dumpfile=DUMPFILE_NAME.dmp logfile=LOGFILE_NAME.log  exclude=statistics Import: Release 11.2.0.3.0 - Production on Fri Jan 20 16:15:14 2022 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. Username: / as sysdba Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA-39002: invalid operation ORA-39168: Object path STATISTICS was not found. The error is because I already used the EXCLUDE=STATISTICS parameter during expdp job and again tried to exclude statistics again ...

How to configure EM console after Oracle Application Server 10g (10.1.3) Application Server Steps to enable ascontrol. This can also be used to enable and disable the custom deployed applications. 1: Check the opmn status opmnctl status -app Following example, “ascontrol” row showing it is “stopped” and routable is set to “false”: application type: OC4J ——+——————-+———+———+—————-+———-+—–                                                                             — pid   | name              | state   | rtid    | classification | routable | pare                                                      ...

SQL script to Cancel Pending Request from a particular user in Oracle Apps Script: UPDATE fnd_concurrent_requests SET phase_code = 'C', status_code = 'X' WHERE request_id in (select cwr.request_id FROM apps.fnd_concurrent_worker_requests cwr, apps.fnd_concurrent_queues_tl cq, apps.fnd_user fu WHERE (cwr.phase_code = 'P')   AND cwr.hold_flag != 'Y'    --AND cwr.requested_start_date <= SYSDATE AND cwr.concurrent_queue_id = cq.concurrent_queue_id   AND cwr.queue_application_id = cq.application_id  and cq.LANGUAGE='US' AND cwr.requested_by = fu.user_id and fu.user_name='&username' and cwr.user_concurrent_program_name='&user_concurrent_program_name') If you like please follow and comment

How to Remove Windows Activation Logo Steps: Launch Registry Editor: Press Win + R (Win is the Windows logo key), type Regedit, and press Enter. Go to the registry key "HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows NT \ CurrentVersion \ SoftwareProtectionPlatform \ Activation" Change Manual parameter on the right side of the editor window. Double click on it and set the value to 1. Do the same for the NotificationDisabled parameter and set the value to 1. After rebooting, the logo/watermark will disappear. After a while or windows update, the system may remove the changes .  To prevent this from happening, right-click on the Activation section (folder) on the left and select “Permissions”. After selecting the items “System” and “TrustedInstaller,” mark for them “Deny” in the list of permissions and click the “Apply” button. Click the “Advanced” button, and on the next screen, click “Disable inheritance”, confirm, and then delete the TrustedInstaller and System items for...

Performance - How To Generate Explain Plan in Oracle Database Various methods of generating explain plan .   1.Explain plan for a sql query: Query:  SELECT COUNT(*) FROM employee; --- LOAD THE EXPLAIN PLAN TO PLAN_TABLE SQL> explain plan for select count(*) from employee; Explained. --- DISPLAY THE EXPLAIN PLAN SQL> select * from table(dbms_xplan.display); 2. Explain plan for a sql_id from cursor   set lines 2000 set pagesize 2000 SELECT * FROM table(DBMS_XPLAN.DISPLAY_CURSOR('&sql_id'));   3. Explain plan of a sql_id from AWR: SELECT * FROM table(DBMS_XPLAN.DISPLAY_AWR('&sql_id')); Above will display the explain plan for all the plan_hash_value in AWR. If you wish to see the plan for a particular plan_hash_value. SELECT * FROM table(DBMS_XPLAN.DISPLAY_AWR('&sql_id',&plan_hash_value)); 4. Explain plan of sql baseline: SELECT * FROM   TABLE(DBMS_XPLAN.display_sql_plan_baseline(plan_name=>'SQL_PLAN_hjkadgkjaduad3232haass')); If you...

How Can we Run SQL Tuning Advisor For A SQL ID In Oracle Database We can SQL tuning advisor against a SQL statement or SQL ID, it provides tuning recommendations that can be done that query to improve performance.  It might give various recommendations like gather stats/Index Rebuild and accepting a SQL profile My sql id is – 4g5ah8zr6thnb . You can get sqlid from various methods from AWR report or sql details queries. Method when the sql is running and available in Cursor. 1. Create Tuning Task DECLARE l_sql_tune_task_id VARCHAR2(100); BEGIN l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task ( sql_id => '4g5ah8zr6thnb', scope => DBMS_SQLTUNE.scope_comprehensive, time_limit => 500, task_name => '4g5ah8zr6thnb_tuning_task_cur', description => 'Tuning task_cur for statement 4g5ah8zr6thnb'); DBMS_OUTPUT.put_line('l_sql_tune_task_id: ' || l_sql_tune_task_id); END; / 2. Execute Tuning task: EXEC DBMS_SQLTUNE.execute_tuning_task(task_name =...

Creating a Bootable Windows 10/11 USB on Linux OS If you like please follow and comment

Query to find the Parent and Child Concurrent Request with Run Details and Timings Query: SELECT fcr.request_id "Child Request ID", PARENT_REQUEST_ID "Parent Request ID", fcptl.user_concurrent_program_name"Parent Program Name", fcr.phase_code, fcr.status_code, to_char(fcr.actual_start_date,'DD-MON-YYYY HH24:MI:SS') "Start Time", round((fcr.actual_completion_date - fcr.actual_start_date)*1440,2) "Elapsed Mins" FROM (SELECT fcr1.request_id FROM apps.fnd_concurrent_requests fcr1 WHERE 1=1 START WITH fcr1.request_id = &Parent_request_id CONNECT BY PRIOR fcr1.request_id = fcr1.parent_request_id) x, apps.fnd_concurrent_requests fcr, apps.fnd_concurrent_programs fcp, apps.fnd_concurrent_programs_tl fcptl WHERE fcr.request_id = x.request_id AND fcr.concurrent_program_id = fcp.concurrent_program_id AND fcr.program_application_id = fcp.application_id AND fcp.application_id = fcptl.application_id AND fcp.concurrent_program_id = fcptl.c...