A killer “Auto Refresh” option on Concurrent Request Window – New Features to Concurrent Form

Oracle is coming up with some exciting features on “Concurrent Request” form in upcoming EBS 12.2.6 release. 
As per a discussion on MOS, An Oracle user Attiq Ahmed has suggested Oracle to implement some features on “Concurrent Request” form and looks like Oracle has considered these ideas and implemented them in their next release

1 Auto Refresh 
2 Rerun Selected 
3 Request Copy 
4 Request Submit a New Request
5 and Submit a New Request Set Buttons

This new feature will save millions of mouse clicks 







Source: My Oracle Support Community (MOSC)

Auto Refresh” feature is really awesome and much needed one

XXX is not a valid responsibility for the current user. Please contact your System Administrator.

How to Resolved XXX  is not a valid responsibility for the current user. Please contact your System Administrator.

Some time it happens that we assign a new web based responsibility like isupplier or iprocurement but when opening it display following screenshot.

This is happening because middle tiers has yet to pick the change in assigned responsibility. To resolve this issue we need to clear the middle tier cache.

Navigate to Functional administrator>Core Service >Caching Framework > Global Configuration

Click on Clear All Cache

A warning message will displayed. Click Yes

Confirmation will be displayed. Now if you navigate to iProcurement responsibility.

It will open without error

INV usefull Query

SELECT MSIK.CONCATENATED_SEGMENTS ITEM_NAME,
    POL.ITEM_DESCRIPTION,
    POH.SEGMENT1 PO_NUMBER,
    POR.RELEASE_NUM,
    POL.LINE_NUM PO_LINE_NUM,
    POLL.SHIPMENT_NUM,
    POD.DISTRIBUTION_NUM,
    RSH.RECEIPT_NUM,
    RAE.PRIMARY_QUANTITY,
    POV.VENDOR_NAME,
    MP.ORGANIZATION_CODE,
    RAE.TRANSACTION_DATE,
    NVL(RT.TRANSACTION_TYPE, DECODE(RAE.EVENT_TYPE_ID, 14, 'PERIOD END ACCRUAL')) RCV_TXN_TYPE ,
    RAE.RCV_TRANSACTION_ID TRANSACTION_ID,
    RAE.ORGANIZATION_ID ,
    RAE.ACCOUNTING_EVENT_ID ,
    RAE.PRIMARY_UNIT_OF_MEASURE
  FROM RCV_TRANSACTIONS RT,
    RCV_SHIPMENT_HEADERS RSH,
    PO_VENDORS POV,
    PO_HEADERS_ALL POH,
    PO_LINES_ALL POL,
    PO_LINE_LOCATIONS_ALL POLL,
    PO_DISTRIBUTIONS_ALL POD,
    PO_RELEASES_ALL POR,
    MTL_SYSTEM_ITEMS_KFV MSIK,
    RCV_ACCOUNTING_EVENTS RAE,
    MTL_PARAMETERS MP
  WHERE RAE.PO_HEADER_ID        = POH.PO_HEADER_ID
  AND RAE.PO_LINE_ID            = POL.PO_LINE_ID
  AND RAE.PO_LINE_LOCATION_ID   = POLL.LINE_LOCATION_ID
  AND RAE.PO_DISTRIBUTION_ID    = POD.PO_DISTRIBUTION_ID
  AND RAE.PO_RELEASE_ID         = POR.PO_RELEASE_ID(+)
  AND POH.VENDOR_ID             = POV.VENDOR_ID
  AND RT.SHIPMENT_HEADER_ID     = RSH.SHIPMENT_HEADER_ID(+)
  AND RAE.RCV_TRANSACTION_ID    = RT.TRANSACTION_ID(+)
  AND MSIK.ORGANIZATION_ID(+)   = RAE.ORGANIZATION_ID
  AND MSIK.INVENTORY_ITEM_ID(+) = RAE.INVENTORY_ITEM_ID
  AND MP.ORGANIZATION_ID        = RAE.ORGANIZATION_ID;

SQL Query to findout Executable, Concurrent Program and its Parameters information

SELECT DISTINCT fcpl.user_concurrent_program_name "Concurrent Program Name",
  fcp.concurrent_program_name "Short Name"                                 ,
  fat.application_name                                                     ,
  fl.meaning execution_method                                              ,
  fe.execution_file_name                                                   ,
  fcp.output_file_type                                                     ,
  fdfcuv.column_seq_num "Column Seq Number"                                ,
  fdfcuv.end_user_column_name "Parameter Name"                             ,
  fdfcuv.form_left_prompt "Prompt"                                         ,
  fdfcuv.enabled_flag " Enabled Flag"                                      ,
  fdfcuv.required_flag "Required Flag"                                     ,
  fdfcuv.display_flag "Display Flag"                                       ,
  fdfcuv.flex_value_set_id "Value Set Id"                                  ,
  ffvs.flex_value_set_name "Value Set Name"                                ,
  flv.meaning "Default Type"                                               ,
  fdfcuv.default_value "Default Value"
   FROM fnd_concurrent_programs fcp ,
  fnd_concurrent_programs_tl fcpl   ,
  fnd_descr_flex_col_usage_vl fdfcuv,
  fnd_flex_value_sets ffvs          ,
  fnd_lookup_values flv             ,
  fnd_lookups fl                    ,
  fnd_executables fe                ,
  fnd_executables_tl fet            ,
  fnd_application_tl fat
  WHERE 1                     = 1
AND fcp.concurrent_program_id = fcpl.concurrent_program_id
AND fcp.enabled_flag          = 'Y'
AND fcpl.user_concurrent_program_name LIKE 'Account Analysis Report' --<Your Concurrent Program Name>
AND fdfcuv.descriptive_flexfield_name = '$SRS$.'
  || fcp.concurrent_program_name
AND ffvs.flex_value_set_id = fdfcuv.flex_value_set_id
AND flv.lookup_type(+)     = 'FLEX_DEFAULT_TYPE'
AND flv.lookup_code(+)     = fdfcuv.default_type
AND fcpl.LANGUAGE          = 'US'
AND flv.LANGUAGE(+)        = 'US'
AND fl.lookup_type         ='CP_EXECUTION_METHOD_CODE'
AND fl.lookup_code         =fcp.execution_method_code
AND fe.executable_id       = fcp.executable_id
AND fe.executable_id       =fet.executable_id
AND fet.LANGUAGE           = 'US'
AND fat.application_id     =fcp.application_id
AND FAT.LANGUAGE           = 'US'
ORDER BY fdfcuv.column_seq_num;

Query to find EXEcutable name from concurrent program name

SELECT FNDCON.USER_CONCURRENT_FNDCONRAM_NAME "program name",
  FNDCON.CONCURRENT_FNDCONRAM_NAME "program short name",
  FNDA.applICATION_NAME "programram application name",
  FNDCON.DESCRIPTION "program description",
  FNDEX.FNDEXCUTABLE_NAME "FNDEXcutable name",
  FNDEX.FNDEXCUTION_FILE_NAME "FNDEXcutable file name",
  DECODE( FNDEX.FNDEXCUTION_METHOD_CODE, 'I', 'PLSQL Stored Procedure', 'P', 'Report', 'L', 'SQL Loader','Q','SQL*Plus', FNDEX.FNDEXCUTION_METHOD_CODE) "FNDEXcution method"
FROM FND_FNDEXCUTABLES FNDEX,
  FND_FNDAICATION_TL FNDA,
  FND_CONCURRENT_PROGRAMS_VL FNDCON
WHERE FNDEX.FNDAICATION_ID = FNDA.FNDAICATION_ID
AND FNDEX.FNDEXCUTABLE_ID  = FNDCON.FNDEXCUTABLE_ID
AND FNDA.LANGUAGE          ='US'
AND FNDCON.USER_CONCURRENT_PROGRAM_NAME LIKE 'Amway Account Analysis Report';

Shipping Networks Query R12

