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 PLL and then attache the library to a single form or multiple forms. The approach here is code once and reuse in multiple forms. You can add specific validation, navigation, […]
Which are the Common Standard PLL in Oracle Apps? Read More »
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 on the columns which are defined as unique. As per Oracle error message guide, ORA-00001: unique constraint (string.string) violatedCause: An UPDATE or INSERT statement attempted to insert a duplicate key. For
ORA-00001: unique constraint (string.string) violated Read More »
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 transaction like an update, insert, delete is in progress. A transaction completes when you either issue Commit or Rollback. As per Oracle Error Message Guide, ORA-12841: Cannot alter the session
ORA-12841: Cannot Alter The Session Parallel DML State Within A Transaction Read More »
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 which does not fit in any defined partition for the table. As per Oracle Error Message Guide, Cause: An attempt was made to insert a record into, a Range or
ORA-14400: inserted partition key does not map to any partition Read More »
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 tool to design reports. Now, XML Publisher replaced reports in Oracle Apps R12. In this article, let’s see how to enable trace for reports if you are still using it.
How to Enable Trace Reports (rdf) in Oracle Apps Read More »
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 forms. Forms internally run SQL Queries, call package/procedure as per the business logic against Oracle Database. Sometimes, you find forms are running slow, taking time to perform the transaction. In
How to Enable Trace for Forms in Oracle Apps R12 Read More »
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 R12 release. Concurrent programs execute business logic by connecting to the database and performing database operations like updating, inserting, and deleting. These operations consume CPU, Memory, and other resources. An
How to enable Trace Concurrent Program in Oracle Apps Read More »
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 able to attach the concerned library (XXX) when you open the TEMPLATE.fmb Form in Oracle Apps or forms_path is incorrect or missing. Where XXX library could be any of these
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 to improve performance, but it creates a problem when a new web-based responsibility is assigned to the user. The user gets the below error when trying to open the responsibility.
How to Clear the OA Framework cache in Oracle Apps Read More »
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, Oracle Forms, Oracle Reports, and SQL*Net could not find the alias specified for a connection in the TNSNAMES.ORA file or other naming adapters. Now, let’s reproduce the error and find
ORA-12154: TNS could not resolve the connect identifier specified Read More »