Skip to main content

EBS Asset Reports

Here are the OOTB reports from EBS:


It looks like that the EBS FA team created a lot of OOTB reports!

FAS400 Journal Entry Reserve Ledger Report
FAS401 Responsibility Reserve Ledger Report
FAS402 Fully Reserved Assets Report
FAS403 Account Reconciliation Reserve Ledger Report
FAS410 Asset Inventory Report
FAS420 Asset Additions Report
FAS421 Asset Additions By Cost Center Report
FAS423 Conversion Assets Report
FAS430 Asset Transfers Report
FAS431 Asset Transfer Reconciliation Report
FAS440 Asset Retirements Report
FAS441 Asset Retirements By Cost Center Report
FAS442 Reinstated Assets Report

FAS443 Form 4797 – Gain from the Disposition of 1245 Property
FAS444 Retired Assets Without Property Classes Report
FAS445 Form 4797 – Gain from the Disposition of 1250 Property
FAS446 Form 4797 – Sales or Exchanges of Property Report
FAS447 Form 4797 – Ordinary Gains and Losses Report
FAS448 Retired Assets Without Retirement Types Report
FAS449 Form 4684 – Casualties and Thefts Report
FAS460 Property Tax Report FAS480 Tax Reserve Ledger Report
FAS490 Asset Additions Responsibility Report
FAS500 Asset Disposals Responsibility Report
FAS520 Tax Retirements Report FAS530 Transaction History Report
FAS540 Tax Additions Report
FAS551 Depreciation Projections Report
FAS561 Depreciation Projections by Cost Center Report
FAS590 Investment Tax Credit Report
FAS600 Asset Register Report
FAS700 Assets Not Assigned To Any Books Listing
FAS710 Assets Not Assigned To Any Cost Centers Listing
FAS720 Asset Tag Listing FAS730 Asset Description Listing
FAS740 Asset Reclassification Report
FAS741 Asset Reclassification Reconciliation Report
FAS750 Asset Category Listing
FAS770 Form 4562 – Depreciation and Amortization Report
FAS771 Adjusted Form 4562 – Depreciation and Amortization Report
FAS780 Assets By Category Report
FAS811 Mass Transfer Preview Report
FAS822 Mass Additions Create Report
FAS823 Mass Additions Status Report
FAS824 Mass Additions Posting Report
FAS826 Mass Additions Purge Report
FAS828 Delete Mass Additions Preview Report
FAS829 Mass Additions Delete Report
FAS833 Unposted Mass Additions report
FAS840 Cost Adjustments Report
FAS860 Mass Change Preview Report
FAS861 Mass Change Review Report
FAS870 Reserve Adjustments Report
FAS911 Depreciation Rates Listing
FAS930 Leased Assets Report
FAS955 Budget–to–Actual Report
FAS956 Budget Report
FASAAMTD Adjusted Form 4626–AMT Detail Report
FASAAMTS Adjusted Form 4626–AMT Summary Report
FASACEAU ACE Assets Update Report
FASACEDP ACE Depreciation Comparison Report
FASACEND ACE Non–Depreciating Assets Exception Report
FASACEUD ACE Unrecognized Depreciation Method Code Exception Report
FASANADD Annual Additions Report
FASASSBS Additions By Source Report F
ASCAPSP Capital Spending Report
FASCASR Cost Adjustments by Source Report
FASCC Cost Clearing Reconciliation Report
FASCEILG Ceiling Listing
FASCOSTD Cost Detail Report
FASCOSTS Cost Summary Report
FASDPAPV Mass Depreciation Adjustment Preview Report
FASDPARV Mass Depreciation Adjustment Review Report
FASDRILA Account Drill Down Report
FASDRILL Drill Down Report
FASEXPRP Expensed Property Report F
ASFIADJ Financial Adjustments Report
FASINDX Database Index Listing
FASINSDR Insurance Data Report
FASINSVR Insurance Values Detail Report
FASITCRT ITC Rates Listing
FASLSCAL Calendar Listing
FASLSPRC Prorate Convention Listing
FASMAIMR Mass Additions Invoice Merge Report
FASMAINT Asset Maintenance Report
FASMAISP Mass Additions Invoice Split Report
FASMRET Mass Retirements Report
FASMRETX Mass Retirements Exception Report
FASMSUOP Units of Production Assets Report
FASNBV Diminishing Value Report
FASNDPRP Non–Depreciating Property Report
FASPARAS Parent Asset Report
FASPARTX Parent Asset Transactions Report
FASPRJ Depreciation Projection Report
FASPRX Price Index Listing
FASRCOST Recoverable Cost Report
FASRCPVW Mass Reclassification Preview Report
FASRCRVW Mass Reclassification Review Report
FASRREV Revalued Asset Retirements Report
FASRSVED Reserve Detail Report and Revaluation Reserve Detail Report
FASRSVES Reserve Summary Report and Revaluation Reserve Summary Report
FASRTDBR Bonus Depreciation Rule Listing
FASRVPVW Mass Revaluation Preview Report
FASRVRED Revaluation Reserve Detail Report
FASRVRES Production Summary Report
FASRVRVW Mass Revaluation Review Report
FASTXPRF Tax Preference Report
FASUNPLD Unplanned Depreciation
FASUOPHI Production History Report
FASWIPAS CIP Assets Report
FASWIPCR CIP Capitalization Report
RXFAAC RX–only: Asset Cost Balance Report
RXFAAD RX–only: Accum Deprn Balance Report
RXFAADD RX–only: Additions by Date–Placed–in–Service Report
RXFAADP RX–only: Additions by Period Report
RXFAADR RX–only: Additions by Responsibility Report
RXFACAJ RX–only: Cost Adjustments Report
RXFACAP RX–only: Capitalizations Report
RXFAHWD Hypothetical What–If Depreciation Analysis
RXFAMAD RX–only: Mass Additions Report
RXFAPIC RX–only: Physical Inventory Comparison Report
RXFAPIM RX–only: Physical Inventory Missing Assets Report
RXFAPTAX RX–only: Property Tax Report
RXFARCL RX–only: Reclass Report
RXFARCLP RX–only: Mass Reclassification Preview Report
RXFARCLR RX–only: Review Mass Reclassifications
Report RXFARET RX–only: Retirements Report
RXFARL RX–only: Reserve Ledger Report
RXFARR RX–only: Reval Reserve Balance Report
RXFATFR RX–only: Asset Transfers Report

