Entries by Oracle ERP Apps Guide

, ,

Alerts in Oracle R12

Oracle Alert is your complete exception control solution. Alerts signal important or unexpected activity in your database. They ensure that you are regularly and quickly informed about critical database events instead of sorting through length reports.The basic function of alerts includes but not limited to Keep you informed of critical activity in your database Deliver […]

, , , , ,

Basics of PL/SQL

PL/SQL stands for Procedural Language extension of SQL.PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early 90’s to enhance the capabilities of SQL.PL/SQL EnvironmentPL/SQL is not an Oracle product in its own right; it is a technology used by the Oracle […]

, , , ,

Basics of SQL

PL/SQL is a procedural language that Oracle developed as an extension to standard SQL to provide a way to execute procedural logic on the database. SQL, SQL*Plus, PL/SQL: What’s the Difference?This question has bedeviled many people new to Oracle. There are several products with the letters “SQL” in the title, and these three, SQL*Plus, SQL, […]

, , ,

OAF Personalization

In Oracle Trade Management the links ‘About This Page’ & ‘Personalize Page’ links are not enabled on any page of Oracle Trade Management even though the required profile options ‘FND: Diagnostics’, ‘FND: Personalization Region Link Enabled’ ‘,’ Personalize Self-Service Defn’ are set to ‘YES’. How to proceed further with personalisations/customizations in Oracle Trade Management?SolutionOracle Trade […]