How to enable Operating Unit LOV has no values When Submitting Concurrent Requests For a Responsibility

1. Login into application with System Administration responsibility (NOT System
     Administrator)
2. Navigate: Concurrent -> Programs
3. Query for short name of the concurrent program
4. Click on Update pencil icon of your program
5. Under 'Update Concurrent Program' region, select Request tab
6. Under 'Request Setting' region, select 'Single' from the drop down of 'Operating Unit
     Mode' field
7. Save changes by clicking on 'Apply' button.



UPDATE FND_CONCURRENT_PROGRAMS
SET MULTI_ORG_CATEGORY='S'
WHERE CONCURRENT_PROGRAM_NAME = '<your program name>'

How to set a User as Worker

Step 1: Go to system administrator responsibility

Step 2:  Go to Security 

Step 3: then go User

Step 4: then Define menu.

Step 5: Query to user name.

Step 6: Set to person name.

How to find how many and what DFF (Descriptive Flex Field) are enabled in the Oracle APPS R12

SELECT APPLICATION_TABLE_NAME,TITLE ,FORM_CONTEXT_PROMPT
FROM FND_DESCRIPTIVE_FLEXS_VL
WHERE FREEZE_FLEX_DEFINITION_FLAG='Y'
AND LAST_UPDATED_BY NOT IN (-1,1,2,0,120,121);

DFF :- Personalizing the flexfield segments is not possible through forms personalization due to below reason:

Personalizing the flexfield segments is not possible through forms personalization due to below reason:

A Flexfield is a single field in a Form but then when you click into it and it opens up the flexfields window, 
the multiple fields you see is actually a user exit with multi segment values, not form fields.
No Form Personalization events are passed to flexfield windows (user exits).
No Form Personalization events are passed to segments inside the flexfield window (user exit).

If you want to disabled the segments, you can disable the segment
in flexfield definition form(Uncheck the enabled checkbox).


The flex developer has stated this would involve a major re-write of the flex code for APPCORE
to process forms personalization rules and actions pertaining to flexfields.
One need to understand that flexfields are not assigned to a canvas, 
the flexfield UIs in forms are not native form fields but built on the fly with user exits.


Defaulting, populating, and or manipulating hidden fields for descriptive
flexfield attributes should not, and are not supported by flexfields to be
done through forms personalizations. Only Flexfields will support through
the flexfield setup and definition.

How to find Table Information and Application Name

SELECT   FT.TABLE_NAME,FT.USER_TABLE_

NAME,
           FT.DESCRIPTION TABLE_DESC,
           FAL.APPLICATION_NAME,
           FA.APPLICATION_SHORT_NAME,
           FC.COLUMN_SEQUENCE,
           FC.COLUMN_NAME,
           FC.USER_COLUMN_NAME,
           (SELECT FC.COLUMN_NAME FROM FND_PRIMARY_KEY_COLUMNS FPK
           WHERE FPK.APPLICATION_ID= FC.APPLICATION_ID
           AND   FC.TABLE_ID = FPK.TABLE_ID
           AND   FC.COLUMN_ID  = FPK.COLUMN_ID) PRIMARY_KEY_COLUMNS,
           FC.COLUMN_TYPE,
           FC.WIDTH,
           FC.PRECISION,
           FC.SCALE,
           FC.DEFAULT_VALUE,
           FC.NULL_ALLOWED_FLAG,
           FC.TRANSLATE_FLAG,
           FC.DESCRIPTION COL_DESCRIPTION,
           FC.FLEXFIELD_APPLICATION_ID,
           FC.FLEXFIELD_NAME,
           FLEXFIELD_USAGE_CODE
    FROM   FND_TABLES FT
         , FND_COLUMNS FC
         , FND_APPLICATION FA
         , FND_APPLICATION_TL FAL
   WHERE   FAL.APPLICATION_NAME = NVL(:P_APPLICATION_NAME,0) --Receivables --FC.APPLICATION_ID = 222)
   AND     FT.TABLE_NAME       = NVL(:P_TABLE_NAME,0)       --RA_CUSTOMERS --(FC.TABLE_ID = 52559)
   AND     FT.APPLICATION_ID = FC.APPLICATION_ID
   AND     FT.TABLE_ID       = FC.TABLE_ID
   AND     FT.APPLICATION_ID = FAL.APPLICATION_ID
   AND     FA.APPLICATION_ID = FAL.APPLICATION_ID
   AND     FT.TABLE_TYPE= 'T' --Transaction Data
