Posts by Rajan Chandru

Cascading Select list in IR Oracle APEX

By default the Interactive Reporting Region allows end users to customize reports. This interactive reporting region allows users to customize the layout of the data by choosing the columns they…

Read More

How to reset apps password

Introduction  This blog explains how to reset the Oracle apps password from the backend. #Code# BEGIN FND_USER_PKG.UPDATEUSER (X_USER_NAME => ‘USERNAME’ , X_OWNER => ‘APPS’ , X_UNENCRYPTED_PASSWORD => ‘Pasword@123’ , X_PASSWORD_DATE…

Read More

Query To get DFF Details

Introduction  A flexfield is a customizable flexible data field that you can customize according to business needs without coding. Oracle Applications uses two types of flexfields, key flexfields and descriptive flexfields. A key flexfield is…

Read More

Item Category Creation R12

Introduction  An Item category is a logical classification of items that have similar properties. A category set is a distinct group scheme and consists of categories. The flexibility of category sets allows…

Read More

Configuring APEX to use BI Publisher

Introduction           We will see about how to configuring apex to use bi publisher in Details with steps to follow.  Steps To Follow         To use BI Publisher as your…

Read More

Append the Data Base value to Tabular Form Read only Column

 Introduction           We can see about append the data base value to tabular form read only column. Steps To Follow              Get the interactive repot table id Example : var…

Read More

Hide the Report Column based on User Condition

Introduction The Interactive Reporting Region is an innovative new technology that allows end users to customize reports.In Interactive Reporting we can hide the report column based on user condition.  …

Read More

Apex Interactive Report Look and Feel

Introduction           In Apex Interactive Report design, look and feel is a term used with respect to a graphical user interface and comprises aspects of its design, including elements such…

Read More

Integrating With Fusion Application Using Services (APEX)

Introduction              Fusion Applications provides web services that allow external systems to integrate with Fusion Applications. There are two types of services: ADF services and composite services. ADF services are…

Read More

Multiple User Interface for Oracle APEX

Introduction         User Interfaces Within a single Application you can have Desktop and Mobile Pages with individual Themes each That means an Application can have multiple active Themes Pages and…

Read More