My Oracle Support Banner

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

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