| APPS_ARRAY_DDL |
| APPS_ARRAY_DDL |
| APPS_DDL |
| APPS_DDL |
| FASTATS_TABLE |
| FASTATS_TABLE |
| FA_ACE_BOOKS |
| FA_ADDITIONS_B |
| FA_ADDITIONS_TL |
| FA_ADDITION_REP_ITF |
| FA_ADD_WARRANTIES |
| FA_ADJUSTMENTS |
| FA_ADJUST_REP_ITF |
| FA_AMORT_SCHEDULES |
| FA_ARCHIVE_HISTORY |
| FA_ASSET_FAILURES_GT |
| FA_ASSET_HIERARCHY |
| FA_ASSET_HIERARCHY_PURPOSE |
| FA_ASSET_HIERARCHY_VALUES |
| FA_ASSET_HISTORY |
| FA_ASSET_INVOICES |
| FA_ASSET_KEYWORDS |
| FA_ASSET_LISTING_REP_ITF |
| FA_BALANCES_REPORT |
| FA_BALANCES_REPORT_GT |
| FA_BALANCES_REP_ITF |
| FA_BONUS_RATES |
| FA_BONUS_RULES |
| FA_BOOKS |
| FA_BOOKS_GROUPS |
| FA_BOOKS_SUMMARY |
| FA_BOOK_CONTROLS |
| FA_BOOK_CONTROLS_HISTORY |
| FA_BUDGET_DISTRIBUTION |
| FA_BUDGET_INTERFACE |
| FA_CALENDAR_PERIODS |
| FA_CALENDAR_TYPES |
| FA_CAPITAL_BUDGET |
| FA_CAP_REP_ITF |
| FA_CATEGORIES_B |
| FA_CATEGORIES_TL |
| FA_CATEGORY_BOOKS |
| FA_CATEGORY_BOOK_DEFAULTS |
| FA_CEILINGS |
| FA_CEILING_TYPES |
| FA_CONVENTIONS |
| FA_CONVENTION_TYPES |
| FA_COSTCLEAR_REP_ITF |
| FA_DEFERRED_DEPRN |
| FA_DELETED_MASS_ADDITIONS |
| FA_DEPRN_BASIS_RULES |
| FA_DEPRN_DETAIL |
| FA_DEPRN_OVERRIDE |
| FA_DEPRN_PERIODS |
| FA_DEPRN_REP_ITF |
| FA_DEPRN_RULE_DETAILS |
| FA_DEPRN_SUMMARY |
| FA_DEPRN_TAX_REP_ITF |
| FA_DISTRIBUTION_ACCOUNTS |
| FA_DISTRIBUTION_DEFAULTS |
| FA_DISTRIBUTION_HISTORY |
| FA_DISTRIBUTION_SETS |
| FA_EXCLUDE_HIERARCHY_LEVELS |
| FA_EXT_INV_RETIREMENTS |
| FA_FISCAL_YEAR |
| FA_FLAT_RATES |
| FA_FORMULAS |
| FA_GROUP_ASSETS |
| FA_GROUP_ASSET_DEFAULT |
| FA_GROUP_ASSET_RULES |
| FA_GROUP_DEPRN_DETAIL |
| FA_GROUP_DEPRN_RATES |
| FA_GROUP_DEPRN_SUMMARY |
| FA_GROUP_REP_ITF |
| FA_HIERARCHY_CONTROLS |
| FA_HIERARCHY_DISTRIBUTIONS |
| FA_HIERARCHY_RULE_DETAILS |
| FA_HIERARCHY_RULE_SET |
| FA_HR_RETIREMENT_DETAILS |
| FA_HR_RETIREMENT_HEADERS |
| FA_INQUIRY_TRX_GT |
| FA_INS_LINES |
| FA_INS_MST_POLS |
| FA_INS_POLICIES |
| FA_INS_VALUES |
| FA_INVENTORY |
| FA_INVMISS_REP_ITF |
| FA_INVOICE_TRANSACTIONS |
| FA_INV_COMPARE_REP_ITF |
| FA_INV_INTERFACE |
| FA_ITC_RATES |
| FA_ITC_RECAPTURE_RATES |
| FA_JOURNAL_ENTRIES |
| FA_JOURNAL_ENTRIES_S1 |
| FA_LEASES |
| FA_LEASE_PAYMENTS |
| FA_LEASE_PAYMENT_ITEMS |
| FA_LEASE_SCHEDULES |
| FA_LIFE_DERIVATION_INFO |
| FA_LOCATIONS |
| FA_LOOKUPS_B |
| FA_LOOKUPS_TL |
| FA_LOOKUP_TYPES_B |
| FA_LOOKUP_TYPES_TL |
| FA_MAINT_EVENTS |
| FA_MAINT_REP_ITF |
| FA_MAINT_SCHEDULE_DTL |
| FA_MAINT_SCHEDULE_HDR |
| FA_MASSADD_DISTRIBUTIONS |
| FA_MASSADD_REP_ITF |
| FA_MASS_ADDITIONS |
| FA_MASS_CHANGES |
| FA_MASS_CHANGES_ITF |
| FA_MASS_EXTERNAL_TRANSFERS |
| FA_MASS_EXT_RETIREMENTS |
| FA_MASS_EXT_RET_EXCEPTS |
| FA_MASS_RECLASS |
| FA_MASS_RECLASS_ITF |
| FA_MASS_RETIREMENTS |
| FA_MASS_RET_EXCEPTS |
| FA_MASS_REVALUATIONS |
| FA_MASS_REVALUATION_RULES |
| FA_MASS_REVAL_REP_ITF |
| FA_MASS_TAX_ADJUSTMENTS |
| FA_MASS_TRANSFERS |
| FA_MASS_UPDATE_BATCH_HEADERS |
| FA_MC_ADJUSTMENTS |
| FA_MC_ASSET_INVOICES |
| FA_MC_BOOKS |
| FA_MC_BOOKS_GROUPS |
| FA_MC_BOOKS_RATES |
| FA_MC_BOOKS_SUMMARY |
| FA_MC_BOOK_CONTROLS |
| FA_MC_CONVERSION_HISTORY |
| FA_MC_CONVERSION_RATES |
| FA_MC_DEFERRED_DEPRN |
| FA_MC_DEPRN_DETAIL |
| FA_MC_DEPRN_PERIODS |
| FA_MC_DEPRN_SUMMARY |
| FA_MC_GROUP_DEPRN_DETAIL |
| FA_MC_GROUP_DEPRN_SUMMARY |
| FA_MC_MASS_RATES |
| FA_MC_RETIREMENTS |
| FA_METHODS |
| FA_MRC_INQ_FINANCIALS |
| FA_PARALLEL_WORKERS |
| FA_PERIODIC_PRODUCTION |
| FA_PERIOD_MAPS |
| FA_PLSQL_DEBUG |
| FA_PRICE_INDEXES |
| FA_PRICE_INDEX_VALUES |
| FA_PRODUCTION_INTERFACE |
| FA_PROJECT_REP_ITF |
| FA_PROPTAX_REP_ITF |
| FA_RATES |
| FA_RECLASS_REP_ITF |
| FA_RESERVE_LEDGER |
| FA_RESERVE_LEDGER_GT |
| FA_RETIREMENTS |
| FA_RETIRE_REP_ITF |
| FA_RX_ATTRSETS_B |
| FA_RX_ATTRSETS_TL |
| FA_RX_DYNAMIC_COLUMNS |
| FA_RX_LOV |
| FA_RX_MULTIFORMAT_REPS |
| FA_RX_REPORTS |
| FA_RX_REP_COLUMNS_B |
| FA_RX_REP_COLUMNS_TL |
| FA_RX_REP_PARAMETERS |
| FA_RX_SECURITY |
| FA_RX_SUMMARY_TL |
| FA_SHORT_TAX_RESERVES |
| FA_SUPER_GROUPS |
| FA_SUPER_GROUP_RULES |
| FA_SYSTEM_CONTROLS |
| FA_TAX_INTERFACE |
| FA_TAX_REPORT |
| FA_TRACK_MEMBERS |
| FA_TRANSACTION_HEADERS |
| FA_TRANSFER_DETAILS |
| FA_TRANSFER_REP_ITF |
| FA_TRX_REFERENCES |
| FA_WARRANTIES |
| FA_WHATIF_ITF |
| FA_WORKER_JOBS |
| JE_DE_FA_SUMMARY |
| JE_HU_BALANCES_REPORT |
| PRDSTATS_TABLE |
| PRDSTATS_TABLE |
Showing posts with label assets. Show all posts
Showing posts with label assets. Show all posts
23 April 2012
ORACLE FIXED ASSETS TABLES
30 April 2009
R12 ASSETS NEW FEATURES AND CONFIGURATION
Serial No: 1 Sub Ledger Accounting Architecture and Inquiries
1. Oracle Assets is fully integrated with SLA, which is a common accounting platform for Sub Ledgers.
2. Customers can use the seeded Account Derivation definitions or modify them as required.
3. Continue to support Account Generator functionality for existing Asset Books.
4. New SLA Accounting report and online account inquiry.
Serial No: 2 Enhanced Mass Additions for Legacy conversions
1. Enhancements have been made to the FA_MASS_ADDITIONS table. New Attributes have been added viz,
2. Customers can populate the values for the new attributes directly in the FA Mass Additions interface table rather than accepting default values from the asset category.
3. Legacy conversion can be completely automated
4. Web ADI has also been upgraded to include the new Attributes
Serial No: 3 New Automatic Preparation of Mass Additions
1. This new feature consists of default rules and Public APIs that can be used by customers to complete the preparation of mass addition lines automatically.
2. Auto populate required fields such as Expense Account, Asset Category etc.
3. Avoid manual intervention during the Mass Additions prepare process
4. Avoid customization and use public APIs to effect custom business logic
Serial No: 4 Assets now uses Flexible Reporting using XML publisher
1. Major Asset Transaction reports have been modified to support XML publisher. 2. Users can modify or use new templates to view report output.
3. XML reporting is available for the following thirteen asset reports:
Serial No: 5 Automatic Depreciation Rollback
1. Depreciation is rolled back automatically by the system when any transaction is performed on an asset if the following conditions are met:
3. Depreciation rollback is executed only on select assets as required and not on the entire Asset Book this enhances performance of the program.
4. Since release 11i, users have been able to run depreciation for an asset book
without closing the period. If additional adjustments are required in the current
period, then the user submits a process to roll back depreciation for the entire
book, performs the necessary adjustment(s) and then resubmits the depreciation
program.
5. In Release 12 the intermediate manual step of rolling back depreciation
for the entire book in order to process further adjustments on selected assets is no
longer necessary. As before users may submit depreciation for the entire book
prior to closing the period. If it becomes necessary to process financial
adjustments on one or more assets, the user may proceed with the transaction
normally via the asset workbench or mass transactions.
6. Oracle Assets automatically rolls back the depreciation on just the selected assets(instead of the whole book) and allows the transaction(s) to be processed
normally. The asset(s) for which depreciation was rolled back is automatically
picked up during the next depreciation run or at the time that the depreciation
period is finally closed.
Serial No: 6 Enhanced functionality for Energy Industry
1. Energy Units of Production Method for Group Assets
Serial No: 7 Enhanced Asset Tracking in Payables
1. Enhanced Asset Tracking in Payables
4. The Create Mass Additions process has been enhanced to transfer these new fields into the interface table, FA_MASS_ADDITIONS. Invoice distributions are still the entity that gets transferred from Payables to Assets, but now the new asset tracking fields are included. Two additional changes to the Create Mass Additions process concern the Asset Book and Asset Category. In prior releases, these two values were available for PO/RCV matched distributions however the fields were not exposed in Payables, so no update was allowed in the Purchasing-Payables-Assets flow. In Release 12, Asset Book and Asset Category are new fields at the line and distribution levels (Asset Book only, not Asset Category) of an invoice.
5. Finally, Create Mass Additions has been enhanced to group the Invoice Price Variance and Exchange Rate Variance distributions to their corresponding item distributions since, in Release 12, these two expenses are tracked as separate distributions rather than being stored as columns on the item distribution, as in prior releases.
1. Oracle Assets is fully integrated with SLA, which is a common accounting platform for Sub Ledgers.
2. Customers can use the seeded Account Derivation definitions or modify them as required.
3. Continue to support Account Generator functionality for existing Asset Books.
4. New SLA Accounting report and online account inquiry.
Serial No: 2 Enhanced Mass Additions for Legacy conversions
1. Enhancements have been made to the FA_MASS_ADDITIONS table. New Attributes have been added viz,
- Asset Life
- Depreciation Method
- Prorate Convention
- Bonus Rule Ceiling Name
- Depreciation Limit Plus others
2. Customers can populate the values for the new attributes directly in the FA Mass Additions interface table rather than accepting default values from the asset category.
3. Legacy conversion can be completely automated
4. Web ADI has also been upgraded to include the new Attributes
Serial No: 3 New Automatic Preparation of Mass Additions
1. This new feature consists of default rules and Public APIs that can be used by customers to complete the preparation of mass addition lines automatically.
2. Auto populate required fields such as Expense Account, Asset Category etc.
3. Avoid manual intervention during the Mass Additions prepare process
4. Avoid customization and use public APIs to effect custom business logic
Serial No: 4 Assets now uses Flexible Reporting using XML publisher
1. Major Asset Transaction reports have been modified to support XML publisher. 2. Users can modify or use new templates to view report output.
3. XML reporting is available for the following thirteen asset reports:
- Asset Transfers Report
- Transaction History Report
- Asset Reclassification Report
- Mass Additions Create Report
- Cost Adjustment Report
- Cost Summary Report
- CIP Summary Report
- Reserve Summary
- Journal Entry Reserve Ledger
- Asset Additions Report
- CIP Capitalization Report
- Mass Additions Posting
- Asset Retirements
Serial No: 5 Automatic Depreciation Rollback
1. Depreciation is rolled back automatically by the system when any transaction is performed on an asset if the following conditions are met:
- Depreciation has been processed in that period
- The period is not closed
3. Depreciation rollback is executed only on select assets as required and not on the entire Asset Book this enhances performance of the program.
4. Since release 11i, users have been able to run depreciation for an asset book
without closing the period. If additional adjustments are required in the current
period, then the user submits a process to roll back depreciation for the entire
book, performs the necessary adjustment(s) and then resubmits the depreciation
program.
5. In Release 12 the intermediate manual step of rolling back depreciation
for the entire book in order to process further adjustments on selected assets is no
longer necessary. As before users may submit depreciation for the entire book
prior to closing the period. If it becomes necessary to process financial
adjustments on one or more assets, the user may proceed with the transaction
normally via the asset workbench or mass transactions.
6. Oracle Assets automatically rolls back the depreciation on just the selected assets(instead of the whole book) and allows the transaction(s) to be processed
normally. The asset(s) for which depreciation was rolled back is automatically
picked up during the next depreciation run or at the time that the depreciation
period is finally closed.
Serial No: 6 Enhanced functionality for Energy Industry
1. Energy Units of Production Method for Group Assets
- Allow Production method for Group Assets
- Allow Production upload to Group Assets
- Net Book Value / Remaining Life
Serial No: 7 Enhanced Asset Tracking in Payables
1. Enhanced Asset Tracking in Payables
- Item Description
- Manufacturer
- Model
- Serial Number
- Warranty Number
- Asset Book
- Asset Category
- IPV/ERV distributions
4. The Create Mass Additions process has been enhanced to transfer these new fields into the interface table, FA_MASS_ADDITIONS. Invoice distributions are still the entity that gets transferred from Payables to Assets, but now the new asset tracking fields are included. Two additional changes to the Create Mass Additions process concern the Asset Book and Asset Category. In prior releases, these two values were available for PO/RCV matched distributions however the fields were not exposed in Payables, so no update was allowed in the Purchasing-Payables-Assets flow. In Release 12, Asset Book and Asset Category are new fields at the line and distribution levels (Asset Book only, not Asset Category) of an invoice.
5. Finally, Create Mass Additions has been enhanced to group the Invoice Price Variance and Exchange Rate Variance distributions to their corresponding item distributions since, in Release 12, these two expenses are tracked as separate distributions rather than being stored as columns on the item distribution, as in prior releases.
Subscribe to:
Posts (Atom)