Data Is In XLA Tables (Subledger Accounting) But Is Not Picked Up to Be Transferred to GL

Problem:

When running Transfer Journal Entries to GL program it is not picking up any transaction to transfer

 Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Created an invoice and run 'Create Accounting Program' with Mode as Final and Transfer to GL as No.
2. Now the data is sitting in XLA_AE_HEADERS with GL_TRANSFER_STATUS_CODE as N and ACCOUNTING_ENTRY_STATUS_CODE as F.
3. Submit Program 'Transfer Journal Entries to GL Program' Find that this program does not pick up the entries to transfer them to GL.




Cause:

In GL responsibility Transfer to GL was set as No for Receivables.

Following Query output shows that it was set as no.

select SUBMIT_TRANSFER_TO_GL_FLAG
from XLA_SUBLEDGER_OPTIONS_V
where application_id = '&application_id'
and ledger_id = '&ledger_id';

SUBMIT_TRANSFER_TO_GL_FLAG
-
N





 





Solution:

1. Navigate to GL responsibility of the Ledger > Setup > Financials > Accounting Setup Manager > Accounting Setups
2. Search for the Ledger the problem exists
3. Click on Update Accounting Options button
4. Click on Update Button of Subledger Accounting Options for that Ledger
5. Click the Update Accounting Options Button for the Application Receivables.
6. Change the Transfer to GL Box to Yes and Apply.
7. Submit the Transfer Journal Entries to GL concurrent program again