Panaya extracts only non-standard Oracle E-Business Suite technical objects and does not extract any customer or transactional data (e.g. Orders, Accounts and Financial Records). The objects that Panaya extracts are described in the following table.
|
Object |
Extraction Details |
|
Views & Materialized Views |
View name Schema View Source |
|
Tables |
Table Name and Module (Only collected for R12.2 and higher) |
|
Triggers |
Trigger name Schema Trigger Source |
|
Alerts |
Alert name Alert query Alert actions Alert usage |
|
Value Set |
Value set name Application Value set query |
|
PL/SQL Sources |
Package Package body Procedure Function For each component: Name Schema Code |
|
Patch Installation Information |
Installed patches AD file list AD file version list |
|
Synonym |
Name Schema Synonym target |
|
Custom.pll |
Custom.pll & Attached libraries |
|
Personalization |
Name Conditions Actions |
|
Concurrent Program |
Name Application Executable Parameters |
|
Concurrent Reports |
Name Application Executable Parameters |
|
Workflows |
Name Activities |
|
Forms (FMB) |
Name Language Code Module |
|
Reports (RDF) |
Name Language Code Module |
|
Discover Objects |
Folders Functions Documents Usage |
|
Usage |
Forms – Audit logging from the following tables: APPLSYS.FND_LOGINS, APPLSYS.FND_LOGIN_RESPONSIBILITIES APPLSYS.FND_LOGIN_RESP_FORMS
Concurrents – The Concurrent Manager (e.g. Table FND_CONCURRENT_REQUESTS)
Discoverer – Discoverer Usage Table (e.g. Table EUL5_QPP_STATS for Disco 5)
Alerts – Alert Monitoring from the following tables: ALR_ALERT_CHECKS, ALR_ALERTS
Workflows - from the following tables: WF_ITEMS
Framework - from the following tables: APPLSYS.FND_LOGINS, APPLSYS.FND_LOGIN_RESPONSIBILITIES,
APPLSYS.FND_LOGIN_RESP_FORMS Note By default, Framework audit data is not collected. To activate the tracking, follow the instructions from the Oracle Support Website o Page Access Tracking in Oracle Applications 11i [ID 278881.1] o Page Access Tracking in Oracle Applications Release 12 [ID 402116.1] Panaya also collects data on active menus and responsibilities to validate usage data |
|
Framework |
Function name Function Language Function web_html_call Code (Class) XML for View Objects and Entity Objects |
|
Profile |
Schema Name Language SQL Validation |
|
Fast Formula |
Name Formula Code |
|
Scripts |
Shell Scripts Host Scripts Note Only scripts registered to concurrent programs will be collected |