You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to get DDL for Fusion ERP interface tables used in FBDI

Accepted answer
66
Views
2
Comments

Summary:

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!