SELECT responsibility_name responsibility,request_group_name,frg.description FROM fnd_request_groups frg, fnd_responsibility_vl frv WHERE ...
Tuesday, July 15, 2014
Responsibility Assigned to Users
SELECT DISTINCT u.user_id ,SUBSTR (u.user_name, 1, 30) user_name ...
List of Responsibilities in an Instance
SELECT (SELECT application_short_name
FROM fnd_application fa
WHERE fa.application_id = frt.application_id) application,
frt.responsibility_id, frt.responsibility_name
FROM...
Monday, July 14, 2014
How to determine Oracle Database And OS version
You can use following two queries to find out the Apps/Database/OS version
select * from v$version;
select * from product_component_version;
Thanks
Mande...
Thursday, July 10, 2014
Session Timeout in Oracle Apps
This post is about how to increase your session time out for oracle application. Sometime its very annoying that session time out is set at very low value. You can increase it for your login by setting...
Interface Trip Stop Functionality
There are typically four
interface program get triggered at the time of ship confirm. They are
Interface Trip stop
Packing Slip Report
Bill of Lading
Invoice
Interface Trip Stop is one...
Wednesday, July 9, 2014
Shipping Parameters Quick Reference
Lets see Oracle Order Management Shipping parameter setups. Please note shipping parameters are inventory org specific where as Global parameters are not.
1) General Tab
#Weight...
Subscribe to:
Posts (Atom)