My Oracle Support Banner

Need To Access All Sales Orders Of A Specific Account In Oracle Engagement/Sales Cloud (Doc ID 2396263.1)

Last updated on MAY 13, 2022

Applies to:

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


Trying to query Sales Order Entity to get the number of Sales Orders for a specific Account, but not able to accomplish that objective using the exposed services on Sales Order WSDL:

Tried to create a Relationship, but the object is not available to be related to Account.
Not been able to create triggers on the Sales Orders to update a field in the Account record, every time a Sales Order is created.

Please provide an alternative for this requirement?

Requirement to show a message through a trigger, which shows the quantity of account’s orders. That information can be found in the subtab “Quotes and Orders” from the Account object.
( that subtab comes from Sales order object) . Need to use the function count, but Sales Order has not got a relationship with Account, and when want create that relationship, Sales order
does not appear in Target Object choice list.
How To Create Relationship between Account and Sales Order object?


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

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