Prog_Req_Grp_Reg LDT

Program To register a report on a request Group through LDT-

FNDLOAD apps/xxx123 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct <our required req group ldt name>.ldt REQUEST_GROUP REQUEST_GROUP_NAME='<request group name>' APPLICATION_SHORT_NAME='<request group application short name>' REQUEST_GROUP_UNIT UNIT_APP='<concurrent program application short name>' UNIT_TYPE='P' UNIT_NAME='<concurrent program short name>'

Ex.

FNDLOAD apps/app8002s0tst O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XXES_JAI_OrderMgmt_RG.ldt REQUEST_GROUP REQUEST_GROUP_NAME='JAI_OrderMgmt_RG' APPLICATION_SHORT_NAME='JA' REQUEST_GROUP_UNIT UNIT_APP='XXES' UNIT_TYPE='P' UNIT_NAME='XXES_OWD_FRT_GRN_SUMMARY'

To Find Highlighted ‘request group application short name’ use this program-

SELECT cpt.user_concurrent_program_name     "Concurrent Program Name",

       DECODE(rgu.request_unit_type,

              'P', 'Program',

              'S', 'Set',

              rgu.request_unit_type)        "Unit Type",

       cp.concurrent_program_name           "Concurrent Program Short Name",

       rg.application_id                    "Application ID",

       rg.request_group_name                "Request Group Name",

       fat.application_name                 "Application Name",

       fa.application_short_name            "Application Short Name",

       fa.basepath                          "Basepath"

FROM   fnd_request_groups          rg,

       fnd_request_group_units     rgu,

       fnd_concurrent_programs     cp,

       fnd_concurrent_programs_tl  cpt,

       fnd_application             fa,

       fnd_application_tl          fat

WHERE  rg.request_group_id       =  rgu.request_group_id

   AND rgu.request_unit_id       =  cp.concurrent_program_id

   AND cp.concurrent_program_id  =  cpt.concurrent_program_id

   AND rg.application_id         =  fat.application_id

   AND fa.application_id         =  fat.application_id

   AND cpt.language              =  USERENV('LANG')

   AND fat.language              =  USERENV('LANG')

   AND cpt.user_concurrent_program_name = :Concurrent_program_name

To Upload  LDT File use Program:-

FNDLOAD apps/xxx123 O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct < ldt name>.ldt

Ex.         FNDLOAD apps/app8002s0tst O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XXES_JAI_OrderMgmt_RG.ldt