My Oracle Support Banner

ORA-00904 In REST Webservice Response (Doc ID 2366391.1)

Last updated on DECEMBER 22, 2020

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

On : 11.12.1.0.0 version, Partner Management

Error in REST webservice response


Below REST call is throwing an error
https://host/salesApi/resources/latest/partners/OSC104003/child/PartnerProfilePEO_AssociateProgramEnrollmentCollection_c?fields=Id,Partner_Id_c,RecordName,APEProgramType_c,ProgramStatus_c&onlyData=true&limit=500

Error:
ORA-00904: "ORGANIZATIONDEO"."ORGANIZATION_PROFILE_ID": invalid identifier

If the same REST call is placed without the "fields" parameter it is returning results.
https://host/salesApi/resources/latest/partners/OSC104003/child/PartnerProfilePEO_AssociateProgramEnrollmentCollection_c?onlyData=true&limit=500


 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.