SELECT
    MP1.ORGANIZATION_CODE FROM_ORGANIZATION_CODE ,
    HOU1.NAME FROM_ORGANIZATION_NAME ,
    MP1.INTERORG_TRNSFR_CHARGE_PERCENT FROM_CHARGE_PERCENT_DUMMY ,
    MP2.ORGANIZATION_CODE TO_ORGANIZATION_CODE ,
    HOU2.NAME TO_ORGANIZATION_NAME ,
    NET.FROM_ORGANIZATION_ID ,
    NET.TO_ORGANIZATION_ID ,
    --NET.INTRANSIT_INV_ACCOUNT ,
    (select GCC.SEGMENT1||'-'||GCC.SEGMENT2||'-'||GCC.SEGMENT3||'-'||GCC.SEGMENT4||'-'||GCC.SEGMENT5||'-'||GCC.SEGMENT6
       ||'-'||GCC.SEGMENT7||'-'||GCC.SEGMENT8 "ACCOUNT COMBINATION" from GL_CODE_COMBINATIONS GCC where GCC.CODE_COMBINATION_ID = NET.INTRANSIT_INV_ACCOUNT )INTRANSIT_INV_ACCOUNT,
    --NET.INTERORG_TRANSFER_CR_ACCOUNT ,
     (select GCC.SEGMENT1||'-'||GCC.SEGMENT2||'-'||GCC.SEGMENT3||'-'||GCC.SEGMENT4||'-'||GCC.SEGMENT5||'-'||GCC.SEGMENT6
       ||'-'||GCC.SEGMENT7||'-'||GCC.SEGMENT8 "ACCOUNT COMBINATION" from GL_CODE_COMBINATIONS GCC where GCC.CODE_COMBINATION_ID = NET.INTERORG_TRANSFER_CR_ACCOUNT  )INTERORG_TRANSFER_CR_ACCOUNT ,
    --NET.INTERORG_RECEIVABLES_ACCOUNT ,
     (select GCC.SEGMENT1||'-'||GCC.SEGMENT2||'-'||GCC.SEGMENT3||'-'||GCC.SEGMENT4||'-'||GCC.SEGMENT5||'-'||GCC.SEGMENT6
       ||'-'||GCC.SEGMENT7||'-'||GCC.SEGMENT8 "ACCOUNT COMBINATION" from GL_CODE_COMBINATIONS GCC where GCC.CODE_COMBINATION_ID = NET.INTERORG_RECEIVABLES_ACCOUNT )INTERORG_RECEIVABLES_ACCOUNT,
     
   -- NET.INTERORG_PAYABLES_ACCOUNT ,
    (select GCC.SEGMENT1||'-'||GCC.SEGMENT2||'-'||GCC.SEGMENT3||'-'||GCC.SEGMENT4||'-'||GCC.SEGMENT5||'-'||GCC.SEGMENT6
       ||'-'||GCC.SEGMENT7||'-'||GCC.SEGMENT8 "ACCOUNT COMBINATION" from GL_CODE_COMBINATIONS GCC where GCC.CODE_COMBINATION_ID = NET.INTERORG_PAYABLES_ACCOUNT )INTERORG_PAYABLES_ACCOUN,
   -- NET.INTERORG_PRICE_VAR_ACCOUNT
    (select GCC.SEGMENT1||'-'||GCC.SEGMENT2||'-'||GCC.SEGMENT3||'-'||GCC.SEGMENT4||'-'||GCC.SEGMENT5||'-'||GCC.SEGMENT6
       ||'-'||GCC.SEGMENT7||'-'||GCC.SEGMENT8 "ACCOUNT COMBINATION" from GL_CODE_COMBINATIONS GCC where GCC.CODE_COMBINATION_ID = NET.INTERORG_PRICE_VAR_ACCOUNT )INTERORG_PRICE_VAR_ACCOUNT
    FROM MTL_PARAMETERS MP1,
    MTL_PARAMETERS MP2,
    HR_ORGANIZATION_UNITS HOU1,
    HR_ORGANIZATION_UNITS HOU2,
    MTL_INTERORG_PARAMETERS NET
  WHERE MP1.ORGANIZATION_ID = NET.FROM_ORGANIZATION_ID
  AND MP2.ORGANIZATION_ID   = NET.TO_ORGANIZATION_ID
  and HOU1.ORGANIZATION_ID  = MP1.ORGANIZATION_ID
  and HOU2.ORGANIZATION_ID  = MP2.ORGANIZATION_ID;