1. ae_line_id(AE行ID):该字段是xla_ae_lines表中的主键,用于唯一标识每一行数据。它的数据类型是数字型,通常采用自增长方式生成。 2. ae_header_id(AE头ID):这个字段是关联的AE头表的外键,用于将AE交易行与相应的AE交易头关联起来。它的数据类型也是数字型。 3. accounting_class_code(会计分类代码):该...
XLA_AE_LINES_PK AE_HEADER_ID, AE_LINE_NUM, APPLICATION_ID Columns NameDatatypeLengthPrecisionNot-nullCommentsFlexfield-mapping AE_HEADER_ID NUMBER 18 Yes Identifier of accounting entry. ANCHOR_LINE_FLAG VARCHAR2 1 ANCHOR_LINE_FLAG AE_LINE_NUM NUMBER 18 Yes Number that is associated with eac...
--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, h.je_source, h.je_category, i.gl_date, s....
XLA_AE_LINES_GT_PK LEDGER_ID, REF_AE_HEADER_ID, TEMP_LINE_NUM, AE_HEADER_ID, HEADER_NUM Columns NameDatatypeLengthPrecisionNot-nullComments AE_HEADER_ID NUMBER 18 Yes Subledger journal entry identifier. TEMP_LINE_NUM NUMBER 18 Yes Temporary line number that is used for processing. AE_LIN...
Hi there, 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.
Oracle Payables - Version 12.0.0 and later: Xla_ae_lines_pkg.BusinessFlowPriorEntries. ORA-01403: No Data Found.
Information in this document applies to any platform.SymptomsOn : 12.1.3 version, General Ledger TransferAttempting to run the Create accounting and receive the following error:ERROR---ORA-01688: unable to extend table XLA.XLA_AE_LINES partition AR by 16 in tablespace APPS_TS_TX_DATA.The...
apps.xla_ae_lines al, apps.xla_ae_headers ah, apps.xla_distribution_links l, apps.ap_invoices_all i, apps.ap_invoice_distributions_all ad, apps.ap_suppliers s, apps.xla_events e, apps.xla_transaction_entities te where /*ad.invoice_id = 10194 ...
XLA_AE_LINES_GT_PK LEDGER_ID, REF_AE_HEADER_ID, TEMP_LINE_NUM, AE_HEADER_ID, HEADER_NUM Columns NameDatatypeLengthPrecisionNot-nullComments AE_HEADER_ID NUMBER 18 Yes Subledger journal entry identifier. TEMP_LINE_NUM NUMBER 18 Yes Temporary line number that is used for processing. AE_LIN...