We have a development APEX instance on once server (APEXDEV) and a second testing system (APEXUAT) that both have the same REST Data Source to an Exchange database. One works while the other generates:
ORA-40442: JSON path expression syntax error
Each server has a web credential with a dedicated Azure account (Tenant ID, Client ID, Client Secret, etc.) with the same permissions. Both have permissions to that Exchange inbox.
The synchronization was built using the same steps. As a second test, we exported the whole APEX application and moved it to the second instance to ensure it had the identical settings (except the Web Credential).
I am wondering if this has to do with the wallet path. I vaguely remember a JSON path error setting up the original system, but don't have those details. Someone else did the actual work setting it up.
Both systems have certificates in their wallets, so it should work.
Any ideas?