1. ae_line_id(AE行ID):该字段是xla_ae_lines表中的主键,用于唯一标识每一行数据。它的数据类型是数字型,通常采用自增长方式生成。 2. ae_header_id(AE头ID):这个字段是关联的AE头表的外键,用于将AE交易行与相应的AE交易头关联起来。它的数据类型也是数字型。 3. accounting_class_code(会计分类代码):该...
Once the entire accounting entry has been processed, the data in this table is grouped together and then transferred to the XLA_AE_LINES table. The grouping is done by updating the REF_LINE_NUM, ENTERED_DR_SUM, ENTERED_CR_SUM, ACCOUNTED_DR_SUM, ACCOUNTED_CR_SUM, UNROUNDED_ENTERED_DR_SUM...
We need to understand under what scenarios are the columns XLA_AE_LINES .source_table and XLA_AE_LINES.source_id populated for a PURCHASE INVOICE. We created a purchase incoice and created accounting for it. We can see a records created in XLA_AE_LINES for it.We were expecting to see ...
xla_ae_lines ae , ar_cash_receipt_history_all crh, ar_cash_receipts_all cr , xla_ae_headers hd WHERE ard.source_table = 'CRH' AND ard.source_id = crh.cash_receipt_history_id AND ard.line_id = lk.source_distribution_id_num_1 AND lk.application_id = 222 AND lk.source_distribution...
--ap_invoice_distributions_all到xla_ae_lines. 到了XLA_AE_LINES后,会by科目和描述汇总.所以,不能一对一select c.code_combination_id, h.je_header_id, l.ae_header_id, l.ae_line_num, te.source_id_int_1, te.application_id, te.entity_id, h.je_source, h.je_category, i.gl_date, s...
--ap_invoice_distributions_all到xla_ae_lines. 到了XLA_AE_LINES后,会by科目和描述汇总.所以,不能一对一 selectc.code_combination_id, h.je_header_id, l.ae_header_id, l.ae_line_num, te.source_id_int_1, te.application_id, te.entity_id, ...
Oracle Payables - Version 12.0.0 and later: Xla_ae_lines_pkg.BusinessFlowPriorEntries. ORA-01403: No Data Found.
XLA_AE_LINES (application_id, ae_header_id) => XLA_AE_HEADERS (application_id, ae_header_id) ; XLA_AE_HEADERS (application_id, event_id) => XLA_EVENTS (application_id, event_id); XLA_EVENTS (application_id, entity_id) => XLA.XLA_TRANSACTION_ENTITIES (application_id, entity_id);...
1. explicit batch dims 2. implicit batch dims 3. index passthrough dims Therefore, when partitioning gather/scatter along index passthrough dims, we do not consider explicit batch and implicit batch dims. The batch dims are considered in other partitioning methods. PiperOrigin-RevId: 701124558...
Create Accounting Fails with Error - ORA-01688: Unable to Extend Table XLA.XLA_AE_LINES Partition AR by 16 in Tablespace APPS_TS_TX_DATA (Doc ID 1643502.1) Last updated on SEPTEMBER 30, 2023 Applies to: Oracle Receivables - Version 12.1.3 and later...