Oracle iAssets Tables
Oracle iAssets – List of database tables:
- IA_REQUEST_DETAILS
- IA_REQUEST_HEADERS
- IA_RULE_DETAILS
- IA_RULE_HEADERS
Oracle iAssets – List of database tables:
Oracle Assets and iAssets Profile Options:
PROFILE OPTION SHORT CODE | PROFILE OPTION NAME |
IA_SELF_SERVICE_RULE_ID | IA: iAssets Rule ID |
IA_SYSTEM_ADMINISTRATOR_NAME | IA: iAssets System Administrator |
IA_PRINT_DEBUG | IA: Print Debug |
IA_SELF_SERVICE_RULE_NAME | IA: iAssets Rule Name |
FA_JAPAN_TAX_REFORMS | FA: Japan 2007 Tax Reforms Features |
FA_DEBUG_FILE | FA: Debug Filename |
FA_TAX_ASSET_TYPE_SEGMENT | FA: Tax Asset Type Category Segment for Japanese Depreciable Asset Tax Report |
FA_WF_GENERATE_CCIDS | FA: Use Workflow Account Generation |
FA_BATCH_SIZE | FA: Batch Size |
FA_CUSTOM_GEN_CCID | FA: Custom Generate CCID |
FA_ENABLED_DEPRN_BASIS_FORMULA | FA: Enable Depreciable Basis Rule |
FA_DEPRN_OVERRIDE_ENABLED | FA: Enable Depreciation Override |
FADI_ASSET_CREATION_PRIVS | FADI: Create Assets Privileges |
FADI_ASSET_PI_PRIVS | FADI: Physical Inventory Privileges |
FA_ANNUAL_ROUND | FA: Annual Rounding |
FA_INCLUDE_NONRECOV_TAX_MASSADDS | FA: Include Nonrecoverable Tax in Mass Addition |
FA_PREGEN_ASSET_ACCOUNT | FA: Generate Asset Level Account |
FA_PREGEN_BOOK_ACCOUNT | FA: Generate Book Level Accounts |
FA_PREGEN_CAT_ACCOUNT | FA: Generate Category Level Accounts |
FA_DEFAULT_DPIS_TO_INV_DATE | FA: Default DPIS to Invoice Date |
FA_MCP_ALL_COST_ADJ | FA: Mass Copy All Cost Adjustments |
FA_ARCHIVE_TABLE_SIZE | FA: Archive Table Sizing Factor |
FA_CACHE_USAGE | FA: Cache Sizing Factor |
FA_DEPRN_SINGLE | FA: Deprn Single |
FA_GEN_EXPENSE_ACCOUNT | FA:Generate Depreciation Expense Account |
FA_INS_SWISS_BUILDING | FA: Allow Swiss special assets |
FA_LARGE_ROLLBACK_SEGMENT | FA: Large Rollback Segment Name |
FA_NUM_GENACCTS_REQUESTS | FA: Number of Generate Accounts Parallel Requests |
FA_NUM_MASSADD_PAR_REQUESTS | FA: Number Mass Addition Parallel Requests |
FA_NUM_PARALLEL_REQUESTS | FA: Number of Parallel Requests |
FA_SECURITY_PROFILE_ID | FA: Security Profile |
FA_USE_THRESHOLD | FA: Use Threshold |
PRINT_DEBUG | FA: Print Debug |
TIME_DIAGNOSTIC | FA: Print Timing Diagnostics |
FA_PROJ_MAX_EXTENT | FA: Maximum Projection Extent |
Oracle iAssets Module DFF List
DFF View | DFF CODE NAME | DFF name |
IA_REQUEST_HEADERS_DFV | IA_REQUEST_HEADERS | IA Request Headers |
IA_REQUEST_DETAILS_DFV | IA_REQUEST_DETAILS | IA Request Details |