XLA_FSN_GROUPING_GT
This table is used by the accounting engine to temporarily store accounting entries that are too big to fit into memory. 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, UNROUNDED_ENTERED_CR_SUM, UNROUNDED_ACCOUNTED_DR_SUM, UNROUNDED_ACCOUNTED_CR_SUM, STATISTICAL_AMOUNT_SUM, CODE_COMBINATION_ID, and CURRENCY_CODE columns with the desired value for the grouped lines. All lines with a REF_LINE_NUM equal to their AE_LINE_NUM are then inserted into XLA_AE_LINES.
Details
-
Schema: FUSION
-
Object owner: XLA
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| AE_HEADER_ID | NUMBER | 18 | Yes | Subledger journal entry identifier. | |
| ANCHOR_LINE_FLAG | VARCHAR2 | 1 | ANCHOR_LINE_FLAG | ||
| AE_LINE_NUM | NUMBER | 18 | Yes | Subledger journal entry line number. | |
| APPLICATION_ID | NUMBER | 18 | Yes | Functional area within a software suite of products. For example, Financials or Payroll. | |
| CODE_COMBINATION_ID | NUMBER | 18 | Yes | Unique combination of segment values that records accounting transactions. A typical account combination contains the following segments: company, division. | |
| GL_TRANSFER_MODE_CODE | VARCHAR2 | 1 | Transfer mode (detail or summary). | ||
| GL_SL_LINK_ID | NUMBER | 18 | Combines with GL_SL_LINK_table to form a unique identifier that uniquely identifies this row for drilldown purposes from general ledger journal lines. | ||
| ACCOUNTING_CLASS_CODE | VARCHAR2 | 30 | Yes | Lookup type that is shared across the application and used to classify journal entry lines. | |
| PARTY_ID | NUMBER | 18 | Additional party to the internal party and the external party, that participates in a business relationship. Related terms are external party or internal party. | ||
| PARTY_SITE_ID | NUMBER | 18 | Site name of an additional party to the internal party and the external party that participates in a business relationship. | ||
| PARTY_TYPE_CODE | VARCHAR2 | 1 | Third party type (customer or supplier). | ||
| ENTERED_DR | NUMBER | Entered debit amount for journal entry line. | |||
| ENTERED_CR | NUMBER | Entered credit amount for journal entry line. | |||
| ACCOUNTED_DR | NUMBER | Accounted debit amount for journal entry line. | |||
| ACCOUNTED_CR | NUMBER | Accounted credit amount for journal entry line. | |||
| DESCRIPTION | VARCHAR2 | 1996 | Journal entry line description. | ||
| STATISTICAL_AMOUNT | NUMBER | Used in reporting analysis and allocation journal entries. Examples of statistical units of measure are headcount, copies, and labor hours. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Three-letter ISO code associated with the entered currency. | |
| CURRENCY_CONVERSION_DATE | DATE | Date as of which a conversion rate is used to convert an amount into another currency. | |||
| CURRENCY_CONVERSION_RATE | NUMBER | Ratio at which the principal unit of one currency can be converted into another currency. | |||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Source of a currency conversion rate, such as user defined, spot, or corporate. | ||
| USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | United States Standard General Ledger transaction code. | ||
| JGZZ_RECON_REF | VARCHAR2 | 240 | System-assigned identifier used for reconciliation matching. | ||
| CONTROL_BALANCE_FLAG | VARCHAR2 | 1 | Indicates whether this is a control account. | ||
| ANALYTICAL_BALANCE_FLAG | VARCHAR2 | 1 | Flag for analytical balances. Valid values are Null: not eligible for balance calculation, P: balance calculation pending, or Y: balance calculation done. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| GL_SL_LINK_TABLE | VARCHAR2 | 30 | Combines with GL_SL_LINK_table to form a unique identifier that uniquely identifies a row when navigating from general ledger journal lines. | ||
| DISPLAYED_LINE_NUMBER | NUMBER | 18 | Accounting entry line number displayed to users. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| UPG_BATCH_ID | NUMBER | 18 | Not currently used. | ||
| UPG_TAX_REFERENCE_ID1 | NUMBER | 18 | Upgraded tax reference identifier. | ||
| UPG_TAX_REFERENCE_ID2 | NUMBER | 18 | Upgraded tax reference identifier. | ||
| UPG_TAX_REFERENCE_ID3 | NUMBER | 18 | Upgraded tax reference identifier. | ||
| UNROUNDED_ACCOUNTED_DR | NUMBER | Unrounded debit amount in base currency. | |||
| UNROUNDED_ACCOUNTED_CR | NUMBER | Unrounded credit amount in base currency. | |||
| GAIN_OR_LOSS_FLAG | VARCHAR2 | 1 | Indicates whether this is a gain or loss line type. | ||
| UNROUNDED_ENTERED_DR | NUMBER | Unrounded debit amount in entered currency. | |||
| UNROUNDED_ENTERED_CR | NUMBER | Unrounded credit amount in entered currency. | |||
| SUBSTITUTED_CCID | NUMBER | 18 | Original account if a replacement account was used. | ||
| BUSINESS_CLASS_CODE | VARCHAR2 | 30 | Unique abbreviated name assigned to a business class and used for reporting or in reference to an option. | ||
| MULTIPERIOD_CLASS_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| MPA_ACCRUAL_ENTRY_FLAG | VARCHAR2 | 1 | Not currently used. | ||
| ENCUMBRANCE_TYPE_ID | NUMBER | 18 | Encumbrance category that allows you to track your encumbrances or anticipated expenditures according to your purchase approval process and to more accurately control your planned expenditures. Examples of encumbrance types are commitments (requisition encumbrances) and obligations (purchase order encumbrances). | ||
| FUNDS_STATUS_CODE | VARCHAR2 | 30 | Not currently used. | ||
| MERGE_CODE_COMBINATION_ID | NUMBER | 18 | Not currently used. | ||
| MERGE_PARTY_ID | NUMBER | 18 | Not currently used. | ||
| MERGE_PARTY_SITE_ID | NUMBER | 18 | Not currently used. | ||
| ACCOUNTING_DATE | DATE | Yes | Date, referenced from Oracle Fusion General Ledger, used to determine the accounting period for transactions. | ||
| LEDGER_ID | NUMBER | 18 | Yes | Self-contained accounting information set for single or multiple legal or management entities. | |
| SOURCE_TABLE | VARCHAR2 | 30 | Not currently used. | ||
| SOURCE_ID | NUMBER | 18 | Identifier of the source. | ||
| ACCOUNT_OVERLAY_SOURCE_ID | NUMBER | 18 | Not currently used. | ||
| MERGE_MATCHING_MODE | VARCHAR2 | 1 | Yes | Level of merging to be done for this line. None, Dr, Cr, or All. | |
| NATURAL_SIDE | VARCHAR2 | 1 | Yes | Natural side of this line. Debit or Credit. | |
| REF_LINE_NUM | NUMBER | 18 | Line number to be used for this line in XLA_AE_LINES after grouping. | ||
| ENTERED_DR_SUM | NUMBER | Total entered debit amount for grouped line. | |||
| ENTERED_CR_SUM | NUMBER | Total entered credit amount for grouped line. | |||
| ACCOUNTED_DR_SUM | NUMBER | Sum of accounted debit amounts. | |||
| ACCOUNTED_CR_SUM | NUMBER | Sum of accounted credit amounts. | |||
| UNROUNDED_ENTERED_DR_SUM | NUMBER | Total unrounded entered debit amount for grouped line. | |||
| UNROUNDED_ENTERED_CR_SUM | NUMBER | Total unrounded entered credit amount for grouped line. | |||
| UNROUNDED_ACCOUNTED_DR_SUM | NUMBER | Total unrounded accounted debit amount for grouped line. | |||
| UNROUNDED_ACCOUNTED_CR_SUM | NUMBER | Total unrounded accounted credit amount for grouped line. | |||
| SUP_REF_STR1 | VARCHAR2 | 1000 | containing all of the supporting reference information concatenated together for use in merging | ||
| SUP_REF_STR2 | VARCHAR2 | 1000 | containing all of the supporting reference information concatenated together for use in merging | ||
| MERGE_CRITERIA_STR | VARCHAR2 | 595 | concatenated together | ||
| STATISTICAL_AMOUNT_SUM | NUMBER | Total statistical amount for grouped line | |||
| SEGMENT_VALUE | VARCHAR2 | 30 | Accounting flexfield segment used to automatically balance all journal entries for each value of this segment. | ||
| GAIN_CCID | NUMBER | 18 | Gain account for use in gain or loss lines. | ||
| LOSS_CCID | NUMBER | 18 | Loss account for use in gain or loss lines | ||
| GAIN_OR_LOSS_REF | VARCHAR2 | 30 | Contains the source value of the gain or loss reference accounting attribute that is used in adding journal lines used in gain or loss amount calculation | ||
| LEDGER_CURRENCY | VARCHAR2 | 15 | Three-digit ISO currency code of the currency that the transaction was entered in. | ||
| SUPP_REF_VALUES | VARCHAR2 | 1000 | Concatenated value of SR1 to SR30 used for grouping the similar records in balance calculation. | ||
| SUPP_REF_COMBINATION_ID | NUMBER | 18 | Identifier of the combination of additional transactional information on a subledger journal entry or line. | ||
| PERIOD_NAME | VARCHAR2 | 15 | The fiscal period a company uses to report financial results, such as a calendar month or accounting period. | ||
| SR1 | VARCHAR2 | 30 | Supporting Reference Segment 1. | ||
| SR2 | VARCHAR2 | 30 | Supporting Reference Segment 2. | ||
| SR3 | VARCHAR2 | 30 | Supporting Reference Segment 3. | ||
| SR4 | VARCHAR2 | 30 | Supporting Reference Segment 4. | ||
| SR5 | VARCHAR2 | 30 | Supporting Reference Segment 5. | ||
| SR6 | VARCHAR2 | 30 | Supporting Reference Segment 6. | ||
| SR7 | VARCHAR2 | 30 | Supporting Reference Segment 7. | ||
| SR8 | VARCHAR2 | 30 | Supporting Reference Segment 8. | ||
| SR9 | VARCHAR2 | 30 | Supporting Reference Segment 9. | ||
| SR10 | VARCHAR2 | 30 | Supporting Reference Segment 10. | ||
| SR11 | VARCHAR2 | 30 | Supporting Reference Segment 11. | ||
| SR12 | VARCHAR2 | 30 | Supporting Reference Segment 12. | ||
| SR13 | VARCHAR2 | 30 | Supporting Reference Segment 13. | ||
| SR14 | VARCHAR2 | 30 | Supporting Reference Segment 14. | ||
| SR15 | VARCHAR2 | 30 | Supporting Reference Segment 15. | ||
| SR16 | VARCHAR2 | 30 | Supporting Reference Segment 16. | ||
| SR17 | VARCHAR2 | 30 | Supporting Reference Segment 17. | ||
| SR18 | VARCHAR2 | 30 | Supporting Reference Segment 18. | ||
| SR19 | VARCHAR2 | 30 | Supporting Reference Segment 19. | ||
| SR20 | VARCHAR2 | 30 | Supporting Reference Segment 20. | ||
| SR21 | VARCHAR2 | 30 | Supporting Reference Segment 21. | ||
| SR22 | VARCHAR2 | 30 | Supporting Reference Segment 22. | ||
| SR23 | VARCHAR2 | 30 | Supporting Reference Segment 23. | ||
| SR24 | VARCHAR2 | 30 | Supporting Reference Segment 24. | ||
| SR25 | VARCHAR2 | 30 | Supporting Reference Segment 25. | ||
| SR26 | VARCHAR2 | 30 | Supporting Reference Segment 26. | ||
| SR27 | VARCHAR2 | 30 | Supporting Reference Segment 27. | ||
| SR28 | VARCHAR2 | 30 | Supporting Reference Segment 28. | ||
| SR29 | VARCHAR2 | 30 | Supporting Reference Segment 29. | ||
| SR30 | VARCHAR2 | 30 | Supporting Reference Segment 30 | ||
| SR31 | VARCHAR2 | 30 | Supporting Reference Segment 31. | ||
| SR32 | VARCHAR2 | 30 | Supporting Reference Segment 32. | ||
| SR33 | VARCHAR2 | 30 | Supporting Reference Segment 33. | ||
| SR34 | VARCHAR2 | 30 | Supporting Reference Segment 34. | ||
| SR35 | VARCHAR2 | 30 | Supporting Reference Segment 35. | ||
| SR36 | VARCHAR2 | 30 | Supporting Reference Segment 36. | ||
| SR37 | VARCHAR2 | 30 | Supporting Reference Segment 37. | ||
| SR38 | VARCHAR2 | 30 | Supporting Reference Segment 38. | ||
| SR39 | VARCHAR2 | 30 | Supporting Reference Segment 39. | ||
| SR40 | VARCHAR2 | 30 | Supporting Reference Segment 40. | ||
| SR41 | VARCHAR2 | 30 | Supporting Reference Segment 41. | ||
| SR42 | VARCHAR2 | 30 | Supporting Reference Segment 42. | ||
| SR43 | VARCHAR2 | 30 | Supporting Reference Segment 43. | ||
| SR44 | VARCHAR2 | 30 | Supporting Reference Segment 44. | ||
| SR45 | VARCHAR2 | 30 | Supporting Reference Segment 45. | ||
| SR46 | VARCHAR2 | 30 | Supporting Reference Segment 46. | ||
| SR47 | VARCHAR2 | 30 | Supporting Reference Segment 47. | ||
| SR48 | VARCHAR2 | 30 | Supporting Reference Segment 48. | ||
| SR49 | VARCHAR2 | 30 | Supporting Reference Segment 49. | ||
| SR50 | VARCHAR2 | 30 | Supporting Reference Segment 50. | ||
| SR51 | VARCHAR2 | 30 | Supporting Reference Segment 51. | ||
| SR52 | VARCHAR2 | 30 | Supporting Reference Segment 52. | ||
| SR53 | VARCHAR2 | 30 | Supporting Reference Segment 53. | ||
| SR54 | VARCHAR2 | 30 | Supporting Reference Segment 54. | ||
| SR55 | VARCHAR2 | 30 | Supporting Reference Segment 55. | ||
| SR56 | VARCHAR2 | 30 | Supporting Reference Segment 56. | ||
| SR57 | VARCHAR2 | 30 | Supporting Reference Segment 57. | ||
| SR58 | VARCHAR2 | 30 | Supporting Reference Segment 58. | ||
| SR59 | VARCHAR2 | 30 | Supporting Reference Segment 59. | ||
| SR60 | VARCHAR2 | 30 | Supporting Reference Segment 60. | ||
| SUBLEDGER_XCC_COMPLETE_STATUS | VARCHAR2 | 1 | Subledger Budgetary Control Status | ||
| PARTITION_GROUP_CODE | VARCHAR2 | 15 | Partition grouping information which determines the database partition in which large accounting entries will be stored temporarily for processing by the accounting engine. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| XLA_FSN_GROUPING_GT_N1 | Non Unique | MERGE_CRITERIA_STR, SUP_REF_STR1 |
| XLA_FSN_GROUPING_GT_N2 | Non Unique | AE_HEADER_ID, AE_LINE_NUM |