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.

Receiving Transaction Errors (rcv_transactions_interface)

We had some receiving errors and I learnt an interesting point that the detailed errors can be found in po_interface_errors.


select * from PO_INTERFACE_ERRORS where batch_id
in (select group_id from rcv_transactions_interface)

Oracle Shipping Exceptions.

There might be scenarios when Pick Release is called you are not sure where to look into. WSH_EXCEPTIONS does the job of tracking the exceptions.

select * from WSH_EXCEPTIONS

Some More Date functions.

What day is today in SQL?
select to_char(sysdate,'DAY') from dual;

Extending the above to other useful stuff:

First Day of the Month:
select to_char(trunc(sysdate,'MM'),'DAY' ) from dual;
Ex: WEDNESDAY

Last Day of the Month:
select to_char(last_day(sysdate),'DAY') from dual;
Ex: MONDAY

Last Date of the month :
select last_day(sysdate) from dual
Ex:31-Aug-2011

Add time to a given date:
select to_char(trunc(last_day(sysdate))+13/12,'DD-MON-RRRR HH24:MI:SS') from dual