Where to find Libraries : fadolif.pll and FARSV.pll ?

You might be struggling to find some libraries particularly the ones mentioned.

You can find them on $AU_TOP/plsql . I am not sure why someone will create libraries there.

Oracle Forms : Developing a new form.

One small tip which might help while developing a new form.

1.Start development from TEMPLATE.fmb from $FND_TOP or $AU_TOP
2.Make sure the window is associated with the canvas and the code to close window is properly initialized or else you might see wierd calendar etc poping on the screens.

The place to check will be app_custom.close_window

Find the Current Tab in a canvas.

The following piece of code can be used to find the tab in a given canvas.

===

declare
--call the serial capture api.
l_tab_name varchar2(100);
begin

--get the current tab
l_tab_name := GET_CANVAS_PROPERTY('CANVAS_NAME',topmost_tab_page);

if l_tab_name = 'TAB1' then
fnd_message.debug('TAB1');
elsif l_tab_name = 'TAB2' then
fnd_message.debug('TAB2');
else
fnd_message.debug('INVALID TAB');
end if;

exception
when others then
fnd_message.debug('Error in process:'||sqlerrm);
end;

Organization selection in Oracle Applications.

Today I had to add Organization access to one of the forms. I found that is actually very easy to do.

Step 1: Add 'FND_ORG.CHOOSE_ORG; ' in the WHEN-NEW-FORM-INSTANCE trigger
Step 2: Define 4 parameters in the form; ORG_ID,ORG_CODE,ORG_NAME,CHART_OF_ACCOUNTS_ID

And you are all set, the list of Orgs appearing will be from the Organization Access defined for the current responsibility.