Weekly data load into projects
We need to load projects and tasks through weekly feed from legacy system.
Is/are there API/APIs for this?
I did some research and found that there is an API AMG API for initial data conversion. But it is a separate product and not a pat of Oracle projects and hence needs license.
Here is some more info on our requirement/plan:
We will be sending the projects and task details in the format required by oracle for loading into pa_projects, pa_tasks thru flat file.
We will use ODI to extract data from legacy system, but need to know if there is an API that we can call to load it into standard oracle projects tables.