Oracle SYS_CONTEXT Function in PL/SQL
Have you ever tried to find out the database name or instance name without having access to data dictionary views? How to get the client… Read More »Oracle SYS_CONTEXT Function in PL/SQL
RICE Components, CEMLI Terminology in Oracle Apps
In our day to day Oracle Apps consulting life we often hear some terminology called RICE and CEMLI. Today I am writing a small article… Read More »RICE Components, CEMLI Terminology in Oracle Apps
How to Disable Password Protection for Personalization and Help Diagnostics Examine
Some times we get below error while trying to access personalization form “Function is not available for this responsibility. Change responsibilities or contact your System… Read More »How to Disable Password Protection for Personalization and Help Diagnostics Examine
Disable all Personalizations done on a Instance
Disable Self-Service Personalization is a profile option which should be configured to ‘Yes’ to disable both Form based and OA Page based personalization. Note: You… Read More »Disable all Personalizations done on a Instance
Information on Errbuf and Retcode Parameters
Errbuf and Retcode are two OUT type mandatory parameters used in PL/SQL procedures which are called through concurrent requests. Purpose of Errbuf and Retcode Paramters?… Read More »Information on Errbuf and Retcode Parameters
Oracle Tables with Suffix _ALL, _TL, _B, _F, _V, _VL, _S, _A, _AVN and _ACN
_ALL Table holds all the information about different operating units in a Multi-Org environment. You can also set the client_info to specific operating unit to… Read More »Oracle Tables with Suffix _ALL, _TL, _B, _F, _V, _VL, _S, _A, _AVN and _ACN
Drop Shipment Functional Process and Technical Information
Drop Shipment Functional Process Oracle Order Management and Oracle Purchasing integrate to provide Drop Shipments. Drop Shipments are orders for items that your supplier ships… Read More »Drop Shipment Functional Process and Technical Information
Back to Back Order Functional and Technical Flow
Business Purpose of Back to Back Order 1. Customer orders items (OM). 2. Purchase those items from the supplier (PO) and receive them into the… Read More »Back to Back Order Functional and Technical Flow
Order to Cash Technical Flow
Here in this article I will be writing technical details of Order to Cash Cycle. Order Entry Sales Order entry consists of two parts, Order… Read More »Order to Cash Technical Flow
How to change Standard Oracle Logo
Standard Oracle Logo can be changes in two ways one at site level and one at entire application level. 1) You can replace Standard logo… Read More »How to change Standard Oracle Logo