Sunday, 11 January 2015

How to find error messages while doing Oracle workflow activities from backend.

›
Finding error messages while doing workflow activities from backend. Approach:             Find a workflow internal name         ...

Setting Timeout for a Notification in Oracle Workflow

›
Requirement: Timeout period should be 48 hours for a notification. Approach: 1. Go to particular Notification Label 2. Select th...
3 comments:

Displaying subtotal and grand total based on the group column in BI Publisher Template

›
For Example Display the sub total values based on Account code and show grand total end of the report. The report has only one gro...
9 comments:
Saturday, 10 January 2015

Implementing Search Functionality using LOV during query in Oracle Forms

›
Requirement : Enable 'Execure-Query' using an LOV field (non-database items) . Approach: When user clicks on CTRL+F11 we...
Friday, 9 January 2015

Parsing Comma Separated string in WHERE Clause of SQL Statement in Oracle Forms

›
In some cases, we get a comma separated string as output (say from another select statement or block) that we would need to pass to the IN...

How to change a LOV query Using Forms Personalization

›
We can change the LOV query using form personalization. Sample provided below (Payment form). Requirement:   We have to change the “...
5 comments:

Problems while creating the New Locations in Oracle R12.2

›
Problems while creating the New Locations in Oracle R12 ERROR DETAIL: Not able to Create the new Locations as well as Update the exis...
1 comment: