Database Blog

Oracle Applications Server level Setups related to Dunning letters

This post related to Oracle Applications Server level Setups related to Dunning letters. Assumption: It is assumed that the Dunning letter process is not customized. below steps applies for standard process.…

Read More

Converting HTTPS TO HTTP for Oracle applications

This post is to guide to Convert HTTPS TO HTTP for Oracle applications. 1. Bring down Oracle applications: cd $ADMIN_SCRIPTS_HOME sh adstrtal.sh apps/apps123 2. Change the below parameters in .xml…

Read More

How to debug Outbound ECX Transactions ( XML PO Transmission)

There is a very good diagnostics script provided by oracle support it self. When you execute the sql script, it produces the html output,  which shows all the required data…

Read More

CE UMX Security Roles Assignment to Cash Management Responsibility

This post is to guide “CE UMX Security” Roles Assignment to Cash Management Responsibility 1. Login to sysadmin , navigate to User Management / Roles and Role Inheritance. 2. Query…

Read More

SQL Query to get list of user,assigned responsibilties and assigned modules

Below SQL Query helps us to get list of users, assigned responsibilities and its modules. Query gets “Last time the user used the responsibility”, User’s Person Name, Email address, Users’ Employee Number,…

Read More

Oracle Transport Agent for XML Gateway

How to Configure Oracle Transport Agent (OTA) for XML Gateway. OTA Overview: In E-Business Suite Applications (EBS) Release 12 (R12),  Jserv is no longer used in the applications tier for…

Read More

Untitled

   Steps to change APPS password in EBS 12.2 From EBS 12.2, after changing APPS password using FNDCPASS/AFPASSWD, we need to perform some additional manual steps (partially automated with R12.AD.C.Delta.7…

Read More

Punchout Configuration

Overview : What is Punchout? Punchout is a feature from iProcurement and Oracle Supplier Network which allows to access the external catalog and bring the items to iProcurement in order…

Read More

How to Exclude Failure Notice/Any Pattern Emails from Processing in Oracle Applications Workflow

How to Exclude Failure Notice/Any Pattern Emails from Processing in Oracle Applications Workflow When there is a out of office notification or Email got bounced it will be sent to…

Read More

Workflow mailer outbound and inbound setup

Workflow mailer outbound and inbound setup for R12 Oracle Applications. Assumption : It is assumed that the setup is being done for both outbound (send emails) and inbound (to process…

Read More