This a quite common requirement for clients to restrict some jobs to particular user(s). This can be achieved using Privilege Roles. Every ESS job has… Read More »How to Restrict an ESS Job to a Particular User in ERP Cloud
In this article we will write about how to configure to connect to a bank server using a our own generated Private and Public Key… Read More »Configuring Bank Transmission by Generating own Private and Public Key Pair
ERP Object Attachment Service is a generic service provided by oracle to upload text, file, and URL based attachments to business objects. Service WSDL URL:… Read More »Webservice Payload to upload Attachments in ERP Cloud – ErpObjectAttachmentService
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
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
Here is the article on the process to create a clone/refresh request and the guidelines to consider for a better planning P2T – PROD as… Read More »Oracle ERP Cloud Instance Clone/Refresh Guidelines
/********************************************************* *PURPOSE: SQL Query to find ESS Job History * *AUTHOR: Shailender Thallam * *********************************************************/ SELECT p.requestid parent_request_id, m.requestid request_id, NVL(p.name, substr(p.DEFINITION, instr(p.DEFINITION, ‘/’, -… Read More »ESS Request History with Time took to Run
We have REST Service “receivablesInvoiceDFF“to Create an AR Invoice DFF, but unfortunately we cannot update DFF with REST Service. We have a SOAP Service “ERP… Read More »Payload to Update AR Invoice DFF in Oracle ERP Cloud
Sometimes you may observe that emails sent out to customers or suppliers from oracle are with from address as “no-reply@oracle.com” instead of your client domain… Read More »Emails generated by Oracle ERP are delivered to customer/Supplier with from email address as “no-reply@oracle.com” instead of no-reply@client-DomainName.com
/******************************************************************* *PURPOSE: ERP Cloud SQL Query to find Bank Accounts Associated with a Supplier * *AUTHOR: Shailender Thallam * *******************************************************************/ SELECT ps.segment1 AS vendor_num ,… Read More »Oracle ERP Cloud SQL Query to find Bank Accounts Associated with a Supplier
/******************************************************************* *PURPOSE: SQL Query to validate email address * *AUTHOR: Shailender Thallam * *******************************************************************/ SELECT EMAIL_ADDRESS FROM HZ_CONTACT_POINTS WHERE EMAIL_ADDRESS IS NOT NULL AND NOT… Read More »SQL Query to Validate Email Address
We can find instance name using FUSION.ASK_DEPLOYED_DOMAINS table. /******************************************************************* *PURPOSE: SQL Query to find Oracle FUsion Instance name * *AUTHOR: Shailender Thallam * *******************************************************************/ SELECT… Read More »How to find Oracle Fusion Instance Name through SQL
SELECT * FROM ( SELECT gl.name , ROLE.role_name , pu.username FROM fusion.fun_user_role_data_asgnmnts ROLE , fusion.gl_access_sets gl , fusion.per_users pu WHERE gl.access_set_id = ROLE.access_set_id AND pu.user_guid… Read More »SQL Query of Manage Data Access along with Security Context
Refer to Blog Post for generating Public/Private Key combination Through File Import and Export wizard, Private key should be uploaded to UCM Account “fin/payments/import“ Note:… Read More »Process to Upload Public/Private Key for File Transmissions in Oracle ERP Cloud
/******************************************************************* *PURPOSE: SQL Query to get Org Structure along with LE, BU, Ledger and Flex * *AUTHOR: Shailender Thallam * *******************************************************************/ SELECT horg.name enterprise ,… Read More »Oracle ERP Cloud – SQL Query to get Organization Structure along with Legal Entity, Business Unit, Ledger and Flex Values