ORDER BY   COLUMN_SEQUENCE

Oracle Apps Tables Name (Most Ueses)

General Ledger (GL)

GL_JE_BATCHES

GL_JE_HEADERS

GL_JE_LINES

GL_CODE_COMBINATIONS

GL_BALANCES

GL_JE_CATEGORIES_TL

GL_JE_SOURCES_TL

GL_LEDGERS

GL_SETS_OF_BOOKS

 Accounts Payables (AP):

AP_INVOICES_ALL

AP_EXPENSE_REPORT_HEADERS_ALL

AP_INVOICE_RELATIONSHIPS

AP_INVOICE_DISTRIBUTIONS_ALL

AP_PAYMENT_SCHEDULES_ALL

AP_HOLDS_ALL

AP_AE_LINES_ALL

AP_AE_HEADERS_ALL

AP_CHECKS_ALL

 Accounts Receivables (AR):

RA_CUSTOMER_TRX_ALL

RA_CUST_TRX_TYPES_ALL

RA_CUSTOMER_TRX_LINES_ALL

RA_CUST_TRX_LINE_GL_DIST_ALL

AR_PAYMENT_SCHEDULES_ALL

AR_CASH_RECEIPTS_ALL

AR_RECEIVABLES_TRX_ALL

AR_RECEIPT_METHOD_ACCOUNTS_ALL

AR_RECEIVABLE_APPLICATIONS_ALL

Oracle Inventory (INV)

MTL_SYSTEM_ITEMS_B

MTL_SYSTEM_ITEMS_TL

MTL_ITEM_CATEGORIES

MTL_ITEM_SUB_INVENTORIES

MTL_CATEGORIES_B

MTL_CATEGORY_SETS_B

MTL_CATEGORY_SETS_TL

MTL_DEMAND

MTL_ONHAND_QUANTITIES

MTL_MATERIAL_TRANSACTIONS_TEMP

MTL_SYSTEM_ITEMS_FVL

MTL_LOT_NUMBERS

MTL_UNITS_OF_MEASURE_TL

MTL_TXN_SOURCE_TYPES
MTL_MATERIAL_TRANSACTIONS
MTL_TRANSACTION_TYPES
MTL_SECONDARY_INVENTORIES -------Sub Inventory Table
MTL_ITEM_LOCATIONS  -------Locator Table

Purchasing (PO)

PO_HEADERS_ALL

PO_LINES_ALL

PO_LINE_LOCATIONS_ALL

PO_DISTRIBUTIONS_ALL

PO_REQUISITION_HEADERS_ALL

PO_REQUISITION_HEADERS_ALL

PO_REQUISITION_LINES

PO_REQ_DISTRIBUTIONS_ALL

PO_VENDORS

PO_VENDOR_SITES_ALL

Order Management (OM)

Entered

OE_ORDER_HEADERS_ALL

OE_ORDER_LINES_ALL

OE_PRICE_ADJUSTMENTS

OE_ORDER_PRICE_ATTRIBS

OE_ORDER_HOLDS_ALL

Booked

OE_ORDER_HEADERS_ALL

WSH_DELIVERY_DETAILS

Pick Released 

WSH_DELIVERY_DETAILS

WSH_PICKING_BATCHES

MTL_RESERVATIONS

Full Transaction

MTL_MATERIAL_TRANSACTIONS

MTL_TXN_REQUEST_HEADERS

MTL_TXN_REQUEST_LINES

WSH_DELIVERY_DETAILS

WSH_NEW_DELIVERIES

WSH_DELIVERY_ASSIGNMENTS

Pick Confirmed

WSH_DELIVERY_DETAILS

Ship Confirmed

WSH_DELIVERY_DETAILS

MTL_MATERIAL_TRANSACTIONS

WSH_NEW_DELIVERIES

OE_ORDER_LINES_ALL

WSH_DELIVERY_LEGS

OE_ORDER_HEADERS_ALL

Auto invoice

WSH_DELIVERY_DETAILS

RA_INTERFACE_LINES_ALL

