How to pass multiple parameters in REST API web service
Introduction: The purpose of this document is to demonstrate how we pass multiple set of parameters in REST API through Postman. Cause of the issue: Whenever we test any REST…
Read MoreSQL to get the details of Cloud Users who logged within the last 30 days
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…
Read MoreSQL to get the details of Cloud Fusion Projects (PPM)
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…
Read MoreQuery to find out the Request Set of a Program and its details in EBS R12
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…
Read MoreQuery to find out the Receiving Transaction Interface error details in EBS R12
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…
Read MoreDisplay OTBI analysis as Infolets in Fusion (SaaS)
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…
Read MoreHow to connect ATP Database from SQL Developer
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…
Read MoreQuery to Extract Absence and Long Leave details in Oracle Fusion HCM
Query: SELECT empl_leave_trxn_id, employee_id, leave_name, leave_type_id, To_char(start_datetime, ‘DD-MON-YYYY’) from_date, To_char(end_datetime, ‘DD-MON-YYYY’) to_date – ,CASE WHEN absence_type =’Permission Leave’ THEN TO_CHAR(START_DATETIME, ’DD-MON-YYYY HH24:MI:SS’) ELSE from_date END from_date – ,CASE WHEN absence_type =’Permission Leave’ THEN TO_CHAR(END_DATETIME, ’DD-MON-YYYY HH24:MI:SS’) ELSE TO_date END to_date , absence_type –,CASE WHEN absence_type !=’Permission Leave’ THEN days ELSE NULL END days , CASE WHEN absence_type NOT LIKE ‘Permission%’ THEN days ELSE NULL END days – ,reason – ,CASE WHEN absence_type =’Permission Leave’ THEN (days *60) ELSE NULL END permission_minutes – ,CASE WHEN absence_type LIKE ’Permission%’ THEN (days *60) ELSE NULL END permission_minutes , CASE WHEN absence_type LIKE ‘Permission%’ THEN Round(( days * 60 ), 0) ELSE NULL END permission_minutes, reason, transaction_date, comments_and_description, CASE WHEN absence_status_cd = ‘ORA_WITHDRAWN’ THEN ‘WITHDRAWN’…
Read MoreGrade Creation Notification in Fusion HCM via Alert Composer
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…
Read MoreQuery to get submitted Request set Parameter details
Query: select name,argument_text from (SELECT prog.user_concurrent_program_name || DECODE (req.description, NULL, NULL, ‘:’ || req.description) name, req.request_id, req.parent_request_id, req.request_date, DECODE (req.request_type, ‘P’, actual_start_date, requested_start_date), req.actual_completion_date, FLOOR( ( (actual_completion_date – DECODE (req.request_type,…
Read More