Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Validating input file from HDL Transformation Fast Formula

edited Jul 30, 2020 6:57AM in HCM Integrations 7 comments

Summary

How to validate trailer record of input file before processing the detail records

Content

Hi Experts,

We have a requirement to validate the input file before loading, please let me know if we can achieve this in HDL FF.

The input file contains header record, detail record and trailer record. The trailer record will have the count of detail records and sum of the amount that is coming in the detail records. The validation is, if the count and sum of amount is not matching, we dont have to process the file. Please let me know is there a way to handle this in HDL FF?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!