Entries by Oracle ERP Apps Guide

, , ,

How to add a context dependent descriptive flex-field on OAF Control Item page?

We all know (I think :-)) the way in Oracle Forms to create context dependent descriptive flexfields. That is displaying additional segments within the form based on some other value in the form or maybe a value on a profile option. These context dependent flexfields were at first not possible in framework because the references […]

, , ,

Tricks for generating SQL statements in Excel 2003/2007

The semi-colon needs to be inside the last double quote with a closing param. When adding single quotes around a string, remember to add them outside your selected cell. (spaces added for visibility – remove before inserting) =CONCATENATE(“insert into table (id, name) values (“,C2,”,’ “,D2,” ‘);”) Here is another view: =CONCATENATE(“insert into table (id, date, […]

, , , , ,

Some Useful Queries in Oracle Apps R12

How to initialize session in Oracle ?FND_GLOBAL.APPS_INITIALIZE is used for initializing the session before calling any public or private API’s in Oracle Ebusiness suite. Its not required for all the API’s but its recommended that you set this profile before making any calls to either private or public API. Mentioned below is a sample call to FND_GLOBAL.APPS_INITIALIZE […]

, , , ,

Oracle Unified Method (OUM) – Basics and Download

Since retirement for Oracle legacy methods, there was lot of queries on OUM vs AIM , therefore this post will help reader to know more about new method. The OUM aka Oracle Unified Method supports the entire Enterprise IT Life cycle, including support for the successful implementation of every Oracle product. It is a robust, technology agnostic methodology Oracle Methods […]