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 »
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 »
/******************************************************* *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 »
ESS Job is stuck in Retrying Status when submitted through a webservice ‘submitESSJobRequest‘ this is because the user used for submitting the webservice is not having ‘IT Security Manager‘ role.
Below is the format of UCM Server URL, you can access with ERP credentials provided proper roles are assigned to the login: https://(POD).fs.us2.oraclecloud.com/cs/idcplg
/***************************************************************************** *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 »
/***************************************************************************** *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 »
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 »
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 »
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 »