How to read Contact details from an Account using Groovy script (Account - Contact Relationship)? (Doc ID 2176535.1)

Last updated on AUGUST 26, 2016

Applies to:

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

Goal

Customer has OSC integrated with EBS.

Users are creating Accounts and in the same time they are creating the Contact that will be associated (as Primary Contact) with this Account.

The goal is to read the newly created Contact details from the Account object using a Groovy script that will further use an object function to integrate the data in EBS (Account and Contact Relationship details).

Initially an After Changes trigger was used that managed to read related Contact details but if any special character was entered in the Account Name would generate application errors.

The script was split and used as a Before Insert trigger and the application errors were no longer thrown regardless of the special characters entered in the Account Name (ex. %$#!@#';\] > no validation is used on the Account Name) but the Account - Contact Relationship part of the script was no longer read/processed.

The goal is to optimize the script in order to read Contact details from the Account associated (Account Contact Relationship).

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