Oracle Application Blog

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

Mobile First strategy with Oracle CX Mobile App

Enterprise are emphasizing on building a culture of proactive sales with responsibility of identifying leads,new account openings and agility in closing deals. To achieve this, organizations are looking towards recent…

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

OAF Date Converter, Formatter and Validation – Reusable Methods

Various Date Converter, Formatter and Validations Reusable Methods in OAF /**=============================================== * Methods related to Date Operation Starts Here * =================================================*/ /** * Method that returns the current system date.…

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

Oracle Cloud Guard

Oracle Cloud Guard, a new Oracle Cloud Infrastructure (OCI) service designed to  maintain a strong security in OCI. Cloud Guard is just one of the new services that are part…

Read More

Create Requisition interface against the blanket purchase agreement for different Locations

AIM: Component is used for Create the Requisition against the Blanket Purchase Agreement For different Locations. SCRIPT: CREATE OR REPLACE PACKAGE BODY APPS.XXTTK_BPO_PKG IS PROCEDURE XXTTK_REQ ( ERRORBUF     OUT       VARCHAR2…

Read More

Setting NLS language in SQL developer

Sometimes we will observe HR Operating units table will not show any data in database. For this we need to  do the set up in SQL Developer. Preferences –> NLS…

Read More

Special characters validation

For any field if you want throw any exception when entered any special characters.  We need to use following pattern to find. Pattern p = Pattern.compile(“[^a-zA-Z0-9\\s]”);

Read More

500 Internal error in OAF

Once any environment get refreshed in EBS, a new dbc file will be generated. Some times we will receive 500 internal error. To over come this we need to replace…

Read More