GL_INTERFACE, column LEDGER_ID. ORA-01722: invalid number Error
Summary:
Using OCI to transfer data into Fusion GL tables but got his error: Record 1: Rejected - Error on table GL_INTERFACE, column LEDGER_ID.
ORA-01722: invalid number. Does anyone know what is the cause or propose a solution. The LEDGER_ID field has a value and so does the LEDGER_NAME field. both values are validated as being correct and used by other operating units
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):