Querying DDS From A PL SQL Package - Error 'ORA: 20987' unrecognized identifier : FDX_RIHA_PROCESS
(Doc ID 2965713.1)
Last updated on AUGUST 08, 2023
Applies to:
Oracle Retail Integration Cloud Service - Version 23.1 and laterInformation in this document applies to any platform.
Goal
Need help querying DDS from a PL SQL Package.
<ENVIRONMENT_URL>/dynamic-data-service-web/resources/dds/RIB_RMS1/data?fromTables=RIB_MESSAGE t0,RIB_MESSAGE_FAILURE t1&columnFilter=t0.MESSAGE_NUM,t0.FAMILY,t0.TYPE,t0.MESSAGE_DATA,t1.DESCRIPTION&rowFilter=t0.MESSAGE_NUM=t1.MESSAGE_NUM and t0.MAX_ATTEMPTS=t1.SEQ_NUMBER+1 &offset=0&pageLimit=25
This returns the error:
'ORA: 20987' unrecognized identifier : FDX_RIHA_PROCESS
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |