Monday, October 31, 2016

Oracle Apps Fixed Assets Table

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 
                          distributions for a book


FA_DISTRIBUTION_HISTORY   Employee, location, and Accounting Flexfield 
                          values assigned to each asset

FA_RETIREMENTS            Information about asset retirements and 
                          reinstatements

4 comments:

Unknown said...

Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com

Smith said...

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.

aussieqs said...

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.

Rainbow Training Institute said...

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