Accounting Sequencing Context: Posting - GL Journal Entry Cannot Assign Sequence Not in the List of Values (Doc ID 2681696.1)

Last updated on MARCH 07, 2023

Applies to:

Symptoms

Attempting to assign the same document sequence to two accounting sequence contexts:

GL Period Close - GL Journal Entry
GL Period Close - Posting

Once the sequence is assigned to one of the sequence context it is no longer available to choose to assign to the other sequence context. It does not display in the sequence list of values to assign.


Replication Steps:
1) Sign into Oracle General Ledger and navigate as follows: 
     Setup > Financials > Sequences > Accounting > Define.

2) Define a sequence to be used as an accounting sequence.

3) Assign the sequence to a sequencing context GL Period Close - GL Journal Entry as follows:
     Setup > Financials > Sequences > Accounting > Assign (or select the assignments tab if already in the Accounting Sequence form).

    a) Select Create button.
    b) Populate the Accounting Sequence name, Context information of Ledger Name, Sequence Entity (in this example GL Journal Entry) and Sequence Event (in this example GL Period Close).
    c) Choose processing Options and Balancing Segment values as needed. Apply and a confirmation message will be provided the the sequencing context has been created successfully.
    d) Query the newly created Sequencing Context, select Assign Sequences.
    e) Select the green plus icon to assign the sequence defined in step 1 above. In the Sequence name field select the List of values icon, query the sequence name and select it.
    f)  Populate the Start date, End date, Document Category, Balance Type, Journal Source, Journal Category etc as needed, then select the apply button. 

4) Attempting now to assign the same sequence created in step 1 to Sequence Context - GL Period Close - Posting as follows:
    Setup > Financials > Sequences > Accounting > Assign (or select the assignments tab if already in the Accounting Sequence form).

    a) Select Create button.
    b) Populate the Accounting Sequence name, Context information of Ledger Name, Sequence Entity (in this example GL Journal Entry) and Sequence Event (in this example Posting).
    c) Choose processing Options and Balancing Segment values as needed. Apply and a confirmation message will be provided the the sequencing context has been created successfully.
    d) Query the newly created Sequencing Context, select Assign Sequences.
    e) Select the green plus icon to assign the sequence defined in step 1 above. In the Sequence name field select the List of values icon, query the sequence name and find it does not exist in the List of values.
        Due to this it cannot be assigned to this Sequence Context.

Changes

 New setup of Accounting Sequences.

Cause

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