How to get DDL for Fusion ERP interface tables used in FBDI
We are in the process of defining strategy for data conversion for migration from PeopleSoft to Oracle Cloud ERP. One approach we are considering is to create replicas of all interface tables used by FBDI templates in a separate oracle database. This database is used as staging area for conversion and data transformation. After conversion, data from this database is exported as csv files and eventually used to import into Cloud ERP.
Now the question is how do we create these tables in our conversion database. Is there a way to generate DDL statements for these tables. Has anyone done this before ? If so what was your approach.