RA_CUSTOMER_TRX_ALL

RA_CUSTOMER_TRX_LINES_ALL

Price Details

QP_LIST_HEADERS_B

QP_PRICING_ATTRIBUTES

QP_LIST_LINES

Payment Terms

RA_TERMS

Auto Matic Numbering System

AR_SYSTEM_PARAMETES_ALL

Fixed Assets 

FA_ADDITIONS_B

FA_ADDITIONS_TL

FA_ADJUSTMENTS

FA_ADJUSTMENTS_T

Customer Information

HZ_PARTIES

HZ_PARTY_SITES

HZ_LOCATIONS

HZ_CUST_ACCOUNTS

HZ_CUST_ACCOUNT_SITES_ALL

HZ_CUST_SITE_USES_ALL

HZ_CUSTOMER_PROFILES

HZ_CUST_PROFILE_CLASSES

RA_CUSTOMERS

TAX

JAI_TAX_LINES
JAI_CMN_TAXES_ALL

JAI_PO_TAXES

JAI_CMN_INVENTORY_ORGS

JAI_RGM_REGISTRATIONS

JAI_OM_OE_SO_TAXES

Projects

PA_PROJECTS_ALL

How to find Application Instance Login URL same database

---Application Instance Login URL

SELECT profile_option_value URL

  FROM fnd_profile_option_values

 WHERE     profile_option_id =

              (SELECT profile_option_id

                 FROM fnd_profile_options

                WHERE profile_option_name = 'APPS_FRAMEWORK_AGENT')

       AND level_value = 0;

How to Delete Concurrent Program and Executable

Remove Concurrent Program and Executable

Delete Concurrent Program 

Execute FND_PROGRAM.DELETE_PROGRAM('V_PROG_SHORT_NAME', 'V_APPL_SHORT_NAME');
 Commit;


Delete Concurrent Executable:


Execute FND_PROGRAM.DELETE_EXECUTABLE('V_PROG_SHORT_NAME', 'V_APPL_SHORT_NAME');

  Commit; 


Deleting the Template:
BEGIN
XDO_TEMPLATES_PKG.DELETE_ROW('V_APPL_SHORT_NAME','V_PROG_SHORT_NAME');
END;


Deleting the Data Definition:
BEGIN
XDO_DS_DEFINITIONS_PKG.DELETE_ROW('V_APPL_SHORT_NAME','V_PROG_SHORT_NAME');
END;

Note: 
V_APPL_SHORT_NAME = application short name
V_PROG_SHORT_NAME = concurrent program short name

How to Solve APP-FND-00222 Error When Submitting a Custom Concurrent Request Registered under a Custom Application

Error : APP-FND-00222 Error When Submitting a Custom Concurrent Request Registered under a Custom Application

Cause :

The custom application has not been assigned to any data group

Solution :

1.  Under the System Administrator responsibility 

          Navigate to Security --> Oracle --> DataGroup.

2.  Query up a data group (Standard Data Group is appropriate).

3.  A list of applications associated with the standard data group will appear.

4.  Click on FILE in the toolbar menu then click on NEW.

5.  In the Application column select the custom application from the LOV.

6.  Add an Oracle ID to the ORACLE ID column (APPS is appropriate)

7.  Save the changes.

8.  Resubmit the concurrent request.

Note:  support.oracle.com document [ID 150993.1 ]

FND_PROFILE and FND_GLOBAL values

