How To Clean Up The GL_POSTING_INTERIM Tables And Other Interim Tables (Doc ID 1061025.6)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle General Ledger - Version 10.7 to 12.1.3 [Release 10.7 to 12.1]
Information in this document applies to any platform.

Goal

 You have reviewed the data stored in the following GL Interim Tables:

  - GL_POSTING_INTERIM
  - GL_ALLOC_INTERIM
  - GL_ALLOC_TARGETS
  - GL_BUDGET_INTERIM
  - GL_BUGET_RANGE_INTERIM

You have determined that these tables contain only old data.  You would like to know what these tables are used for and if it is okay to delete the old data.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms