Oracle has provided a webservice ExternalReportWSSService with “runReport” Operation which helps to run a report which is on BIP of Oracle ERP Cloud and get… Read More »SOAP Payload to Run a BI Publisher Report on Oracle ERP Cloud
ErpIntegrationService can be leveraged to import FBDI file data in csv format to UCM server, load data into GL_INTERFACE table based on the jobName specified… Read More »GL Journal FBDI Automation using ErpIntegrationService
SELECT * FROM (SELECT user_info.user_login, user_info.user_id, user_roles.role_name, user_info.creation_date, user_info.first_name, user_info.last_name, user_info.location_code, user_info.location_name, user_info.town, user_info.country, user_info.department, user_info.username, user_info.active_flag FROM (SELECT DISTINCT pp.creation_date creation_date, ppf.first_name first_name, ppf.last_name… Read More »SQL Query to list All User Roles in ERP Cloud
We can find current execution stage of any PL/SQL code from table GV$SQLTEXT_WITH_NEWLINES but we need its session ID. If that PL/SQL code belongs to… Read More »Long Running Programs – SQL Query to Find Current Execution Stage of a Concurrent Request
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… Read More »How to configure FTP in BIP Reports of Oracle 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… Read More »How to customize seeded BIP reports in ERP Cloud
/******************************************************* *PURPOSE: SQL Query to find BIP Report Jobs History * *AUTHOR: Shailender Thallam * *******************************************************/ SELECT (CASE WHEN state = 1 THEN ‘Wait’ WHEN… Read More »SQL Query to find BIP Report Jobs History
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… Read More »ESS Job in Retrying Status when called from a webservice or SOAP UI
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 *… Read More »SQL Query to List Reference Data Sets and their Assignments with Business Units in Oracle ERP Cloud