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?
The ORA-00001: unique constraint (string.string) violated error comes when you try to update or insert a record in a table(Oracle Database) that creates a duplicate… Read More »ORA-00001: unique constraint (string.string) violated
The ORA-12841: Cannot Alter The Session Parallel DML State Within A Transaction error comes when you issue alter session enable parallel DML command when some… Read More »ORA-12841: Cannot Alter The Session Parallel DML State Within A Transaction
The ORA-14400: inserted partition key does not map to any partition error in Oracle comes when you try to insert value in a partition table… Read More »ORA-14400: inserted partition key does not map to any partition
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 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.
Oracle Apps uses a cache mechanism to cache frequently used resources like static pages, images, javascript, etc. to reduce OAF page load time. This helps… Read More »How to Clear the OA Framework cache in Oracle Apps
ORA-12154: TNS could not resolve the connect identifier specified error comes when you try to connect to Oracle database using clients/tools like SQL Plus, Toad,… Read More »ORA-12154: TNS could not resolve the connect identifier specified