How to use script to get all Oracle EBS Concurrent Program/Report name and corresponding execution f-优快云博客

本文介绍了如何使用脚本查询所有Oracle EBS并发程序及其对应的执行文件名。通过查询fnd_lookup_values表，可以获取到不同类型的并发程序（如PL/SQL、Oracle Reports等）。示例输出展示了库存模块的部分结果。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

How to use script to get all Oracle EBS Concurrent Program/Report name and corresponding execution file name

SELECT fcp.concurrent_program_name,fcpt.user_concurrent_program_name,fcp.EXECUTION_METHOD_CODE,flv.meaning   
FROM FND_CONCURRENT_PROGRAMS fcp,FND_CONCURRENT_PROGRAMS_TL fcpt,fnd_lookup_values flv 
WHERE fcp.CONCURRENT_PROGRAM_ID = fcpt.CONCURRENT_PROGRAM_ID
AND flv.lookup_type = 'CP_EXECUTION_METHOD_CODE'   
AND fcp.EXECUTION_METHOD_CODE = flv.lookup_code 
AND fcpt.LANGUAGE = 'US'
AND flv.LANGUAGE = 'US'
AND fcp.application_id = 401 --Inventory Module 
ORDER BY fcpt.user_concurrent_program_name;

NOTE1:使用 SELECT * FROM fnd_application来查找模块的application_id

NOTE2: Concurrent Program TYPE(PL/SQL,Oracle Reports...)
SELECT lookup_code,meaning
FROM fnd_lookup_values
WHERE lookup_type = 'CP_EXECUTION_METHOD_CODE'
AND LANGUAGE = 'US'
ORDER BY lookup_code;

Sample Output(Inventory Module)

CONCURRENT_PROGRAM_NAME	USER_CONCURRENT_PROGRAM_NAME	MEANING
INVTRREG	@Tax Preference Report	Oracle Reports
INVARAAS	ABC assignments report	Oracle Reports
INVARAAS_XML	ABC assignments report (XML)	Java Concurrent Program
INVARADV	ABC descending value report	Oracle Reports
INVARADV_XML	ABC descending value report (XML)	Java Concurrent Program
INVSRAAL	Account alias listing	Oracle Reports
INVSRAAL_XML	Account alias listing (XML)	Java Concurrent Program
INVUPMST	Activate Onhand Level Material Status Tracking	PL/SQL Stored Procedure
INVLOTAG	Age Update For Lot Attributes	PL/SQL Stored Procedure
INV3PLBILLINGUNITS	Calculate Billing Units	PL/SQL Stored Procedure
MRPATPRS	Calculate Resource Supply for ATP	PL/SQL Stored Procedure
INVCPCLOS	Close Period Control	PL/SQL Stored Procedure
INCAAC	Compile ABC analysis	Spawned
INCFIF	Compile item forecast	Spawned
INVCCIDP	Consigned Inventory Diagnostics	PL/SQL Stored Procedure
INV_CONSOLIDATE_ONHAND	Consolidate Inventory Onhand Quantites	PL/SQL Stored Procedure
INVISCOR	Copy Inventory Organization	Java Concurrent Program
INVISCORP	Copy Inventory Organization Interface Data Purge	PL/SQL Stored Procedure
INVCORPP	Copy Inventory Organization Report Data Purge	PL/SQL Stored Procedure
INVCGUGB	Costgroup upgrade for closed periods	PL/SQL Stored Procedure
INVCTXNM	Create Consumption Advice	PL/SQL Stored Procedure
INVCTXCW	Create Consumption Advice Worker	PL/SQL Stored Procedure
INV_CREATE_DEF_TXNS	Create Deferred Logical Transactions	PL/SQL Stored Procedure
INCIAP	Create Intercompany AP Invoices	Spawned
INCIAR	Create Intercompany AR Invoices	Spawned
INCIDV	Create item flexfield view	Spawned
INVIRCOC	Customer Item Commodity Codes Listing	Oracle Reports
INVIRCOC_XML	Customer Item Commodity Codes Listing (XML)	Java Concurrent Program
INVIRCXR	Customer Item Cross References Report	Oracle Reports
INVIRCXR_XML	Customer Item Cross References Report (XML)	Java Concurrent Program
INVIRCIT	Customer Items Report	Oracle Reports
INVIRCIT_XML	Customer Items Report (XML)	Java Concurrent Program
MTL_CCEOI_WORKER	Cycle Count Entries Open Interface Worker	PL/SQL Stored Procedure
INVARCTA	Cycle count entries and adjustments report	Oracle Reports
INVARCTA_XML	Cycle count entries and adjustments report (XML)	Java Concurrent Program
INVARHMA	Cycle count hit/miss analysis	Oracle Reports
INVARHMA_XML	Cycle count hit/miss analysis (XML)	Java Concurrent Program
INVARCLI	Cycle count listing	Oracle Reports
INVARCLI_XML	Cycle count listing (XML)	Java Concurrent Program
INVARORE	Cycle count open requests listing	Oracle Reports
INVARORE_XML	Cycle count open requests listing (XML)	Java Concurrent Program