4 Replies Latest reply on Dec 19, 2016 5:36 AM by JanGLi

    Write-Back into Custom table




      Is it possible to write-back into custom ebs tables using UDA or Open Interface Adapter?

      Or do we have to do export csv using FDMEE and load it into our required table?


        • 1. Re: Write-Back into Custom table

          The write back functionality is covered in the FDMEE admin guide  in detail thus you may want to revisit to ensure you are fully clear on what Oracle supports out of the box. It is to a specify set of ERP versions and is based on the standard out of the box FDMEE direct ERP connection setup.

          The general way to write back to non out of the box supported systems is to produce a flat file(Defined again in the FDMEE admin guide) and then load that flat file to your custom source system.


          As always if there is functionality that you want that is not in the software go ahead and open an Oracle SR and log an enhancement request.

          • 2. Re: Write-Back into Custom table

            I did went through Admin guide but i couldn't find anything related to write-back using UDA that is why i raised a question here.

            SR said that you can write directly back to custom table using UDA but i think they aren't sure about it them self. Plus the SR is still in progress.


            Can you just confirm that if it is possible or not and according to admin guide it isn't possible? or at least i can't find it.


            • 3. Re: Write-Back into Custom table

              Question answered in first post based on the Oracle documentation reference.

              Second your setup is only known by you not members on the board. All responses are based on the general information you provided.


              Notably if you are asserting that the Oracle Engineers themselves specifically told you you can "directly write back to custom table using UDA"  then certainly they would provide you precise direction and/or updated FDMEE documentation reference on doing such.Oracle is the vendor not members on the board .

              Also you may want to raise a documentation bug as that level of detail in terms of UDA write back does not appear to be laid out in the documentation.


              Ensure you are looking at the most updated FDMEE admin guide. The updated admin guide even has a table showing the out of the box supported systems.

              The FDMEE  admin guide( references direct integration write back rules for the standard direct erp out of the box connection setup.


              As mentioned in the first post the approach to get data back to systems not under the standard FDMEE direct setup is the Write-back  available to a file-based source system. As always you can seek to build a custom process/routine to your system but of course that is up to you to define and setup.


              Other experts may certainly provide their input.


              Good luck and do let us know how you finalize.

              • 4. Re: Write-Back into Custom table

                Thanks answering.

                Really helpful.