Friday, January 22, 2010

Bug 8207550 Not Dropping FA_JOURNAL_INTERIM Tables

If you run the Create Journal Entries request set in 11.5.10.2, you may have some unneeded tables hanging around in your system. The code to drop the FA_JOURNAL_INTERIM table has been inadvertently commented out of FAXCJEB.pls, allowing the tables to remain after they are no longer needed.


ISSUE

BUG 8207550 FA_JOURNALS_INTERIM tables are not dropped after Create Journal Entry.


SYMPTOM

FA_JOURNALS_INTERIM tables remain present in the database after Create Journal Entries run.


SOLUTION

There is no patch currently available to resolve this issue. You may choose to allow the tables to remain in your system, or these tables can be safely removed after the completion of the Create Journal Entries run.


TIP

If you aren't currently doing so, you should consider implementing a check for newly created objects in your database. This can help you identify objects that are not properly cleaned up.


REFERENCES

757666.1, FA_JOURNALS_INTERIM Tables are Not Dropped after Successful Create Journal Entry and Journal Import

732925.1, Journal Import Fails After Depreciation Run. Depreciation Journal Is Unbalanced

No comments: