Below are tiny SQL's which can be used to set the Apps context.
BEGIN
dbms_application_info.set_client_info('103');
END;
BEGIN
FND_GLOBAL.Apps_Initialize (user_id => 5992 ,resp_id => 51498 ,resp_appl_id => 660 );
END;
In SQL developer sometimes the views don't fetch any data. Set the NLS Lang using the following SQL.
alter session set nls_language = 'AMERICAN';
Subscribe to:
Post Comments (Atom)
Integrations Lead - Lessons learnt
Integrations have been my passion for a while but like anything tech there is no credit given when things go right but always heaps of pres...
-
For most outbound interfaces bursting to content server and then picking the file from UCM is the best approach for large extracts. Default...
-
While developing Cloud integrations I could not find a single place for all details like InterfaceID or jobdefinitionname or job name etc. ...
-
Formatting dates is one of common operations needed in OIC. To format the date OIC has provided the following function OOTB. xp20:format...
No comments:
Post a Comment