My Oracle Support Banner

R12: AP: Error "Message Not Found: XLA_TB_DUP_JE_SOURCE" When Creating Open Account Balance Listing (Doc ID 2921837.1)

Last updated on FEBRUARY 08, 2023

Applies to:

Oracle Payables - Version 12.2.10 and later
Information in this document applies to any platform.


Attempting to create a new "Open Account Balance Listing" for Payable module, the user is not able to add at least one "Journal Source".  The "Journal Source" column is missing from the main table of section "Open Account Balances Listing Journal Sources".

User is able to enter all information required, but the "Journal Source".

Upon trying to save the record without at least one "Journal Source", following Error raises:

Message Not found. Application: XLA, Message Name: XLA_TB_DUP_JE_SOURCE


Steps to reproduce:

  1. Log  into Oracle Applications using a Payables responsibility.
  2. Open the "Open Account Balances Listing Definitions" OAF page
    (N) Setup > Accounting Setups > Subledger Accounting Setup > Open Account Balances Listing Definitions
  3. Click on the [Create] button
    This opens the "Create Open Account Balances Listing Definition" OAF Page
    Enter values for the following fields:
    • Code
    • Name
    • Description
    • Ledger
    • Defined By = Segment
    • Balance Side = Credit
    • Enabled = Yes
  4. Under section "Definition Details", use the "add" (Green "+") icon to add Chart of Accounts
  5. Now, click on the "add" (Green "+") icon in the section "Open Account Balances Listing Journal Sources" to add a new Journal Source
    Notice the "Journal Source" field will appear, ONLY the "remove" column/icon appear.
  6. Click on the [Apply] button.  The Error appears.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.