Unable to copy prior period adjustments to current reconciliation
Summary
Unable to copy prior period adjustments to current reconciliationContent
In our Production instance, we are unable to copy prior period adjustments to the current month's reconciliations. We get the following error:
The following exception has occurred in ADFUtils.invokeApplicationModuleMethodWithErrorHandling(): java.lang.RuntimeException with message: java.sql.SQLSyntaxErrorException: ORA-00904: "C_100000063707977": invalid identifier
There's more technical details within the error message, but I think this is the primary error message. We tried restarting the service but issue persists. We tried deleting and recreating the reconciliation but issue persists.
Is anyone else experiencing this behavior in their Production instance? If so, did you raise an SR or were you able to fix/get around the error? We are not experiencing this behavior in our Test instance.