[For more information, please visit http://docs.oracle.com/cd/E18727_01/doc.121/e12897/T302934T462356.htm]

Following are the FND_PROFILE values that can be used in the PL/SQL code:

   fnd_profile.value('PROFILEOPTION');

   fnd_profile.value('MFG_ORGANIZATION_ID');

   fnd_profile.value('ORG_ID');

   fnd_profile.value('LOGIN_ID');

   fnd_profile.value('USER_ID');

   fnd_profile.value('USERNAME');

   fnd_profile.value('CONCURRENT_REQUEST_ID');

   fnd_profile.value('GL_SET_OF_BKS_ID');

   fnd_profile.value('SO_ORGANIZATION_ID');

   fnd_profile.value('APPL_SHRT_NAME');

   fnd_profile.value('RESP_NAME');

   fnd_profile.value('RESP_ID');

Following are the FND_GLOBAL values that can be used in the PL/SQL code:

   FND_GLOBAL.USER_ID;

   FND_GLOBAL.APPS_INTIALIZE;

   FND_GLOBAL.LOGIN_ID;

   FND_GLOBAL.CONC_LOGIN_ID;

   FND_GLOBAL.PROG_APPL_ID;

   FND_GLOBAL.CONC_PROGRAM_ID;

   FND_GLOBAL.CONC_REQUEST_ID;

For example, I almost always use the following global variable assignments in my package specification to use throughout the entire package body:

   g_user_id      PLS_INTEGER  :=  fnd_global.user_id;

   g_login_id     PLS_INTEGER  :=  fnd_global.login_id;

   g_conc_req_id  PLS_INTEGER  :=  fnd_global.conc_request_id;

   g_org_id       PLS_INTEGER  :=  fnd_profile.value('ORG_ID');

   g_sob_id       PLS_INTEGER  :=  fnd_profile.value('GL_SET_OF_BKS_ID');

And initialize the application environment as follows:

   v_resp_appl_id  := fnd_global.resp_appl_id;

   v_resp_id       := fnd_global.resp_id;

   v_user_id       := fnd_global.user_id;

     

   FND_GLOBAL.APPS_INITIALIZE(v_user_id,v_resp_id, v_resp_appl_id);

How To Find Descriptive Flexfield (DFF) Type

 DESCRIPTIVE FLEX FIELD

Example:
Application : Purchasing
Title : PO Headers
Context Field value : one or more type

SELECT  ATTRIBUTE_CATEGORY
FROM     PO_HEADERS_ALL
WHERE  SEGMENT1=1386

How many responsibility assign in a User

SELECT  FU.USER_ID,FU.USER_NAME
        ,FAT.APPLICATION_NAME
        ,FA.APPLICATION_SHORT_NAME SHORT_NAME
        ,FRT.RESPONSIBILITY_NAME
        ,FRT.DESCRIPTION
        ,FR.RESPONSIBILITY_KEY
        ,TO_CHAR(FUR.CREATION_DATE,'DD-MON-YYYY HH:MI:SS AM') RESPONS_START_DATE
FROM    FND_RESPONSIBILITY FR
,       FND_RESPONSIBILITY_TL FRT
,       FND_APPLICATION     FA
,       FND_APPLICATION_TL  FAT
,       FND_USER_RESP_GROUPS_DIRECT FUR
,       FND_USER            FU
WHERE   FR.APPLICATION_ID   =   FRT.APPLICATION_ID
AND     FR.RESPONSIBILITY_ID=   FRT.RESPONSIBILITY_ID
AND     FA.APPLICATION_ID   =   FR.APPLICATION_ID
AND     FA.APPLICATION_ID   =   FAT.APPLICATION_ID
AND     FUR.RESPONSIBILITY_ID=  FR.RESPONSIBILITY_ID
AND     FUR.USER_ID         =   FU.USER_ID
AND     FU.USER_NAME        =   UPPER(NVL(:USER_NAME,FU.USER_NAME))  --'PO'
AND     EMPLOYEE_ID  IS NOT NULL

How to add the Additional Columns in a Value Set

System Administrator ->Application -> Validation ->Set

How to Find Custom Concurrent Program Name in a Single Query

SELECT a.cpname, a.UCPNAME, a.param, f.FLEX_VALUE_SET_NAME FROM
(
select V.CONCURRENT_PROGRAM_NAME CPNAME, V.USER_CONCURRENT_PROGRAM_NAME UCPNAME, nvl(VC.END_USER_COLUMN_NAME,'NULL PARAM') param,
NVL(vc.FLEX_VALUE_SET_ID,0) valueset
from FND_CONCURRENT_PROGRAMS_VL v,
FND_DESCR_FLEX_COL_USAGE_VL VC
where V.USER_CONCURRENT_PROGRAM_NAME like 'XX%' AND V.APPLICATION_ID = VC.APPLICATION_ID(+)
AND VC.DESCRIPTIVE_FLEXFIELD_NAME(+) = '$SRS$.'||V.CONCURRENT_PROGRAM_NAME
) a,
fnd_flex_value_sets f
where a.valueset = f.flex_value_set_id(+)