FA: Reports on Asset Keys

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
andrei.simion
Posts: 3
Joined: Tue Jan 04, 2011 9:29 am
Location: Romania

FA: Reports on Asset Keys

Post 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
andrei.simion
Posts: 3
Joined: Tue Jan 04, 2011 9:29 am
Location: Romania

Post 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]"
Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests