Oracle Applications Bible

 Query for Profile Options Profile’s Enabled at Site Level SELECT fpot.user_profile_option_name, fpov.profile_option_value   FROM fnd_profile_option_values fpov,        fnd_profile_options fpo,        fnd_profile_options_tl fpot  WHERE     fpo.profile_option_id = fpov.profile_option_id        AND fpo.profile_option_name = fpot.profile_option_name        AND fpot.language = 'US'        AND fpov.level_id = 10001                              -- Site Level ID Profile’s Enabled at Application Level SELECT fat.application_name,        fpot.user_profile_option_name,        fpov.profile_option_value   FROM fnd_profile_option_values fpov,        fnd_profile_options fpo,        fnd_profile_options_tl fpot, ...

 Query to Find Programs associated to Responsibility SELECT frt.responsibility_name, frg.request_group_name,     frgu.request_unit_type,frgu.request_unit_id,     fcpt.user_concurrent_program_name     FROM fnd_Responsibility fr, fnd_responsibility_tl frt,     fnd_request_groups frg, fnd_request_group_units frgu,     fnd_concurrent_programs_tl fcpt     WHERE frt.responsibility_id = fr.responsibility_id     AND frg.request_group_id = fr.request_group_id     AND frgu.request_group_id = frg.request_group_id     AND fcpt.concurrent_program_id = frgu.request_unit_id     AND frt.LANGUAGE = USERENV('LANG')     AND fcpt.LANGUAGE = USERENV('LANG')     AND fcpt.user_concurrent_program_name = :conc_prg_name     ORDER BY 1,2,3,4

 Query to Find Open PO Periods for Month End Closure SELECT sob.name "Set of Books" ,   fnd.product_code "Product Code" ,   ps.PERIOD_NAME "Period Name" ,   ps.START_DATE "Period Start Date" ,   ps.END_DATE "Period End Date" ,   DECODE(ps.closing_status, 'O','O - Open' ,                             'N','N - Never Opened' ,                             'F','F - Future Enterable' ,                             'C','C - Closed' ,'Unknown') "Period Status" FROM gl_period_statuses ps ,   Apps.GL_SETS_OF_BOOKS sob ,   FND_APPLICATION_VL fnd WHERE ps.application_id      IN (201) -- 101 GL & 201 PO  AND sob.SET_OF_BOOKS_ID       = ps.SET_OF_BOOKS_ID AND fnd.application_id        = ps.appl...

 Query to find open Inventory Periods for Month End Closure SELECT organization_code   FROM org_acct_periods oap, org_organization_definitions ood  WHERE oap.organization_id = ood.organization_id    AND oap.period_name = 'Dec-20'    AND oap.open_flag = 'Y'    AND organization_code IN ('XXX');

 Use below query to source org items from another org select msib.segment1 from mtl_system_items_b msib,      org_organization_definitions ood where msib.organization_id=ood.organization_id  AND msib.source_organization_id IN (select organization_id from org_organization_definitions where organization_code='XXX') -- Enter Source Org AND ood.organization_code='YYY' -- Enter Query Org 

Use below query to add responsibility from backend   DECLARE     v_user_name        VARCHAR2 (20) := 'USERNAME';     v_req_resp_name    VARCHAR2 (50) := 'System Administrator';     v_description      VARCHAR2 (100) := 'Adding Responsibility to user using script';     v_appl_shrt_name   VARCHAR2 (20);     v_appl_name        VARCHAR2 (50);     v_resp_key         VARCHAR2 (50); BEGIN     SELECT fav.application_short_name,            fav.application_name,            frv.responsibility_key       INTO v_appl_shrt_name, v_appl_name, v_resp_key       FROM FND_APPLICATION_VL fav, FND_RESPONSIBILITY_VL frv      WHERE frv.application_id = fav.application_id            AND frv.responsibili...

  Go to General Ledger ,Vision Operation (USA) < Setup  Then Setup < Financials < Calendars < Accounting Query (F11) "Accounting"  then press Ctrl + F11   Go to File < New and add a new line Accordingly. Enter all mandatory field as required. Now Save  Finally,  Month added in Calendar.  following Query cab help  to check the status of the Period Details - select a.period_name,        a.period_num,        a.gl_status,        b.po_status,        c.ap_status from    (select period_name, period_num,      decode(closing_status,'O','Open',                           'C','Closed',                           'F','Future',                       ...

  Profile Option in Oracle Apps Profile Options provide flexibility to Oracle Apps. They are a key component of Oracle Applications. The profile option acts like a Global Variable in Oracle. These are provided to keep the application flexible. The business rules in various countries and various companies can be different. Hence the profile options are delivered by Oracle in such a manner to avoid hard-coding of logic, and to let the implementation team at site decide the values of those variables. 1. There are profile options which can turn the debugging on, to generate debug messages. Say one of 1000 users reports a problem, and hence you wish to enable debugging against just that specific user. In this case you can “Turn On” the debugging profile option "again that specific user". 2. There are profile options that control which user can give discount to their customers at the time of data entry. You can set profile option "Discount Allowed" to a value of either Ye...

    File System Architecture in Oracle Apps R12     Base Directory : The directory where the Oracle Applications is installed. This is a generic directory.                              I will suppose that the Base Directory is  /APPS   $ORACLE_HOME  (for the database tier):  /APPS/db/tech_st/10.2.0   $APPL_TOP :    /APPS/apps/apps_st/appl     $COMMON_TOP :   /APPS/apps/apps_st/comn   $ORACLE_HOME  (for the apps tier):  /APPS/apps/tect_st/10.1.2   $IAS_ORACLE_HOME  (for the apps tier):  /APPS/apps/tect_st/10.1.3   $INST_TOP:   /APPS/inst/apps/<SID_localhost>  contains certifications, configurations, logs for the servers. 

  This document will explains about Oracle Apps login, Choosing Responsibility, Choosing Function / Opening Form, Switch Responsibility, Query Form and Keyboard Shortcuts. This chapter would tell a user about the basics of login to the Oracle Applications instance. It would also demonstrate the basics of working with Oracle Applications. To understand the complete functionality of a particular responsibility please refers to the respective User Guide. Oracle Applications Login Before you connect to Oracle Applications you must know the URL of the Oracle Applications server you want to connect to. Clicking on the URL would lead you to the Oracle Applications Login Page as shown in figure 1 below. Oracle Applications Login Page Choosing Responsibility To connect to the Oracle Applications, you must have an Oracle Apps login ID created by the System Administrator of the Oracle Applications instance.  Enter the appropriate Login ID and password and click login. If the login is suc...

What is Oracle Applications ????? Oracle initially launched its application suite with  financials  software in the late 1980s. The offering as of 2009  extends to  supply-chain management ,  human-resource  management ,  warehouse-management ,  customer-relationship management ,  call-center  services,  product-lifecycle management , and many other areas. Both in-house expansion and the acquisition of other companies have vastly expanded Oracle's application software business. Oracle Apps ... Is it just the short name of Oracle Applications? may be yes, however this question is an excuse for me to explain to you the evolution of APPS schema. Previously each module had its own database schema(which we still have). However, a purchasing user (until version 10.6) used to connect to PO schema (by the virtue of the screen being a PO screen). Hence, if a report or screen of AR ( Oracle Receivables ) module wanted to access a table named ...