Posted by Jay on September 23, 2011
We can embeed the following commands in the PL/SQL code:
EXECUTE IMMEDIATE 'alter session set timed_statistics = true';
EXECUTE IMMEDIATE 'alter session set statistics_level=all';
EXECUTE IMMEDIATE 'alter session set MAX_DUMP_FILE_SIZE=UNLIMITED';
EXECUTE IMMEDIATE 'alter session set events "10046 trace name context forever, level 12"';
-------------------------------place pl/sql code here------------------------------------
select ‘cursor closed’ from dual ;
EXECUTE IMMEDIATE ‘alter session set events “10046 trace name context off”‘; —
Posted in Database, How to | Tagged: 'cursor closed', 10046 in pl/sql, 880038.1, EXECUTE IMMEDIATE 'alter session set events "10046, timed_statistics | Leave a Comment »
Posted by Jay on September 16, 2011
The following are the Steps to Setup the Timeout Feature For 220.127.116.11 Requisition Reminder Notifications
1.Enter Workflow Builder
2.Load the “Requisition” Workflow ($PO_TOP/patch/115/import/US/poxwfpoe.wft)
3.Select “Requisition” from the Workflow Builder Navigation window
5.Select the “Notify Approver” sub-process
6.Double click on the “PO_REQ_APPROVE” element
7.Select the “Nodes” tab
8.Select “Relative Time” option under “Type” under the “Timeout” section
9.Enter the desired time value (ie. Days, Hours, Minutes)
12.Double click on the “PO_REQ_REMINDER1″ element
13.Perform Steps 7 thru 11
14.Double click on the “PO_REQ_REMINDER2″ element
15.Perform Steps 7 thru 11
16.Save all changes made and exit the Workflow Builder
17.Bounce the Workflow Notification Mailer from OAM
Posted in Apps 11i/R12, How to | Tagged: $PO_TOP/patch/115/import/US/poxwfpoe.wft, 339198.1, poxwfpoe.wft, PO_REQ_APPROVE, PO_REQ_REMINDER1 | Leave a Comment »
Posted by Jay on August 19, 2011
Concurrent programs errors out with APP-FND-00500 in 11i/R12
APP-FND-00500: AFPPRN received a return code of failure from routine FDUPRN
Cannot read file <full path>/<filename>.out
Application Object Library encountered an error while reading the file
<filename>.out does not exist on the file system
If a report does not produce an output file but the concurrent program definition is set up so that it tries to print anything by default, then an FND-00500 error will occur.
This specific error can be ignored, but the more prudent solution is to modify the concurrent program definition in order that it does not try to print anything by default.
1. Log into Applications with the System Administrator responsibility.
2. Navigate to Concurrent/program/define and query up the concurrent program.
3. In the lower right corner where the output options are listed, clear the check box next to the word “print”. Leave the “save” option selected to avoid an APP-00088 when running the program because it was unable to delete the output file which was never created.
4. From the menu bar of this same form, select “Action/Save and Proceed”.
Ref # 156570.1 & 101064.1
Posted in Apps 11i/R12, Troubleshooting | Tagged: 156570.1, APP-00088, APP-FND-00500: AFPPRN received a return code of failure from routine FDUPRN, check box next to the word "print", Concurrent/program/define | Leave a Comment »
Posted by Jay on August 19, 2011
As of today, We can also apply Sun Java Runtime Environment 1.6.0_27 (a.k.a. JRE 6u27-b07). JRE 1.6.0_27 is certified with E-Business Suite Release 11i and 12.
Ref # Upgrading Sun JRE (Native Plug-in) with Oracle Applications 11i for Windows Clients (Metalink Note 290807.1)
Posted in Apps 11i/R12, Certification | Tagged: 1.6.0_27, 1.6.0_27 (a.k.a. JRE 6u27-b07), 11i/R12, 290807.1, Upgrading Sun JRE (Native Plug-in) | Leave a Comment »
Posted by Jay on August 16, 2011
On Aug 15, 2011, Oracle 4.1.2 was released and the installation files are in http://www.virtualbox.org/wiki/Downloads. The releases are availabe for x86 and x86_64 platforms, it is free to download, install and use.
Posted in Linux | Tagged: 4.1 to 4.1.2, Oracle RAC in Virtual Box, Virtual Box 4.1, x86/amd, x86_64/amd64 | Leave a Comment »
Posted by Jay on August 15, 2011
Please find below the list of the workload repository views with their description,
V$ACTIVE_SESSION_HISTORY – Displays the active session history (ASH) sampled every second.
V$METRIC – Displays metric information.
V$METRICNAME – Displays the metrics associated with each metric group.
V$METRIC_HISTORY – Displays historical metrics.
V$METRICGROUP – Displays all metrics groups.
DBA_HIST_ACTIVE_SESS_HISTORY – Displays the history contents of the active session history.
DBA_HIST_BASELINE – Displays baseline information.
DBA_HIST_DATABASE_INSTANCE – Displays database environment information.
DBA_HIST_SNAPSHOT – Displays snapshot information.
DBA_HIST_SQL_PLAN – Displays SQL execution plans.
DBA_HIST_WR_CONTROL – Displays AWR settings.
Posted in Database, Features | Tagged: DBA_HIST_BASELINE, DBA_HIST_SNAPSHOT, DBA_HIST_SQL_PLAN, DBA_HIST_WR_CONTROL, V$ACTIVE_SESSION_HISTORY | Leave a Comment »
Posted by Jay on August 14, 2011
On Aug 6, 2011, Oracle 5.7 was released and the installation DVD images are on edelivery.oracle.com/linux. Both the releases are availabe for x86 and x86_64 platforms, it is free to download, install and use for education/demo purposes.
More at : http://blogs.oracle.com/linux/entry/oracle_linux_5_update_7
Posted in Linux | Tagged: e-delivery, GPL, Linux, OEL 5.7, x86 & x86_64 | Leave a Comment »