Comments

Popular posts from this blog

Create Accounting for a Payment generates errors 95333 and 95359

Create Accounting for a Payment generates errors 95333 and 95359 Error: 95333: A conversion rate does not exist to convert USD to AUD for the conversion type Corporate and conversion date 20-MAR-09 for line -25. Please use the Daily Rates form in General Ledger to enter a conversion rate for these currencies, conversion date and conversion type. 95359: There is no accounted amount for the subledger journal entry line. Please inform your system administrator or support representative that: The source assigned to the accounting attribute Accounted Amount has no value for extract line number 88547. Please make sure the source assigned to the accounting attribute Accounted Amount has a valid value, or assign a different source to this accounting attribute. Solution: 1. Specify a conversion rate for the currencies and conversion date mentioned in the error message 95333 Navigation under the General Ledger responsibility: Setup > Currencies > Currency Rates Manager > Daily Rates ...

Public API’s for FA Transactions

Public API’s for FA Transactions So far Oracle FA is have all the good things except the lack on reporting.Oracle FA is now offer lot of public API's that can be used to interfacing with third party or Oracle application other modules. Here are some of transaction's API's:   Additions API if you have requirement to add assets directly via PL/SQL then use  FA_ADDITION_PUB.DO_ADDITION. If you have selected the Allow CIP Assets check box on the Book Controls window of a tax book when adding CIP assets using the Additions API, the this API automatically adds those CIP assets to that tax book at the same time that they are added to the corporate book. Adjustments API you can make cost adjustments to your assetsdirectly via PL/SQL using  FA_ADJUSTMENT_PUB.DO_ADJUSTMENT  for any  process adjustment. Detail can be found in appendix H) You can use this API if you have a custom interface that makes it difficult to use with the existing Oracle Assets interfaces for adjusti...

AP Table Relation Oracle Apps

AP Table Relation Oracle Apps ORACLE PAYABLE TABLE RELATION Source Table Dependent Table Condition AP_INVOICE_LINES_ALL AIL ZX_LINES_SUMMARY ZLS AIL.invoice_id = ZLS.trx_id and  ZLS.application_id  = 200 and  ZLS.entity_code  = 'AP_INVOICES' and  ZLS.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and  AIL.summary_tax_line_id = ZLS.summary_tax_line_id AP_INVOICE_LINES_ALL AIL ZX_LINES ZL AIL.invoice_id = ZL.trx_id and  ZL.application_id  = 200 and  ZL.entity_code  = 'AP_INVOICES' and  ZL.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and  AIL.line_number = ZL.trx_line_number AP_INVOICE_DISTRIBUTIONS_ALL AID ZX_REC_NREC_DIST ZD AID.invoice_id = ZD.trx_id and  ZD.application_id  = 200 and  ZD.entity_code  = 'AP_INVOICES' and  ZD.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and...