Script Like:
SELECT SUBSTR(B.APPLICATION_SHORT_NAME,1,11) "APPLICATION",
SUBSTR(A.USER_CONCURRENT_PROGRAM_NAME,1,50) "CONCURRENT PROGRAM NAME",
SUBSTR(A.CONCURRENT_PROGRAM_NAME,1,35) "SHORT NAME"
FROM APPS.FND_CONCURRENT_PROGRAMS_VL A, APPS.FND_APPLICATION_VL B
WHERE A.APPLICATION_ID=B.APPLICATION_ID
AND A.ENABLED_FLAG='Y'
AND (Upper(A.USER_CONCURRENT_PROGRAM_NAME) LIKE Upper('%purge%')
OR Upper(A.USER_CONCURRENT_PROGRAM_NAME) LIKE Upper('%delete%'))
ORDER BY B.APPLICATION_SHORT_NAME;
Output of Some Module
| APPLICATION | CONCURRENT PROGRAM NAME | SHORT NAME |
|---|---|---|
| FND | Purge Signon Audit data | FNDSCPRG |
| FND | Purge Obsolete SOA Monitor Data | FNDSOA_PURGE |
| FND | Purge Inactive Sessions | FNDDLTMP |
| FND | Purge Workflow Provisioning Runtime Data | FNDWFPRVPR |
| FND | Purge Web Service Audit Data | OAMSOAPPUR |
| FND | Purge Obsolete ECX Data | FNDECXPR |
| FND | Delete Diagnostic Statistics | DELDIAGSTAT |
| FND | Delete Diagnostic Logs | DELDIAGLOG |
| FND | Purge FND_STATS History Records | FNDPGHST |
| FND | Purge Concurrent Processing setup data for cloning | FNDCPCLN |
| FND | Purge Rule Executions | FNDDWPURG |
| FND | Purge Logs and Closed System Alerts | FNDLGPRG |
| FND | Purge Obsolete Generic File Manager Data | FNDGFMPR |
| FND | Purge Obsolete Workflow Runtime Data | FNDWFPR |
| FND | Purge Concurrent Request and/or Manager Data | FNDCPPUR |
| INV | Inventory Position Purge | INVGIPPG |
| INV | Purge cycle count entries open interface | MTL_CCEOI_PURGE |
| INV | Purge transaction history | INCTPG |
| INV | Purge cycle count information | INCACP |
| INV | Purge replenishment counts | INCRPG |
| INV | Purge physical inventory information | INCAPP |
| INV | Delete items report | BOMRDDEL |
| INV | Transaction Purge | INVTMLPR |
| INV | Delete Items Report GUI | BOMRDDELG |
| INV | Delete items report (XML) | BOMRDDEL_XML |
| INV | Global Transaction Purge | INVGTPG |
| INV | Copy Inventory Organization Interface Data Purge | INVISCORP |
| INV | Move Order Purge | INVMOPG |
| INV | High Volume Transaction Purge | INVHVTPG |
| INV | Transaction Purge Worker | INVTPGWB |
| INV | Inventory Position Purge All | INVGIPPA |
| INV | Delete Items Report GUI (XML) | BOMRDDELG_XML |
| INV | Copy Inventory Organization Report Data Purge | INVCORPP |
| INV | Purge ABC information | INCAAP |
| ONT | Purge Secured Payment Data - Worker | ONTIBYCN_WKR |
| ONT | Purge Retrobilling Requests | OERETPUR |
| ONT | Purge Advanced Item Search Session Data | OEXADPRB |
| ONT | Quote Purge Selection | GENPSETQTEWHERE |
| ONT | Purge Order Management Workflow | OEXPWF |
| ONT | Purge Imported Credit Exposure | OEXCEPRG |
| ONT | ADS Purge Order Transactions | ADS_TRANS_PURGE |
| ONT | Purge Open Interface Data | OEXOIPCP |
| ONT | Message Purge | OEMPRG |
| ONT | Create Purge Set | GENPSET |
| ONT | Purge Secured Payment Data | ONTIBYCN_MGR |
| ONT | Order Purge | ORDPUR |
| ONT | Order Purge Selection | GENPSETWHERE |
| PO | Purge Purchasing Open Interface Processed Data | POXPOIPR |
| PO | Purge System Saved Requisition | POXSSPG |
| WIP | WIP Purge | WIPPURGE |
| WIP | WIP Purge (XML) | WIPPURGE_XML |
| WMS | Purge Labor Transactions | WMS_LMS_PURGE_TXNS |
| WMS | Purge WMS History Tables | PURGE_WMS |
| WMS | Purge Labor Setup History Records | WMS_LMS_PURGE_SETUP_HISTORY |
本文列举了Oracle系统中用于清除过期或不再需要的数据的各种实用程序名称及其简要描述。这些程序涵盖了不同模块如财务、库存管理和工作流等,旨在帮助管理员维护数据库的健康状态。
1291

被折叠的 条评论
为什么被折叠?



