We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Journal Import Error : Rejected-Error ontable GL_INTERFACE, column LEDGER_ID ORA-01722: invalid numb

Received Response
2
Views
2
Comments

Summary:

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

Question (required):

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 ?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!