Regarding Master Data (customer master/vendor master/bank master, etc) do we need to keep/extract this data in some staging area/custom table for data cleansing and then upload using FBDI / ADI Template to Fusion?
Please advise.
Regards,
Salman
Hi Salman,
You may create a custom report (in FBDI format for uploading in Oracle Fusion).
Standard Cases
The SQL query should handle data conversion, including change of values based on mapping sets, logics, new design in Oracle Fusion, etc.
Exceptional Cases
It is advisable to add decodes wherever applicable in the SQL query to ensure that exceptional master data for which no logics are available are handled by the code rather than manually post extraction of report.
Loading in Oracle Fusion
Post finalization of data, the same shall be uploaded via Oracle FBDI templates. This data is first loaded into a staging table called as Interface Table and then imported to Oracle base tables post validations.