Virtual Private Database

Learn VPD through following links

10g
11g

How to extend OAF Controller

Steps to extend controller object to customize the same. 1. Open the controller class after decoding the same in Jdev.
2. Create a new class file by righclicking on the project.
3. Mention the name of the new extended class in Name. The new extended class package in the package. And the original controller class file package in the Extends.
4. After the custom logic is added in the newly extended controller, move the java file to the server, compile the file to generate the class file for the same.
 javac .java
5. Bounce the server.
6. Unlike VO and EO extensions, CO extension will not be called unless the same is mentioned in the OAF personalization. Enable the personalization.
7. Select "Complete View" and "Expand All" Option in personalization page.
8. Mention the extended controller file name in the personalization link of the component. Test now if the extended logic is reflected.

Kool Technology Syntax link

Please refer to this cool link which briefs though syntaz accross various languages.

XML Publisher - Developing reports printed on Pre-Printed Stationary

Click on this beautiful article by Mr Darshan Bhavsar, explaining how to develop XML Publisher Reports to be printed on Pre-Printed Stationary.

Oracle Apps Query - List of Users to whom a given responsibility is assigned

Select fu.user_name, fu.start_date user_start_date,fu.end_date user_end_date, fr.responsibility_name, fur.start_date resp_start_date,fur.end_date resp_end_date from FND_USER_RESP_GROUPS_ALL fur, fnd_user fu, fnd_responsibility_vl fr
where sysdate between fur.start_date and nvl(fur.end_date,sysdate)
and sysdate between fu.start_date and nvl(fu.end_date,sysdate)
and fu.user_id = fur.user_id
and fur.responsibility_id = fr.responsibility_id
and fur.responsibility_application_id = fr.application_id
and upper(fr.responsibility_name) = :resp_name

Oracle Apps Query - List the Employees assigned to a given organization

Select ppf.EMPLOYEE_NUMBER, ppt.USER_PERSON_TYPE, ppf.FIRST_NAME, ppf.LAST_NAME, ppf.sex, ppf.START_DATE, ppf.ORIGINAL_DATE_OF_HIRE , ppf.EMAIL_ADDRESS, GSB.NAME SET_OF_BOOK_NAME, GCC.CONCATENATED_SEGMENTS EXPENSE_REPORT_COSTING, pa.STYLE ADDRESS_STYLE, pa.ADDRESS_LINE1, pa.ADDRESS_TYPE, pa.COUNTRY, pa.POSTAL_CODE , pa.REGION_1, pa.REGION_2, pa.TOWN_OR_CITY, ppo.NAME ORGANIZATION_NAME, HL.LOCATION_CODE, HL.DESCRIPTION LOCATION_DESCRIPTION, PJ.NAME JOB_NAME, PPG.GROUP_NAME PEOPLE_GROUP_NAME , PPA.EMPLOYMENT_CATEGORY,PPA.assignment_category, ppf2.full_name DIRECT_MANAGER
from PER_ALL_PEOPLE_f ppf
, PER_ALL_ASSIGNMENTS_f ppa
, PER_ALL_ORGANIZATION_UNITS ppo
, PER_PERSON_TYPES ppt
, GL_SETS_OF_BOOKS GSB
, PER_ADDRESSES PA
, PER_JOBS PJ
, PAY_PEOPLE_GROUPS PPG
, HR_LOCATIONS HL
, PER_ALL_PEOPLE_f ppf2
, GL_CODE_COMBINATIONS_KFV GCC
where ppa.person_id = ppf.person_id
and ppf2.person_id(+) = ppa.supervisor_id
and sysdate between ppf2.EFFECTIVE_START_DATE(+) and nvl(ppf2.EFFECTIVE_END_DATE(+),sysdate)
AND GCC.CODE_COMBINATION_ID(+) = PPA.DEFAULT_CODE_COMB_ID
and ppt.PERSON_TYPE_ID = ppf.PERSON_TYPE_ID
and sysdate between ppf.EFFECTIVE_START_DATE and nvl(ppf.EFFECTIVE_END_DATE,sysdate)
and sysdate between ppa.EFFECTIVE_START_DATE and nvl(ppa.EFFECTIVE_END_DATE,sysdate)
and ppo.organization_id(+) = ppa.organization_id
and gsb.set_of_books_id(+) = ppa.set_of_books_id
and pa.person_id = ppf.person_id
AND PPG.PEOPLE_GROUP_ID = PPA.PEOPLE_GROUP_ID
AND PPA.LOCATION_ID = HL.LOCATION_ID(+)
AND PPA.JOB_ID = PJ.JOB_ID(+)
AND ppo.name in (:org_name);

Oracle Apps Query - Lists the Responsibilities to which a CP is attached

--Lists the responsibilities to which a CP is attached
SELECT RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_VL FR, FND_REQUEST_GROUPS FRG
WHERE FR.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID
AND FR.REQUEST_GROUP_ID IN (SELECT REQUEST_GROUP_ID FROM FND_REQUEST_GROUP_UNITS FRU, FND_CONCURRENT_PROGRAMS_VL FC
WHERE FRU.REQUEST_UNIT_ID =FC.CONCURRENT_PROGRAM_ID
AND FC.USER_CONCURRENT_PROGRAM_NAME = :ConProgram_Name)