Delete Mass Additions [message #464133] |
Tue, 06 July 2010 07:35 |
madhuarepalli
Messages: 53 Registered: June 2010 Location: Hyderabad
|
Member |
|
|
Dear All,
I have searched the functionality of Delete mass addition program but not available in this site. So that, i requested for the exact functionality of Delete Mass Additions Program. Which entries will delete while running this program.
Thanks & Regards,
Madhu
|
|
|
|
Re: Delete Mass Additions [message #464484 is a reply to message #464471] |
Thu, 08 July 2010 03:18 |
madhuarepalli
Messages: 53 Registered: June 2010 Location: Hyderabad
|
Member |
|
|
Hi Srikanth Reddy,
Thanks for Your Prompt Response, but i am not asking about navigation of DELETE MASS ADDITION Report. I am asking about functionality of "DELETE MASS ADDITION" program.
Thanks & Regards,
Madhu
|
|
|
|
|
Re: Delete Mass Additions [message #464609 is a reply to message #464133] |
Thu, 08 July 2010 08:41 |
eric62
Messages: 24 Registered: January 2009
|
Junior Member |
|
|
Hello.
You have to delete records in fa_mass_additions and fa_massadd_distributions
Look pdf in my oracle support "Fixed Assets Mass Additions White Paper [ID 111097.1]"
|
|
|
Re: Delete Mass Additions [message #464677 is a reply to message #464609] |
Thu, 08 July 2010 13:10 |
madhuarepalli
Messages: 53 Registered: June 2010 Location: Hyderabad
|
Member |
|
|
Hello Eric,
Ok, i will agree with you. can u clarify below point:-
After ran "DELETE MASS ADDITION PROGRAM" all entries are deleted which are in DELETE & HOLD queue and deleted data will hit in "FA_MASS_DELETED_ADDITIONS". Now i would like to UNDO which are in "FA_MASS_DELETED_ADDITIONS" to base tables like "FA_MASS_ADDITIONS". Is it possible.
Regards,
Madhu
|
|
|
Re: Delete Mass Additions [message #464751 is a reply to message #464677] |
Fri, 09 July 2010 03:28 |
eric62
Messages: 24 Registered: January 2009
|
Junior Member |
|
|
Not sure.
FA_DELETED_MASS_ADDITIONS is for FA_MASS_ADDITIONS.
So you can recreate the row in FA_MASS_ADDITIONS with data in FA_DELETED_MASS_ADDITIONS.
But for FA_MASSADD_DISTRIBUTIONS, the row is not backed up in a table.
So you will loose the CCID et LOCATION_ID if you delete FA_MASSADD_DISTRIBUTIONS.
My Oracle Support
Mass Additions Post FAQ's [ID 133277.1]:
1. Does Mass Additions Post purge the lines in the fa_mass_additions
interface table when they are posted to the Oracle Assets system?
....
|
|
|
Re: Delete Mass Additions [message #464761 is a reply to message #464751] |
Fri, 09 July 2010 04:43 |
madhuarepalli
Messages: 53 Registered: June 2010 Location: Hyderabad
|
Member |
|
|
Hello Eric,
Ok. Can u clarify below pooint:
1. I ran the "Delete Mass Additions Preview Report" before running of "DELETE MASS ADDITION PROGRAM" and i cross check with FA_MASS_ADDITION Table using MASS_ ADDITION _ID. I found the some entries in report which are POSTED status.
According to my knowledge, DELETE MASS ADDITION PROGRAM will delete the "DELETE" status entries only but in my scenario i found the "POSTED" status entries also.
Please let me know, what is the exact functionality of "DELETE MASS ADDITION PROGRAM"
Thanks & Regards,
Madhu
|
|
|
Re: Delete Mass Additions [message #464764 is a reply to message #464133] |
Fri, 09 July 2010 05:21 |
eric62
Messages: 24 Registered: January 2009
|
Junior Member |
|
|
FAQ: Oracle Assets Archive, Purge and Restore Processes [ID 144431.1]
....
8. Are there any other purge programs in FA (other than FAPURG) that should be run periodically due to large table sizes and/or for performance reasons?
Answer
The Purge Mass Additions from Oracle Assets program removes mass additions from the interim table FA_DELETED_MASS_ADDITIONS. The items in the interim table are the audit trail from the mass addition lines that you marked DELETE and removed using Delete Mass Additions. When you purge the interim table, you lose your
audit trail.
....
References
Note: 1018928.102
Oracle Assets User Guide for 11i, Chapter 5 (Data Archive and Purge)
.....
|
|
|
|
Re: Delete Mass Additions [message #464773 is a reply to message #464133] |
Fri, 09 July 2010 07:14 |
eric62
Messages: 24 Registered: January 2009
|
Junior Member |
|
|
Oracle Assets User Guide, Release 11i, Family Pack D, April 2003 [ID 230963.1]
.....
Deleting Mass Additions from Oracle Assets (5-22)
The Delete Mass Additions program removes mass additions in the
DELETE and POSTED queues. It also removes SPLIT parents if the
split children have been posted or deleted. The program archives mass
additions in the DELETE queue only to an audit trail table,
FA_DELETED_MASS_ADDITIONS.
....
Prerequisites
Change queue name to DELETE for unwanted or erroneous mass
addition lines in the Mass Additions window. See: Reviewing
Mass Addition Lines: page 2 45.
....
|
|
|