Introduction:  The purpose of this document is to provide detailed SQL query overview of the cloud users who logged within the last 30 days. Cause of the issue: We didn’t get easily to get to [...]

Objectives :  The purpose of this document is to provide comprehensive information on project headers and its line-level details. This document aims to offer a detailed SQL query overview of [...]

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, [...]