1. ae_line_id(AE行ID):该字段是xla_ae_lines表中的主键,用于唯一标识每一行数据。它的数据类型是数字型,通常采用自增长方式生成。 2. ae_header_id(AE头ID):这个字段是关联的AE头表的外键,用于将AE交易行与相应的AE交易头关联起来。它的数据类型也是数字型。 3. accounting_class_code(会计分类代码):该...
Object type: TABLE Tablespace: Default Primary Key Name Columns 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...
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. We created a purchase incoice and created accounting for it. We can see a records created in XLA_AE_LINES for it.We were expectin...
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...
In the rcv_receiving_sub_ledger with the RCV_SUB_LEDGER_ID you can tie in the XLA_DISTRIBUTION_LINKS table with the SOURCE_DISTRIBUTION_ID_NUM_1: xdl.SOURCE_DISTRIBUTION_ID_NUM_1 = rrsl.RCV_SUB_LEDGER_ID And then complete the join between the tables with the ae_header_id reference bet...
In the rcv_receiving_sub_ledger with the RCV_SUB_LEDGER_ID you can tie in the XLA_DISTRIBUTION_LINKS table with the SOURCE_DISTRIBUTION_ID_NUM_1: xdl.SOURCE_DISTRIBUTION_ID_NUM_1 = rrsl.RCV_SUB_LEDGER_ID And then complete the join between the tables with the ae_header_id reference bet...
GL_JE_LINES (je_header_id, je_line_num) => GL_IMPORT_REFERENCES (je_header_id, je_line_num) ; GL_IMPORT_REFERENCES (gl_sl_link_table, gl_sl_link_id) => XLA_AE_LINES (gl_sl_link_table, gl_sl_link_id) ; XLA_AE_LINES (application_id, ae_header_id) => XLA_AE_HEADERS (...
Oracle Payables - Version 12.0.0 and later: Xla_ae_lines_pkg.BusinessFlowPriorEntries. ORA-01403: No Data Found.
Using XLA tensors and devices requires changing only a few lines of code. However, even though XLA tensors act a lot like CPU and CUDA tensors, their internals are different. CPU and CUDA tensors launch operations immediately or eagerly. XLA tensors, on the other hand, are lazy. Th...
Using XLA tensors and devices requires changing only a few lines of code. However, even though XLA tensors act a lot like CPU and CUDA tensors, their internals are different. CPU and CUDA tensors launch operations immediately or eagerly. XLA tensors, on the other hand, are lazy. The...