You did not give many details about the techinical approach, but I agree that your approach sounds reasonable. Based on your reference to "Update" and "Create" I will guess that you are planning to use DECS. You should take a careful look at the process used within Oracle HR to perform the tasks you've mentioned. While Lotus provides a Connector for Oracle Apps, that Connector works with Financials only. To integrate with the HR module you will have to use one of the Oracle Connectors, either for O7 or O8. Typically, ERP packages, like Oracle Apps, invoke a large amount of business logic for even the simplest tasks. If you must work directly against the underlying data table, be sure you adhere to the rules of the application. If you break or even bend any of these rules they might come back and bite you with bad data.
Related Q&A from Scott Lemieux
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.