Delete Mass Additions

Tags:
fa3Remove my vote on this tag create new tag

Table of Contents

Transaction Description

After Mass Additions have been added to the system, the rows are still present in the FA_MASS_ADDITIONS table. The concurrent program Delete Mass Additions will remove lines in the POSTED, DELETE, and SPLIT queues. By running this program periodically you can keep these already processed lines out of the Mass Additions window. The program will only delete lines for one designated book at a time.

note To maintain an audit trail, lines from the DELETE queue are actually moved to a table called FA_DELETED_MASS_ADDITIONS. They will stay in this table until the FA Administrator responsibility runs the Purge Mass Additions program. Although this data is kept as an audit trail, there are no reports or forms that allow a user to look at the contents of FA_DELETED_MASS_ADDITIONS table. The Mass Additions Delete report is run at the same time as the Delete Mass Additions program. That report is your hard copy audit trail.

Request Set Programs

Screen Shot
  • Mass Additions Delete Report
  • Mass Additions Delete

Parameters

List of Fields

  • Book











Comments

 

Links

This Topic Is Referenced By These Topics:
Related Links: AssetMassAdditions, FA12MassAdditionsPostMassAdditions, FA12MassAdditionsPrepareMassAdditions



Was This Topic Useful to You?

Others rated this topic as shown. Please include your rating.
Choice
leftbarmainbarrightbar Somewhat Useful (1)

Collaborating Authors and Reviewers: -- DianeMcHugh, JimCrum

Topic revision: r7 - 18 Jan 2009 - 00:46:03 - JimCrum
 
This site is powered by the TWiki collaboration platformCopyright © 2012 by the contributing authors. All material on this collaboration platform is the property of the contributing authors. Permission to copy, distribute and/or modify is granted for this document under the GNU Free Documentation License.
Ideas, requests, problems regarding WikiOraApps? Send feedback