Mass Addition Create Report [message #191353] |
Tue, 05 September 2006 18:09 |
smulukutla
Messages: 45 Registered: May 2006
|
Member |
|
|
Mass Additions Create Report once we run the report the data from the tables gets deleted automatically. Our user runs the report every thursday and previous weeks data gets deleted from the table FA_MASS_ADDITIONS. But our user wants to see the data for the whole year 2006.
I went into the table FA_MASS_ADDITIONS and I could n't get the data completely. Are there any other tables in Fixed Assets which they store the data? Any input is appreciated.
Thanks.
|
|
|
Re: Mass Addition Create Report [message #191410 is a reply to message #191353] |
Wed, 06 September 2006 04:36 |
agostino_neto
Messages: 180 Registered: July 2005
|
Senior Member |
|
|
From etrm.
When you run the Mass Additions Post process, Oracle Assets creates assets or adjustments from any rows in which the POSTING_STATUS is POST. Mass additions post inserts rows into FA_ADDITIONS, FA_ASSET_HISTORY, FA_ASSET_INVOICES, FA_BOOKS, FA_DISTRIBUTION_HISTORY, FA_TRANSACTION_HEADERS, FA_INVOICE_TRANSACTIONS, FA_DEPRN_SUMMARY, FA_DEPRN_DETAIL, and FA_TRANSFER_DETAILS.
|
|
|
|