My Oracle Support Banner

FAH: API XLA_ACCOUNTING_PUB_PKG.accounting_program_events Spawns Multiple Create Accounting Programs (Doc ID 1626622.1)

Last updated on JULY 17, 2020

Applies to:

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


In FAH customer receives many events from the feeder system but wants to process them selectively, some should be accounted, some should not be accounted and put up for later.
They do not want to use the standard Create Accounting (CA) process (which works well otherwise) because it picks up all the events eligible for accounting.
So, customer decided to write their own custom process where they insert specific events of a certain class and ledger into the table XLA_ACCT_PROG_EVENTS_GT and then trigger accounting via a call to the public API XLA_ACCOUNTING_PUB_PKG.accounting_program_events.

The issue is that when, for example, they insert 2 events with distinct event_id and ledger_id they can see 4 Create Accounting programs being spawned for processing these events.

The API should not spawn multiple Create Accounting programs or, rather, should not spawn any.


Using the API in custom code.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.