Error :ORA-00904 In REST Webservice Response

(Doc ID 2366391.1)

Last updated on FEBRUARY 27, 2018

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms