10 Replies Latest reply on Aug 12, 2015 10:42 PM by PetePuskar

    FDMEE import format

    Venkat Chowdary

      Hi,

       

      I am strucked in creating an import format to load the data from Fusion GL cloud to Planning cloud system.

       

      When i extract an Trial Balance sheet for an entity from Fusion to load the data into FDMEE to planning, in the sheet extracted I am getting all the source dimensions members residing in only one column field.

       

      But now i have to map them to target dimension in import format.

      I cannot give all the dimensions mapped to single column of source extracted trail balance sheet.

       

      For example : 003-0000-00000-10101-000-000 this is the dimension members which i am getting from source extracted file of Trial Balance with all the dimensions members in one column.

      where 003-0000  is entity for target.

      0000 is cost center for target.

      10101-is account code for target

      000-000 are ICP.

       

      Now, how can i segregate them to map to target dimensions.

       

      Or is there any specific solution for this to create an import format.

       

      We are working on cloud environments for both Fusion erp and planning.

       

      Regards,

      Sri

        • 1. Re: FDMEE import format
          1002763

          Hi Sri,

           

          How about using the split function, refer Page 272-273 of FDMEE admin guide, check if it helps.

           

          strDelim = ";"

          strSample = "a;b;c"

          firstPos = strSample.split(strDelim)[0]

          secPos = strSample.split(strDelim)[1]

          thirdPos = strSample.split(strDelim)[2]

           

          Thanks,

          • 2. Re: FDMEE import format
            Venkat Chowdary

            Hi,

             

            Thanks for the reply,

             

            We are on cloud environment,  can you please let me know where can we write this script.

             

            I am not able to see the script editor in cloud.

             

            Regards,

            Sri

            • 3. Re: FDMEE import format
              PetePuskar

              Scripts are not available on cloud for security reasons. You don't need them, anyway. #FORMAT maps will do exactly what you want.

               

              Given your example where 003-0000-00000-10101-000-000 is the source and 003-0000 is the target entity:

               

              The entity map #FORMAT("????????") returns the first 8 characters, or 003-0000. Have fun.

              • 4. Re: FDMEE import format
                Venkat Chowdary

                Hi PetePuskar,

                 

                Thanks for reply,

                 

                Where can I write this, is it in Import format Add expression?..there I can see 2 Expression types as Fill and FillL. which one to use.

                 

                And how to write for other dimensions in source value 003-0000-00000-10101-000-000

                 

                means what should be taken when i am writing for cost account, account is at 16th level , so what should be filled at front parts .003-0000-00000-10101-000-000.

                0000 is cost center for target.

                10101-is account code for target

                000-000 are ICP.

                 

                Regards,

                Srikanth

                • 5. Re: FDMEE import format
                  PetePuskar

                  This is done in the mapping, not import format. Look in the admin guide under #FORMAT mapping. That will tell you everything you need to know.

                  • 6. Re: FDMEE import format
                    Jonathan A Cohen

                    I have been running into the same issue with a new PBCS implementation.  I've tried #FORMAT mapping, but there is a bug that prevents it from skipping (#) the first character.  Also, if you need to do other mappings on top of breaking apart the account segments, it may be difficult or impossible with #FORMAT.

                     

                    Instead I wrote a custom GL trial balance report in Fusion Cloud Financials.  The custom report,provides each segment in its own column exactly as I need it to map into Planning dimensions.

                    • 7. Re: FDMEE import format
                      Venkat Chowdary

                      Hi PetePuskar,

                       

                      Thanks for the reply, we had successfully created the #format Mappings in Mappings for Flat file regardless of source fusion configuration.

                       

                      And now we have created a source configuration and with the same #format mapping rules we are loading data from fusion GL to FDMEE, we have extracted and noted the Process ID which generates from Fusion and loading it through Load rule in FDMEE, but we are able to go forward, getting communication error.

                       

                      Please let us are we missing some thing.

                       

                      Regards,

                      Srikanth

                      • 8. Re: FDMEE import format
                        Venkat Chowdary

                        We are getting below from ODI log.

                         

                        COMM_LOAD_BALANCES (69501) fails with return code 7000.

                        ODI-1226: Step FAILED - Invalid Source System fails after 1 attempt(s).

                        ODI-1232: Procedure COMM Finalize Process execution fails.

                        Caused By: org.apache.bsf.BSFException: exception from Jython:

                        Traceback (most recent call last):

                         

                        Can you please help us.

                         

                        Regards,

                        Srikanth

                        • 9. Re: FDMEE import format
                          Venkat Chowdary

                          Hi,

                           

                          Any help please.

                           

                          Regards,

                          SR

                          • 10. Re: FDMEE import format
                            PetePuskar

                            That's a separate issue. Please mark a Correct Answer in this thread, and then start a new thread.