KEMBAR78
Purge Temporary Journal Import Interface Tables Created | PDF | Computers | Technology & Engineering
Scribd
Upload
512 views1 page

Purge Temporary Journal Import Interface Tables Created

This document discusses purging temporary journal import interface tables created by subledger accounting in Oracle Financials Accounting Hub. It states that the "XLADRPGLT - Purge Temporary Journal Import Interface Tables Created By Subledger Accounting" program can be run on a weekly basis after the period is closed, as the tables need to be in a closed period for the purge to work. The purge program will drop tables lying in closed periods, and new tables will be created if the period is later reopened and contains new transaction data. It is safe to run the purge program after monthly reconciliation is complete.

Uploaded by

Nadien Margareta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
512 views1 page

Purge Temporary Journal Import Interface Tables Created

This document discusses purging temporary journal import interface tables created by subledger accounting in Oracle Financials Accounting Hub. It states that the "XLADRPGLT - Purge Temporary Journal Import Interface Tables Created By Subledger Accounting" program can be run on a weekly basis after the period is closed, as the tables need to be in a closed period for the purge to work. The purge program will drop tables lying in closed periods, and new tables will be created if the period is later reopened and contains new transaction data. It is safe to run the purge program after monthly reconciliation is complete.

Uploaded by

Nadien Margareta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Document 1571165.

1 Page 1 of 1

XLA_GLT Tables Purging Frequently (Doc ID 1571165.1)


Modified: Jul 24, 2013 Type: HOWTO

In this Document

Goal
Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has
not been subject to an independent technical review.

APPLIES TO:

Oracle Financials Accounting Hub - Version 12.1 and later


Information in this document applies to any platform.

GOAL

Can the "XLADRPGLT - Purge Temporary Journal Import Interface Tables Created By Subledger Accounting" be run on weekly basis.

SOLUTION

Tables should lie in closed period for Purge program to work. Purge program can be run after period is closed
so that all tables lying in closed periods are dropped.

1)Purge program will purge the XLA_GLT_XX tables if the period is closed or permanently closed.
2)After purging the table ,if the user again reopen the period and process the new transactions in the same
period, the new XLA_GLT_XX table will be created with the new transaction data.

XLA_GLT% tables are equivalent to Journal Import Interface table of 11i.

So once import happens, those tables are not necessarily needed - they are preserved for Dev analysis (if there
are corruptions/errors etc).

So its safe to run the purge program after reconciliation for the month is done.

https://support.oracle.com/epmos/faces/DocContentDisplay?_adf.ctrl-state=8kw2nrdwj_17... 2/12/2014

You might also like