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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Automate Load & Purge of UDT on Daily basis using HDL or PBL ?
Summary
Load UDT Tables daily using Data Extracted from BI report & then Purge itContent
We Need to replicate Stage Table Processing from EBS to Cloud, for this we are planning to use UDT as our stage tables, Now we have written a BI report to generate HDL file to load UDT data, but we need to Automate Invocation of HDL Process on daily basis such that it picks generated DAT file from UCM/FTP & loads UDT tables, we are also planning to flush tables with new data , for that we are planning to use PBL to purge UDT tables by passing UDT Name.
4