How to configure FTP in BIP Reports of Oracle ERP Cloud

In this article I will tell you the steps to configure FTP in BIP reports. FTP configuration is used for bursting the report output to an external server using FTP protocol. Navigate to BIP from ‘Reports and Analytics’ and top right hand side you can see ‘Administration‘ option In Administration page you can find ‘FTP‘… Read More »

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 »

Character Set in SQL*Loader

Sometimes we face a problem of SQL*Loader loading data into a wrong column OR only partial data gets loaded into a column. These issues might occur because of the characters in the data being loaded. By default SQL*Loader recognizes data of UTF-8 character set only. If unrecognized characters are found, SQL*Loader might treat it as… Read More »

Do you know how to Retrieve WinSCP Stored Passwords?

Here is a utility WINSCPPWD, a simple command line tool to recover WinSCP stored passwords. Here in this article I will explain how to use this WINSCPPWD utility. Step 1: By default all WinSCP connections are stored as part of Windows Registry, this should be changed to store connections details in a .INI file by… Read More »

How to RETRY/SKIP a workflow from backend

Script to RETRY workflow BEGIN wf_engine.handleerror ( itemtype => ‘OEOL’, itemkey => 2705276, activity => ‘SHIP_LINE’, command => ‘RETRY’, RESULT => NULL ); END; / COMMIT;BEGIN wf_engine.handleerror ( itemtype => ‘OEOL’, itemkey => 2705276, activity => ‘SHIP_LINE’, command => ‘RETRY’, result => NULL ); END; / COMMIT; Script to SKIP workflow BEGIN wf_engine.handleerror ( itemtype… Read More »