![]() ![]() The list of FBDi templates is found here:īI Publisher reporting allows us to run custom SQL statements against the ERP Cloud Database. For the best results, a user has to be rigorous in Excel to ensure the data is correct before loading. This can mean going back to the beginning and checking your source spreadsheet, making corrections and repeating the upload process.Įnd to end, this process can be tricky and time consuming to get right. This should always be reviewed, and issues may require resolution. The second process usually provides an output report listing data loaded along with any errors. Optionally, run a second Import process to validate and import the data into the final destination tables, e.g.Prior to job submission, your source file is staged onto Oracle’s Universal Content Management server (UCM) and the job kicks off subprocesses to transfer this to the Oracle database and run SQL*Loader. Run Load Interface File for Import to stage your file into an Open Interface table, e.g.The number of jobs and submission process may vary depending on the business objects, but a typical flow is to: ![]() Having got this far, and assuming you have executed due diligence to make sure values are valid (for example by using VLOOKUP), the upload process consists of running Enterprise Scheduler Service (ESS) jobs in Oracle to transfer and load the file. From a technical perspective, you can create the CSV file directly and zip it up yourself, but there are a number of things to look out for - the order of fields in the spreadsheet doesn’t always match the CSV generated by the macro, and the CSV filenames must remain consistent to the Oracle-generated names for some of the loads. Once data has been entered, an Excel macro is kicked off using a button on the first tab to build a zip file. Most fields are optional others are conditionally required which can cause confusion. Data is entered into the spreadsheet tabs manually but there is no live validation comments in each column header give guidance on how to fill each field but as there are many fields in each sheet, this can be challenging for an end user to work with. ![]()
0 Comments
Leave a Reply. |