Below are some important tables frequently used in query's in Oracle Apps for Fixed Assets module.
FA_ADDITIONS_B Descriptive information about assets
FA_ADDITIONS_TL Translated Descriptive information about assets
FA_ADJUSTMENTS Adjustment information on assets user by
General Ledger to create journal entry lines
in the general ledger
FA_ASSET_HISTORY Historical information about asset
reclassification and unit adjustments
FA_ASSET_INVOICES Accounts payable and purchasing information
for each asset
FA_BOOKS Financial information of each asset
FA_BOOK_CONTROLS Control information that affects all assets
in a depreciation book
FA_CALENDAR_PERIODS Detailed calendar information
FA_CATEGORIES_B Default financial information for asset
categories
FA_CATEGORY_BOOKS Default financial information for an asset
category and depreciation book combination
FA_DEPRN_DETAIL Depreciation amounts charged to the
depreciation expense account in each
distribution line
FA_DEPRN_PERIODS Information about each depreciation period
FA_DISTRIBUTION_ACCOUNTS Table to store account ccids for all
FA_DEPRN_PERIODS Information about each depreciation period
FA_DISTRIBUTION_ACCOUNTS Table to store account ccids for all
distributions for a book
FA_DISTRIBUTION_HISTORY Employee, location, and Accounting Flexfield
FA_DISTRIBUTION_HISTORY Employee, location, and Accounting Flexfield
values assigned to each asset
FA_RETIREMENTS Information about asset retirements and
FA_RETIREMENTS Information about asset retirements and
reinstatements
4 comments:
Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com
Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.
I wanted to thank you for this great Information and knowledge, I definitely loved every little bit of it. I have you bookmarked your web site to check out the latest stuff you post. Your blog is eye-catching. I get pleasure from it. Thanks for sharing this beautiful piece of writing with me, get more information at Property Depreciation Schedule for more AussieQS related information and knowledge.
Good Blog. Thanks for sharing this information and helpful for me
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Oracle Integration Cloud Online Training
Oracle Fusion Technical Online Training
Post a Comment