Oracle frequently releases patches necessary to maintain your EBS Environment Healthy and Up-To-Date. These include Recommended patches (RPC), Technology Stack patches, Performance patches, Security Patches,… Read More »How to check if a patch is applied in Oracle Apps (11i, R12)
PLL is basically a PL/SQL library that contains reusable client-side code. You can create a function, procedure, write SQL and even call database package in… Read More »Which are the Common Standard PLL in Oracle Apps?
Oracle Reports is an enterprise reporting tool. It (.rdf) has played a very important role in Oracle Apps 11i. Back then, it was the main… Read More »How to Enable Trace Reports (rdf) in Oracle Apps
Forms builder is the most used tool to design GUI in Oracle Apps 11i. R12 also uses a form builder to design custom and standard… Read More »How to Enable Trace for Forms in Oracle Apps R12
This article explains, how to enable trace for Concurrent Program and generate TKPROF in Oracle Apps. These steps should work for Oracle Apps 11i and… Read More »How to enable Trace Concurrent Program in Oracle Apps
FRM-10102: Cannot attach PL/SQL library APPCORE. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library APPCORE. This library attachment will be lost if the module is saved error tells you that Form Builder is not… Read More »FRM-10102: Cannot attach PL/SQL library APPCORE. This library attachment will be lost if the module is saved.
frmcmp_batch or frmcmp_batch.sh is a UNIX level utility to compile custom form(.fmb) and libraries(.pll) in Oracle Apps R12. frmcmp_batch syntax frmcmp_batch Module= Userid=<userid/password> [Parameters] Optional… Read More »How to Compile custom Oracle forms (fmb) and libraries(PLL) using frmcmp
Oracle Apps use forms, OAF and ADF tools to design user interface. The look and feel are the same across all the forms, OAF pages… Read More »How to Setup custom form development environment in Oracle Apps
Materialized view in Oracle are the database objects based on SQL Queries. Unlike normal view MV actually contains the data. The generic statement to create… Read More »How to Create Materialized View in Oracle Apps 12.2.5 (R12)