Objective The intent of this document is to find out the request set name of given concurrent Program and the details of programs attached in the Request Set. Why we need to do Sometime [...]

Objective The intent of this document is to find out the error’s details when standard Program not able to process the records in interface table (RCV_TRANSACTIONS_INTERFACE). Why we need to do [...]

Objective:    To show OTBI analysis as a infolet in infolet section in a form of widget in springboard section in SaaS Home Screen.  User getting the latest info in a page Itself in a form of [...]

Objective: The intent of this content to show how to connect ATP Database from SQL Developer tool. To connect the ATP database we need wallet. Wallet file need to be downloaded from the ATP [...]

Query:   SELECT empl_leave_trxn_id,        employee_id,        leave_name,        leave_type_id,        To_char(start_datetime, ‘DD-MON-YYYY’) from_date, [...]

Objective: The intent of this document is to understand how notification works in Oracle Fusion Alert Composer. Scenario: Here we can see grade creation in fusion and see the notification [...]

Query: select name,argument_text from (SELECT prog.user_concurrent_program_name || DECODE (req.description, NULL, NULL, ‘:’ || req.description) name, req.request_id, [...]

Query: SELECT rs.user_request_set_name “Request Set”, rss.display_sequence seq, cp.user_concurrent_program_name “Concurrent Program”, e.executable_name, [...]

Introduction:- Oracle has a seeded API fnd_user_pkg which has a procedure to create new user login account. Below is the sample script to create user account, change the parameters as per your [...]

Introduction:- fnd_user_pkg.addresp is an Oracle Seeded API to add responsibilities from one user account to another user account.Below is the script to copy responsibilities of user [...]