This post was put together to HIGHLIGHT some undocumented Clarify features I have learned over the years.. Ie. GetEdiLogsForConnection
Requirement: When outbound x12 810 data is sent from an outbound Connection Business Process we want to add the x12 EDI Interchange control number to the JDEdwards 810 header table (F47046).
The ICN is not available until after the enveloper process. At this point, we lost the ‘connection’ between the original document and the actual outbound file.
Solution: The process below allows us to trace back to the original document and add the ICN to F7046.DEL1
STEP 1: Connection Business Process
We will invoke the GetEdiLogsForConnection task and the connectionLogId will be passed in from the enveloper
The TRICK: To execute GetEdiLogsForConnection we will need to add the task below via text Editor
new com.extol.ebi.lib.user.logs.GetEdiLogsForConnection().execute(eDIStorageID, connectionLogId)
} next : end
STEP 2: Ruleset
In the ruleset (ABOVE) we will retrieve the following from the ClarifyEdiUserLogs
User_Reference_1 is the EDOC that we will use to find the respective F47046 record.
Once these two values are identified we will map them to the the target fields. Once mapped we will then perform the Database Adapter Update process, we call after the ruleset task in the BPS.
If you have more questions about undocumented processes, please feel free to CONTACT US.
By: Sean Hoppe on