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 220.127.116.11.0 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