How to read Contact details from an Account using Groovy script (Account - Contact Relationship)?
(Doc ID 2176535.1)
Last updated on APRIL 26, 2021
Applies to:Oracle Fusion Sales Cloud Service - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
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).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document