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

Last updated on SEPTEMBER 28, 2023

Applies to:

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

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