Excel sheets for extracting data from Oracle Applications
Receiveables
This excel has sql’s for AR tables:
ar_customers_v FND_TERRITORIES FND_TERRITORIES_VL HZ_PARTIES HZ_PARTY_SITE_USES HZ_PARTY_SITES HZ_PARTY_SITES_V RA_CUST_TRX_LINE_GL_DIST_ALL RA_CUST_TRX_LINE_SALESREPS_ALL RA_CUSTOMER_TRX_LINES_V RA_CUSTOMER_TRX_V RA_INTERFACE_LINES_ALL
Pls. edit the where clause for your need.
Download: Receivables - posted 06-05-2010
Profile option values
This excel will extract all profile option values. Pls. edit the where clause for your need.
Download: fnd_profile_option_values - posted 06-05-2010
| PROFILE_OPTION_NAME | HIERARCHY_TYPE | LEVEL_NAME | LEVEL_VALUE_NAME | PROFILE_OPTION_VALUE | LAST_UPDATE_DATE | LAST_UPDATED_BY |
| ABM_HELP_ABMA | SECURITY | SITE | /OA_DOC/abmaug1110.pdf | 26-04-2001 | AUTOINSTALL | |
| ABM_HELP_CORE_ABM | SECURITY | SITE | /OA_DOC/abmug1110.pdf | 26-04-2001 | AUTOINSTALL | |
| ABM_HELP_SEMX | SECURITY | SITE | /OA_DOC/semxug1110.pdf | 26-04-2001 | AUTOINSTALL | |
| ABM_JAVA_CURRENCY_FORMAT | SECURITY | SITE | ##,###,###,##0.00000 | 26-04-2001 | AUTOINSTALL | |
| ABM_JAVA_DATE_FORMAT | SECURITY | SITE | dd-MMM-yyyy | 26-04-2001 | AUTOINSTALL | |
| ABM_JAVA_DATE_TIME_FORMAT | SECURITY | SITE | dd-MMM-yyyy hh:mm:ss | 26-04-2001 | AUTOINSTALL | |
| ABM_JAVA_NUMERIC_FORMAT | SECURITY | SITE | ##,###,###,##0.##### | 26-04-2001 | AUTOINSTALL | |
| ABM_ORB_GATEKEEPER_IOR | SECURITY | SITE | http://myserver.mycompany.com:15010/gatekeeper.ior | 26-04-2001 | AUTOINSTALL | |
| ABM_REMOTE_HOST | SECURITY | SITE | myserver.mycompany.com | 26-04-2001 | AUTOINSTALL | |
| ABM_REMOTE_PORT | SECURITY | SITE | 15010 | 17-07-2000 | AUTOINSTALL |