Purging Move/Merge Tables (Oracle General Ledger Users' Guide)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

Purging Move/Merge Tables

A move/merge operation populates two interim tables, GL_MOVEMERGE_BAL_<move/merge request id> and GL_MOVEMERGE_DAILY_BAL_<move/merge request id>, with the balances being moved or merged. The information in these tables is retained after a successful move/merge because it is needed to reverse the move/merge.

When you are satisfied that the results of a move/merge are correct and that you want to retain the new balances, you should purge the tables. Do not purge the tables if you think you may want to reverse the move/merge later.

Additional Information: If you reverse a move/merge operation, the interim tables will be purged automatically.

To purge the interim move/merge tables:

1. Navigate to the Mass Maintenance Workbench window.

2. Query the move/merge request whose interim tables you want to purge.

3. Choose the Purge button.

Purging Move/Merge Tables

To purge the interim move/merge tables:

See Also