Forum Stats

  • 3,824,912 Users
  • 2,260,439 Discussions


Suggestion required for saved the data of REST API response

Fahed Akhtar
Fahed Akhtar Member Posts: 10 Blue Ribbon

I have the below requirements.

1) Download the inventory transactions data in json format.

2) Save the data in intermediate tables.(master/detail)

3) Push the data to Oracle EBS from intermediate tables using API.

I need community members suggestion on point 1, currently I have created one table in which json data is saved as clob column and from this column I have created a view using JOSN_TABLE.

From view I am fetching the data and then I am saving the data it in intermediate table. Is this the good approach?

I need to pick data based on business date means if one day transaction is picked then it should not picked again else data will be duplicated in view.