Oracle EBS R12 Journal Import Validation Process

The Oracle Apps Journal Import validates the accounting data received from other systems in the GL_INTERFACE Table. The list of  journal error lines will be published in the Journal Import Execution Report.

Batch Level Validation:

Journal Import validates the below attributes so that the  batch name available for processing should not already exist for the same Ledger Id  Period in the Oracle Apps  General Ledger application for the particular Period

  • Ledger Id
  • Period Name
  • Batch Name

Journal Level Validation:

Journal Import validates the below attributes so that the journals available for processing should have the required accounting data

  • Ledger Id
  • Period Name
  • Journal Source Name
  • Journal Category Name
  • Currency Code
  • Encumbrance type ID
  • Actual Flag
  • User Conversion Type
  • Budget Version Id
  • Accounting Date

Journal Entry Line Level Validation:

Journal Import validates the below attributes so that the journals available for processing should have the required accounting data

Account Validation ( Code Combination) : 

Code Combinations will be considered valid and journal import will be processed successfully if the below validations exists:

  • If detail posting to segment combinations are allowed
  • If code combinations are enabled for the specified accounting date
  • If  code combinations does not include summary accounts

Effective Date Validation: 

Journal Import validates if the Accounting Date is a valid business day and thus General Ledger considers it as the transaction’s effective date.  Below are the Effective Date Rule defined in oracle apps for General Ledger Accounting Date:

  • Fail:   Journal Import will Reject the transactions
  • Leave Alone: Journal Import will consider transactions regardless of the Accounting Date
  • Roll Date:  Journal Import will roll the Accounting Date  to the nearest valid business day

Descriptive Flexfield Validation:

Journal Import validates the descriptive flexfield segments depending on the particular descriptive flexfield.

  • Journals – Journal Entry Line Descriptive Flexfield
    • The descriptive flexfield global segments have valid values
  • Journals – Captured Information Descriptive Flexfield
    • The descriptive flexfield context dependent segments , descriptive flexfield context  and descriptive flexfield context dependent segments  have valid values
  • Value Added Tax Descriptive Flexfield
    • The descriptive flexfield context is set to Yes or No and descriptive flexfield context dependent segments have valid values

USSGL Transaction Code:

In case of  Public  Sector General Ledger, Journal Import validates the USSGL Transaction Code