Apps

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, etc. Sometimes, you also identify a patch while searching on support.oracle.com(Metalink), when you face issues with Oracle apps and would like to see if that patch is applied to your […]

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,

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.

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

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.

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 parameters are (default values given): 1. Compile custom form (.fmb) in Oracle Apps Open Putty and login to Oracle Applications UNIX server( apps tier). sftp custom form(.fmb) file from a

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 to have consistent across Oracle Apps. Your custom form should also follow the same standards so that it does not look alien when registered with Oracle Apps. So let’s see