Page 1 of 1

FA: Reports on Asset Keys

Posted: Sun Mar 13, 2011 12:31 pm
by andrei.simion
As we know, we can track assets using the Asset Key. So, we defined Asset Key flexfield to group assets by non-financial information and the question comes: how to get financial information (Cost, NBV, Depr_amount) using the Asset Key...

Is there any standard report with parameter "Asset Key"?
So far, we can identify the assets using Asset Workbench but there is not financial information in Folder Tools.

Thanks,
-A

Posted: Mon Mar 14, 2011 4:48 am
by andrei.simion
<sup><b>Solution.</b></sup>
Metalink note:
Is there an Asset Standard Report that Displayed Asset Cost for Assets Grouped By Asset Key? [ID 257131.1]

There is no standard Oracle Asset report that is grouped by asset key.
Workaround is to write your own report and that can be done using Oracle
Reports(Oracle Developer 2000).

The other alternative is to have a look at the RX reports.
RX-only Asset Cost Balance Report
RX-only: Asset Listing by Period

Need to modify these report using report exchange designer responsibility.

<b>Other helpful information:</b>
"Reports Exchange (RXi) Basics [ID 119736.1]"
and
"R12 RX-only: Additions By Period Report Errors with FA_DEPRN_SQL_FCUR ORA-01722 Invalid Number [ID 750181.1]"