If you are new to OAF Development and want to create a new Hello World Page, then this tutorial will help you. For that first you need to do a Setup to use JDeveloper to develop and run your OA Pages. You can refer here for that. After the Setup is completed, you are all set to […]
Fan Trap is a situation while running discoverer reports that return unexpected results due to a group of joined database tables. The most common manifestation of a fan trap occurs when a master table is joined to two or more detail tables independently. If you use a straightforward SQL statement to aggregate data points here, […]
If you want to do some OAF Development in JDeveloper for the first time, you will need to do the following things. 1] Download JDeveloper Patch Based on your instance release level, check out the version of JDeveloper to use using below link. https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=416708.1 You can identify the OA Framework version in your instance by activating […]
Although Discoverer provides many functions for calculation in reports, sometime we require to use custom PL/SQL functions to meet additional Discoverer end user requirements (for example, to provide a complicated calculation). For this we first need to create the functions in database through Toad or other PL/SQL editors. To access custom PL/SQL functions using Discoverer, […]
We can create list of values (LOV) for any parameter in discoverer reports through Item Classes. Here suppose in Discoverer Report, we have a parameter called Period Name. It has a small LOV icon in the right side. When clicked on the LOV icon, the below window with all the Period Names will appear where […]
Recent Comments