How can I find the LOV query behind an Oracle Forms List of Values (LOV)?
Example:
Step1:
Go to Help --> About Oracle Application --> Find the Form Name
Step2:
Open the Leaving reason LOV as shown from the above screenshot.
Step3:
Run the Below Query:
SELECT TO_CHAR(sq.sql_fulltext) AS perwstem_lov_query
FROM v$session ses,
v$sqlarea sq
WHERE ses.module LIKE '%PERWSTEM%' -- Form Name
--AND ses.client_identifier = '&your_ebs_username'
AND sq.sql_id = ses.prev_sql_id;
Result:
select meaning ,lookup_code from hr_leg_lookups where lookup_type = 'LEAV_REAS' and enabled_flag = 'Y' and :1 between nvl(start_date_active, :2) and nvl(end_date_active, :3) order by meaning
Password Protection in Oracle RTF Report for PDF Output.
Step: 1
Add Password in the Select statement to pass the dynamic password to the document based on your requirement. Here i am giving example with Employee date of birth in DD-MON-YYYY format as dynamic password.
Query :
SELECT employee_number,
full_name employee_name,
to_char(date_of_birth, 'DD-MON-YYYY') pwd_date_of_bith
FROM per_all_people_f
WHERE sysdate BETWEEN effective_start_date AND
nvl(effective_end_date, sysdate);
Step 2:
Develop report with Data model or RDF and generate the XML file.
Ste 3:
With help of XML file, Develop a report in the as per the required format in RTF template.
Step 4:
To enable the password, Open the RTF file
Navigation: File --> Info --> Properties --> Advanced Properties -- Go to Custom and Add parameters and values
Password Protection:
xdo-pdf-security - true
xdo-pdf-open-password - {/XX_EMP_DETAIL/LIST_G_EMPLOYEE_NUMBER/G_EMPLOYEE_NUMBER/DATE_OF_BIRTH}
DATE_OF_BIRTH is the field we are passing as dynamic password to the report.
