Use Case: A user needs to retrieve the complete activity log of an integration instance to monitor, debug, or analyze its performance and execution history. This functionality is particularly useful…
Read MoreIntroduction: This blog has the SQL query that can be used to pull the data of employees who are recalled to join the organization. Cause of the issue: Business wants…
Read MoreOracle Fusion – How to Create an Implementation User When we are implementing Fusion Applications for any of our client, we can refer this document, how we how we…
Read MoreThe below query extracts the list of employee users along with their user status and employee status SELECT pu.username USER_NAME ,papf.person_number EMPLOYEE_NUMBER ,ppn.first_name EMPLOYEE_FIRST_NAME ,ppn.last_name EMPLOYEE_LAST_NAME ,DECODE(SUSPENDED,'Y', 'Inactive User','N', 'Active…
Read MoreThe below query extracts the list of data accesses given for any user in Oracle Cloud Application ————————————————–***************——————————————– SELECT gl.name "Security Context Value", pr.role_name"Job Role Name", pu.username "User Name", role.ACTIVE_FLAG…
Read MoreTransmission Configuration AP payments made in Oracle Could sends payment files to banks to make the real payment to vendors. In such cases, file transfer link has to be enabled…
Read MorePGP Key Encryption in AP Payments Generally, the PGP keys will be used to Encrypt and Decrypt the messages transferred between one system to another to enable the security. In…
Read MoreIntroduction This Post Provides the SQL Query that returns HCM Extract Input Values in BI Report Query SELECT TO_DATE (par_val.flow_param_value, ‘YYYY-MM-DD’) FROM pay_flow_instances flow, pay_flow_parameters flw_par, pay_flow_param_values par_val WHERE…
Read MoreIntroduction This Post Provides the SQL Query that returns Employee’s Supervisor Details Query SELECT papf.person_number employee_number, ppnf.full_name employee_name, papf_s.person_number manager_emp_number, ppnf_s.full_name manager_name FROM per_all_people_f papf, per_person_names_f ppnf, per_all_assignments_m paam,…
Read MoreIntroduction This Post Provides the Detail to get HCM Extract Input Values in Fast Formula Sample Fast Formula PERSON_NUMBER_PARAM = GET_PARAMETER_VALUE(‘PERSON_NUMBER’) CHANGES_ONLY_PARAM = GET_PARAMETER_VALUE(‘CHANGES_ONLY’) EFFECTIVE_DATE_PARAM = GET_PARAMETER_VALUE(‘EFFECTIVE_DATE’) L_VALUE =…
Read More