Journal Import Error : Rejected-Error ontable GL_INTERFACE, column LEDGER_ID ORA-01722: invalid numb
We are importing Journals relating to Payroll from a third party application via UCM.
The in bound Journals File has Journal lines with Ledger Name. LEDGER_ID is null.
We believe Journal Import Job can derive LEDGER_ID from LEDGER_NAME. However
Oracle GL interface File Processing Failed with below error :
Record 1: Rejected - Error on table GL_INTERFACE, column LEDGER_ID.
ORA-01722: invalid number
We like to import the Journals via a FBDI template
Is LEDGER_ID mandatory when LEDGER_NAME is available?
Can LEDGER_ID be NULL as system is expected to derive the same via LEDGER_NAME ?