Unable To Get Data From Xla_events_gt Or XLA_POST_ACCTG_EVENTS_V In Accounting Business Event (Doc ID 2078960.1)

Last updated on AUGUST 09, 2016

Applies to:

Oracle Financials Accounting Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

We are unable to get data from xla_events_gt or XLA_POST_ACCTG_EVENTS_V after enabling oracle.apps.xla.accounting.extract or oracle.apps.xla.accounting.postprocessing business events, as per user guide we should be able to select data from these objects to process custom code.

"oracle.apps.xla.accounting.extract (batch and document mode)

This event is raised for all modes of accounting, final and draft, in batch as well as document mode. Events selected for the processing are passed to the subscription routine through the global temporary table XLA_EVENTS_GT. Implementers subscribing to this event can use it to populate transaction objects based on information in the XLA_EVENTS_GT table."

oracle.apps.xla.accounting.postprocessing (batch and document mode)

The postprocessing event is raised after creating subledger journal entries for each processing unit (commit unit). This event is raised if the Create Accounting parameter is set to Yes. The subscription to the postprocessing event uses the view XLA_POST_ACCTG_EVENTS_V based on XLA_EVENTS_GT to derive accounting events successfully accounted by the Create Accounting program.

We need develop a POC based on extract from these tables.

How do we resolve this issue so that we can use these objects to extract data from?
 

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