ADF Service: Opportunity Service (11.1.9.0.0) Ability To Create Child Record On Existing Opportunity (Doc ID 2041679.1)

Last updated on SEPTEMBER 03, 2015

Applies to:

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

Goal

How we can use the Opportunity Service to create a child record to an existing Opportunity record?

Need to be able to get the Project ID from EBS and store it in a child object in Opportunity.
The context of this is that, Won Opportunities become Projects in EBS.
There is an outbound interface from OSC to EBS for sending out the Opportunity details, then an inbound interface for storing the newly generated Project Number/Id in a Child Object called "OpportunityProjects"

Have the following findings:
1. updateOpportunity – requires us to have an existing child Project record in the Opportunity and then the web service can update the existing Project record. It does not allow creation of child records for an existing opportunity record. An option is to manually create a new Project record with a default Project Number and then allow the webservice to update once the actual Project Number is created in EBS.
2. createOpportunity – will insert an entirely new opportunity record together with a child project, but not allow child object to be created for an existing Opportunity, so this may not be useful.
 

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