Results 1 to 6 of 6

Thread: SAE file from Concur

  1. #1
    New Member
    Join Date
    Nov 2002
    Posts
    42

    SAE file from Concur

    Hi all,

    has anyone gone through the Concur to JDE integration? I can understand that we would populate both the F0911Z1 & F0411Z1 but how do this for with the SAE file?
    thanks
    E1 9.1 update 2 Oracle

  2. #2
    Hi spgp, I'm about to do exactly that.

    we already have integrated data export from JDE to Concur for employee's and char of account files.

    The plan is to download the SAE file from concur using a BSSV that will basically connect to the sftp, download pgp encrypted file, decrypt it, and insert the data in tables F0411Z1 and F0911Z1 then launch the report R04110ZA.

    If you have a functionnal orchestrator, you could probably do the same using groovy (or java, juste a little harder to deploy) to download and decrypt the file, then convert it to xml. so it can be passed to an orchestration.

  3. #3
    Our clients use our pre-built business processes for AP and GL to bring the SAE extract into E1 in real time through web services with full error handling (no Z-tables). Let me know if you need more information.
    Regards,

    Hari Sharma
    Aellius
    EnterpriseOne: Integration (.Net, Web Services) | Output Management | Monitoring

  4. #4
    Member
    Join Date
    Apr 2003
    Location
    Ohio, USA
    Posts
    405
    I integrated SAE to JDE via the z-files for a previous company a number of years ago (on Xe). The trick is understanding the SAE format and figuring out how to map it to JDE. Some of this will vary based on how your company configured Concur. Private message me if you want to talk more about the SAE format.
    Ellen Deak
    Sr. Software Developer
    Dealer Tire
    EnterpriseOne (E920), Tools 9.2.2.4, IBM DB2 V7.2, Create!form 8

  5. #5
    New Member
    Join Date
    Nov 2002
    Posts
    42
    Hi all,
    Some good advice here. Yes the mapping is a bit tricky as I have no test data from concur and how their expense accounts will be delivered to us.

    Thanks
    Sam
    E1 9.1 update 2 Oracle

  6. #6
    New Member
    Join Date
    Nov 2002
    Posts
    42
    HI,
    can i ask which BSSV you are using?
    thanks
    E1 9.1 update 2 Oracle

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.