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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment