Step By Step Oracle Applications R12 installations in Linux 5.5.

STEP 1: This document gives the clear steps to create the DQA_TOP (CUSTOM_TOP) in R12 Oracle Application.  The following need to be created in R12 Oracle Application for DQA_TOP (CUSTOM_TOP). SCHEMA NAME:       DQA TOP NAME:                 DQA_TOP Application:                DQA Custom Application Data Group:                DQA Group Request Group:         DQA Request Group Menu:    …

UTL_FILE is an oracle pl/sql package that is supplied to allow PL/SQL to read and create text files in the file system. UTL_FILE can only read and create text files. Specifically, it cannot be used to read or create binary files. UTL_FILE is an appropriate tool for creating reports in the form of  flat file from the database . UTL_FILE is also used  for reading files. The following steps must…

When you opening the Oracle Database 10g Forms Builder, suppose if you got an error like the following screenshot, The Error is “FRM-18122: Forms Builder Debugger failed to initialize” Step by Step Solutions to Rectifying the Error “ FRM-18122: Forms Builder Debugger failed to Initialize ” First, Select My Computer then click Properties by the time you will see System Properties window like the following Screenshot,   In that Properties…

Custom Table Registration API in Oracle Application This Post (document) provides you with information you need to register tables to be used in Oracle Alerts and Flex fields with Oracle Applications. We will be learning about Procedures in the AD_DD Package, Procedure REGISTER_TABLE, Procedure REGISTER_COLUMN, Procedure DELETE_TABLE, Procedure DELETE_COLUMN And Example of Using the AD_DD Package. Introduction Though Oracle Applications comes with thousands of seeded database tables, there can be…