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
FA: Reports on Asset Keys
-
andrei.simion
- Posts: 3
- Joined: Tue Jan 04, 2011 9:29 am
- Location: Romania
-
andrei.simion
- Posts: 3
- Joined: Tue Jan 04, 2011 9:29 am
- Location: Romania
<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]"
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]"
Who is online
Users browsing this forum: No registered users and 6 guests