Tag Archives: oracle applications

Setting your Oracle Applications session: fnd_global.apps_initialize (org_id) The examples set up the session for SYSADMIN user, System Administrator responsibility. e.g. SQL*Plus   exec fnd_global.apps_initialize(0,20420,1); e.g. for PL/SQL, TOAD, SQLDeveloper, SQL Navigator etc.: begin fnd_global.apps_initialize(0,20420,1); end; The parameters used here are: 1.        … Continue reading

Template Form in Oracle Apps This document provides an overview of the template form. This form derives its importance from the fact that this form is the starting point of all development involving forms. The document highlights the importance of … Continue reading

Important things to focus as you are 0 to 2 Year experience in Oracle Applications Technical

Important things to focus as you are 0 to 2 Year experience in Oracle Applications Technical

1.Learn SQL – Writing Queries

2.Be Proficient in PL/SQL Programming

3.Learn more or more on System Admin and Application Developer module

4.Learn Unix – at least basics !

Hello Friends, here i am posting some of basic oracle applications questions , will try to collect more and put in future posts, here i am putting quite easy and basic questions. If you like to know Questions of any … Continue reading

Hello Friends , here is some of quite commonly used AOL FND ( Foundation) tables and their usage. There are many other tables also in FND but here i am putting only few commonly used tables. for other table if … Continue reading

Question: What are ALERT? Answer: An ALERT is a modal window that displays a message notifiying operator of some application condition. Question: Can a button have icon and label at the same time? Answer: NO Question: What is mouse navigate … Continue reading

Shivmohan – Oracle 11i Multi Org – Definition

What is the MultiOrg and what is it used for?

MultiOrg or Multiple Organizations Architecture allows multiple operating units and their relationships to be defined within a single installation of Oracle Applications. This keeps each operating unit’s transaction data separate and secure. Further all organizations can share some master data like supplier, customer, bank, AFF, payment terms, price lists etc.

Use the following query to determine if MuliOrg is intalled:

select multi_org_flag from fnd_product_groups;

 

Thanks – Shivmohan Purohit