Home » Applications » Oracle Fusion Apps & E-Business Suite » Mass Addition Create Report
Mass Addition Create Report [message #191353] Tue, 05 September 2006 18:09 Go to next message
Messages: 45
Registered: May 2006
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.

Re: Mass Addition Create Report [message #191410 is a reply to message #191353] Wed, 06 September 2006 04:36 Go to previous messageGo to next message
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.
Re: Mass Addition Create Report [message #191620 is a reply to message #191353] Thu, 07 September 2006 05:58 Go to previous message
Messages: 3
Registered: September 2006
Junior Member
SELECT * FROM apps.fa_deleted_mass_additions;
Previous Topic: Different A/cs that get affected in Procure to Pay and Order to Cash cycles .
Next Topic: AP to PA Non Net zero adjustment
Goto Forum:

Current Time: Sun Aug 20 01:03:20 CDT 2017

Total time taken to generate the page: 0.29842 seconds