Deleting a Schedules Request

How to delete the saved schedules, which were saved from the ‘Schedules’ tab of the ‘Submit Request’ window.
There is no standard functionality to delete any saved schedule.

The saved schedules are being stored in the table fnd_conc_release_classes_vl.
Select release_class_id, application_id, release_class_name schedule_name,
description, class_type schedule_type
from fnd_conc_release_classes_vl
where owner_req_id is null
and enabled_flag != ‘N’
and nvl(start_date_active,sysdate) <= sysdate
and nvl(end_date_active, sysdate) >= sysdate
order by release_class_name

If you want to delete any saved schedule from the LOV, then you can perform any of the following:
Delete the row from the table FND_CONC_RELEASE_CLASSES_VL for the saved schedule.
It will be better to update the ENABLED_FLAG = ‘N’ for the saved schedule instead of deleting the row from the table FND_CONC_RELEASE_CLASSES_VL.

thanks – shivmohan

XML / BI Publisher – Scalability Option

****Warning!!! Due to high volume of data, got out of memory exception…***
****Please retry with scalable option or modify the Data template to run in scalable mode…***

This error happens intermittently.

To implement the solution, please execute the following steps::
1. Sysadmin: Concurrent: Program: Define,

2. Query for concurrent program with the short name =XXABC

In the ‘Options’ field change the value to -Xmx1024M. (or higher).  You can change the value to v             -Xmx2048M,  and possibly even -Xmx4096M.  Ultimately, you may exceed the heap size. Restart the concurrent manager so that changes take effect

Note: Enabling the scalability feature and changing the heap size to -Xmx1024M’ is not recommended to be on the global level ,let it only on concurrent program level

Similar Errors or Generic Error can be rectify by below steps as well

1. Log into the XML Publisher Administrator responsibility.
2. Navigate to Home – Administration – Configuration.
3. Under the General Properties select Temporary directory.
4. Select a temporary file location on your concurrent processing node. This should be at least 5Gb or 20 times larger than the largest XML data file you generate.


1. Log into the XML Publisher Administrator responsibility.
2. Navigate to Home – Administration – Configuration.
3. Under the FO Processing Properties set:
a. Use XML Publisher’s XSLT processor to True.
b. Enable scalable feature of XSLT processor to False.
c. Enable XSLT runtime optimization to True.

How to Remove the Worklist from Appearing on the HomePage

Follow same steps to get Worklist on HomePAge 🙂

1. Click on Personalize Page link (if Personalize Page link is not appearing ,set profile option Personalize Self-service Defn = Yes at site level)

2. Click on Personalize “Notifications Worklist Function” > Stack Layout: Notifications Worklist Function> Click on Personalize link (pencil icon) > Set Rendered = False at Site level .

3. Click on Personalize “Worklist” > Table: Notification List > Click on Personalize link (pencil icon) > Set Rendered = False at Site level .

4. Log out and login and the Worklist now does not appear on Homepage.

How to generate a delimiter in spool output (Excel .csv files)

In order to generate a delimited file output, you need to concatenate columns using the desired delimiter i.e. comma:

select empno|| ‘,’||ename||’&’||mgr from X;

Other option is using:
SQL> set colsep ‘,’
SQL> spool c:\testexcel.csv
SQL> select * from emp;

Change some of the default SQL*Plus parameters, that will be garbage for Excel:

If some columns are empty, be aware to include the delimiter, too:

New Functional Expert for your Help

Like to inform all followers of blog , that we are adding a great functional expert in our panel. He will be answering all your functional queries ( i.e. in Functional and Supply Chain Modules ) through Email and also in case your need any more help through other communication channels like IM, Gtalk, Skype , Audio or Video Meetings etc.

Moreover we are looking Expert in other areas of Oracle ERP. In case you know any epxert who can help , please refer.

Will post more once we have Our new Expert ready to publish his artilces and publish his contacts.

thanks – Shiv

Oracle – OAF – Oracle Application Framework – OA Framework

The Oracle Applications Framework (OA Framework) is a development and deployment platform used for Oracle Applications (Apps) HTML-based screens.  In other words, OA Framework is the standard approach for building and launching Apps web pages.  This includes the “i” modules, such as iReceivables, iProcurement, etc.  The framework contains the design rules and components that include the look-and-feel for web pages, so any custom-built pages will have a presentation identical to Oracle-developed pages.

JDeveloper is the tool for accessing and employing OA Framework development rules.  As the name implies, JDeveloper is a Java-oriented tool, but that includes “all-things-Java”, such as XML, JSP, SOA, and many other items, not all of which will apply to Apps development.

So, using JDeveloper as the development tool and OA Framework as the design architecture, we can modify existing Apps web pages, as well as build new ones.

The framework seeds JDeveloper with pre-defined objects and settings.  Custom objects can inherit settings from seeded objects, effectively becoming clones of those objects.  Cloned objects can be extended, essentially tweaked to include customizations. Developers familiar with Oracle Forms can begin to draw on the TEMPLATE.fmb for comparisons.  See Comparing to What I Know (Oracle Forms) for a further discussion.


