Need To Access All Sales Orders Of A Specific Account In OSC
(Doc ID 2396263.1)
Last updated on MAY 31, 2018
Applies to:Oracle Fusion Sales Cloud Service - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Qn1:Customer Question ( relationship_error.odt )
We have trying to query OSC Sales Order Entity to get the number of Sales Orders for a specific Account, but we are not able to accomplish that objective using the exposed services on Sales Order WSDL:
We also tried to create a Relationship, but the object is not available to be related to Account.
We have 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.
Could you please provide an alternative for this requirement?
We have a 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) . We need to use the function count, but Sales Order
hasn’t got a relationship with Account, and when we want create that relationship, Sales order
doesn’t appear in Target Object choice list.
Qn2: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!