-- Check the attached responsiblity
Select b.user_name, c.responsibility_name, a.START_DATE, a.END_DATE
from fnd_user_resp_groups_direct a, fnd_user b, fnd_responsibility_tl c
where a.user_id = b.user_id
and a.responsibility_id = c.responsibility_id
and b.user_name='USERNAME'
add sysadmin responsibility in backend
BEGIN
fnd_user_pkg.addresp('user_name',
'SYSADMIN',
'SYSTEM_ADMINISTRATOR',
'STANDARD',
'Add Responsibility to USER using pl/sql',
SYSDATE,
SYSDATE + 100);
COMMIT;
DBMS_OUTPUT.put_line('Responsibility Added Successfully');
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.put_line(' Responsibility is not added due to ' || SQLCODE ||
SUBSTR(SQLERRM, 1, 100));
ROLLBACK;
END;
A Language is not worth knowing unless it teaches you to think differently.
Subscribe to:
Post Comments (Atom)
Price List Query for Item
SELECT qph.list_header_id, qph.name, qph.description, qphh.start_date_active, qphh.currency_code, q...
-
1. To download Ldt file for a Concurent Program FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_nam...
-
Here the article will describe about how to register WebADI to Responsibility menu Go to System Administrator --> Security --> Respo...
-
using the below query can check the invoice status. SELECT DECODE(AP_INVOICES_UTILITY_PKG.GET_APPROVAL_STATUS(AIA.INVOICE_...
No comments:
Post a Comment