Oracle HRMS
Query to fetch list of Custom Reports
Query to fetch list of Custom Reports We can use below query to fetch list of custom reports which are registered under custom Module In below query we are using application ID as 20003 which refers …
Remove Template
Remove Template, Data Definition, Bursting File
Remove Template, Data Definition, Bursting File Many times we will be getting requirement to remove bursting file from data definition. Unfortunately Oracle does not provide front end option to rem…
XML Publisher Bursting
XML Publisher Bursting
XML Publisher Bursting Below is the piece of code which we will be using in XML Bursting process Step 1: Use below code in After Trigger section in Report Builder function AfterReport return boolea…
Oracle Apps Technical
Get Responsibility Name from Concurrent Name
Get Responsibility Name from Concurrent Name Many times consultants getting confused that particular concurrent program attached to which responsibility. For that make use of below code and it …
XML Publisher Tags
XML Publisher Tags
XML Publisher Tags We can use below XML tags as per the requirement. 1. Greatest : <?xdofx:greatest ( expr [, expr]… )?> 2. Length : <?xdofx:length(char)?> 3. Le…
Oracle Apps Technical
Form Customization
D2K Form Customization Below are the steps we need to follow when are customize a form. 1)We Will download the TEMPLETE.fmb from AU_TOP\Resource Folder Application Utilities 2)Open with F…
Oracle Apps Technical
Warning Status in Concurrent Program if Report does not have no Data
Warning Status in Concurrent Program if Report does not have no Data We can display "Warning Status" when we run a concurrent program and the output does not have no data. Using ora…
Oracle Apps Technical
Concurrent Program from Backend
Concurrent Program from Backend Using below logic we can run concurrent program from backend. DECLARE l_responsibility_id NUMBER; l_application_id NUMBER; l_user_id NUMBE…
Social Plugin