Financial Services Accounting Hub Repository Data Model. The Financial Services Accounting Hub repository is composed of the following entities: XLA_ TRANSACTION _ENTITIES. XLA_EVENTS. XLA_AE_HEADERS. XLA_AE_LINES. XLA_DISTRIBUTION_LINKS. For information on these entities, see the Oracle Subledger Accounting eTRM.
Anyway without having entity you can’t have an event. As I said earlier this is a VPD enabled table. You have to use xla.xla_ transaction _entities or others, which I’ve mentioned in the link2. Also populating data in xla_events and xla.xla_ transaction _entities may vary from one subledger to another.
6/23/2014 · I think this is a case of Oracle EBS R12’s use of VPD (Virtual Private Database) to restrict access to data (instead of using views and synonyms). Try to select from xla.xla_ transaction _entities instead of xla_ transaction _entities.
ORA-01403: no data found. EVENT CLASS CODE = FOB_RCPT_RECIPIENT_RCPT. The following events are present in the line extract but MISSING in the header extract: Event_id = 510286 … 3. select * from xla.xla_ transaction _entities where entity_id in (select entity_id from xla_events where event_id in(510286,510839);, 10/24/2016 · Ø introduces a common data model and UI across sub ledgers … .=>XLA.XLA_ TRANSACTION _ENTITIES (application_id, entity_id) 1) All accounting performed before transfer to the GL. Accounting data generated and stored.
Accounting data generated and stored in “Accounting Events” tables before transfer to GL. Run “Create Accounting” to populate accounting events (SLA) tables. User can “View Accounting” only after “Create Accounting” is run. … xla.xla_ transaction _entities xte, xla_ae_headers xah, xla_ae_lines xal, gl.gl_import_references gir …
10/29/2017 · xla.xla_ transaction _entities (source_id_int_1) filtered by application_id 222, entity_code TRANSACTIONS and ledger_id -> ra_customer_trx_all (customer_trx_id) for that set_of_books_id. Note: a) There is an index on xla.xla_ transaction _entities on the following columns.
The source_id_int_1 column of xla.xla_ transaction _entities stores the primary_id value for the transactions. You can join the xla.xla_ transaction _entities table with the corresponding transactions table for obtaining additional information of the transaction.
10/30/2017 · find ap invoice data in xla_ae_lines table: select distinct xel.* from xla_ae_lines xel , xla_ae_headers xeh , ap_invoices_all ai , xla_events xe , xla.xla_ transaction _entities xte where xte.application_id =200 and xel.application_id =200 and xeh.application_id =200.
xla.xla_ transaction _entities xte, xla_ae_headers xah, xla_ae_lines xal, gl.gl_import_references gir, … Above query wass wrong.. there is no link between Invoice and XLA tables. Reply Delete. Replies. Reply. arif 3 April 2019 at 22:37. … Append the Data Base value to Tabular Form Read on…
