Category Archives: Oracle ERP Cloud

How to customize seeded BIP reports in ERP Cloud

In this article lets see how to customize seeded ‘Payment File Formats‘ report Login to ERP cloud instance and navigate to Reports and Analytics By default the URL of Reports will look like “https://< POD >.fa.us2.oraclecloud.com/analytics/saw.dll?catalog“. We need to login in server mode to find ‘Customize‘ report option. To login as server mode open BIP… Read More »

SQL Query to find BIP Report Jobs History

/******************************************************* *PURPOSE: SQL Query to find BIP Report Jobs History * *AUTHOR: Shailender Thallam * *******************************************************/ SELECT (CASE WHEN state = 1 THEN ‘Wait’ WHEN state = 2 THEN ‘Ready’ WHEN state = 3 THEN ‘Running’ WHEN state = 4 THEN ‘Completed’ WHEN state = 9 THEN ‘Cancelled’ WHEN state = 10 THEN ‘Error’ WHEN… Read More »

SQL Query to List Reference Data Sets and their Assignments with Business Units in Oracle ERP Cloud

/***************************************************************************** *PURPOSE: SQL Query to List Reference Data Sets and their Assignments with * Business Units in Oracle ERP Cloud * *AUTHOR: Shailender Thallam * *****************************************************************************/ SELECT fsa.reference_group_name, fs.set_id, fs.set_code, fs.set_name, fs.description, bu.bu_name FROM fnd_setid_assignments fsa, fun_all_business_units_v bu, fnd_setid_sets_vl fs WHERE 1 = 1 AND fsa.determinant_type = ‘BU’ AND fsa.determinant_value = bu.bu_id AND fsa.set_id =… Read More »

SQL Query to List Oracle ERP Cloud Users and their Attached Roles

/***************************************************************************** *PURPOSE: SQL Query to List Oracle ERP Cloud Users and their Attached Roles * *AUTHOR: Shailender Thallam * *****************************************************************************/ SELECT pu.user_id, pu.username, ppnf.full_name, prdt.role_id, prdt.role_name, prd.role_common_name, prdt.description, TO_CHAR (pur.start_date, ‘DD-MON-YYYY’) role_start_date, TO_CHAR (pur.end_date, ‘DD-MON-YYYY’) role_end_date, prd.abstract_role, prd.job_role, prd.data_role, prd.duty_role, prd.active_flag FROM per_user_roles pur, per_users pu, per_roles_dn_tl prdt, per_roles_dn prd, per_person_names_f ppnf WHERE 1 =… Read More »