Developers: face it, Apps will change and you can react to that fact or not.  Oracle will continue to reengineer Apps, moving more Forms-based screens to OA Framework web pages, evolving the Apps to a more Java-centric technology.  (For an example, see the changes in Customers page between R12 and 11.5.10.)  JDeveloper and OA Framework will be the tools for building and deploying web pages our users work with. For all the PL/SQL and Oracle Forms developers out there, start planning your evolution.  Sure PL/SQL and Forms will be around for some time, but you need to add more skills to your stack if you want to stay current (employable).


Start working with the tool (JDeveloper) and the framework.  See Metalink Note:416708.1, “How to find the correct version of JDeveloper to use with eBusiness Suite 11i or Release 12”.  If you download JDeveloper with OA Framework for Release 12 beware, the tutorials match the 11i release.  That is, the tutorials are not up to date. It’s possible, after some experimentation, to align the tasks in the 11i tutorial to the R12 release.

The major question for a PL/SQL developer with limited or zero Java experience is, “So do I really need to know Java?”  Answer: Yes, at least from a conceptual level. Certainly with JDeveloper and OA Framework you can create customizations of easy through mid-range complexity (called Extensions in OA Framework).  The intent of OA Framework is to give you a base from which to build.  You will be able to satisfy some portion of user requests by extending seeded objects and changing properties.  But any seasoned developer will tell you that no code-development tool can generate everything you’ll need.

  • Plan your Java education: books, on-line tutorials, instructor-lead classes.  You know the method that will work best for you.
  • Google OA Framework Blogs and OA Framework Tutorials and discoverer what others are saying
  • Check this site for more OA Framework information[1.jpg]

Oracle Apps Tuning – How to Run Statement Level/Java trace or a SQL Trace in Self Service Application

Statement Level/ Java Trace:
1 – Remove any messages from the FND_LOG_MESSAGES table for the user running the process to be traced.
To get the user id of your self service user:

select user_id
from fnd_user
where user_name = ‘????’
Delete all rows in the tables for this user:
delete from FND_LOG_MESSAGES
where user_id =� xxx���� <insert the value received in the first query>

2- To set fnd logging you need to set the following FND system profiles:
Log onto the Applications forms with System Administrator responsibility
Navigate to Profile > System
At User Level for the employee you are tracing set these values:
In the Profile field, query and then set the value as noted

FND: Debug Log Enabled – Yes           OAF 11.5.10 CU1 it is called FND: Log Enabled
FND: Debug Log Level – Statement
FND: Diagnostics = Y – Enables the Diagnostics Button on the SS Framework
FND: Debug Log Filename = This is optional. Use if want to direct to specific directory/name

Reference a directory where you have write privledges Directory/filename�
Example: /usr/tmp/MyDump.txt�
At the Site level, set these values
In the Profile field, query and then set the value as noted
FND: Debug Log Mode – Asynchronous with Cross-Tier Sequencing (this may or may not be there)
FND: Debug Log Module – xxx.plsql.%    xxx is the application ex. per.plsql.% (NOTE HXC, OTL uses PER)�
When you log into self service, a message will be displayed that logging is enabled.
Perform the action which caused the problem.�
To extract the log messages from the database you again need the user id of your self service user and then run this query:

select *
from fnd_log_messages
where user_id = ????
order by log_sequence

*** Do not forget to turn off the logging when done.
*** Reset all the profile values



SQL trace:
Responsibility = SysAdmin
Navigation: Security > Profile
User: Enter User name
Query the Profile: FND: Diagnostics
Set the FND:Diagnostics profile to Yes at User level.
Login into Self Service under the same user used to set the profile value.
Click the diagnostic icon at the top of the page.
It shows two options:
Show Log
Set Trace Level
Select ‘Set Trace Level’
Click Go.It shows a page with a set of options.�Set Trace Level – This is like a forms trace – with several options:
Disable Trace – used to end the trace
Trace (Regular) – just like a forms trace
Trace with Binds – record the bind variables in the trace
Trace with waits – Good for performance issues.
Trace with binds and waits – combines both of the above
Choose�� Trace option�
Click Save.Execute the process in Self Service. This will put the sql trace in the usual log directory.
Turn off Trace.
Select the Diagnostic icon.
Click on option: Set Trace Level
Click Go
Select : Disable Trace
To determine where the raw trace file is located.
From SQLPlus:
SELECT value
FROM v$parameter
WHERE name = ‘user_dump_dest’;

run TKPROF procedure on the raw trace file
For example:
hrab51_ora_18190.trc is the name of the raw trace file
trace1.txt is the name of the TKPROF file
tkprof hrab51_ora_18190.trc ~/trace1.tkt explain=apps/apps sort=exeela,prsela,fchela’