Error: ORA-01790 When Running Remittance Batch Management Report
(Doc ID 2021576.1)
Last updated on DECEMBER 04, 2019
Oracle Receivables - Version 12.1.3 and later Information in this document applies to any platform.
Attempting to run the Remittance Batch Management Report and it fails with the following error:
ORA-01790: expression must have same datatype as corresponding expression ==> decode(acr.selected_remittance_batch_id,null REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error: REP-300: expression must have same datatype as corresponding expression ==> decode(acr.selected_remittance_batch_id,null
Steps to Reproduce: Responsibility: Receivables Navigation: Control > Requests > Run 1. Select Single Request 2. Select Remittance Batch Management report
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!