Oracle (EBusiness Suite 11i/R12) – Concur Expense Integration.
Are you using Concur cloud application for expenses and want to post expense data into your oracle application General
No Problem, we can help you for this automation.
Just follow following steps to import and post Concur Expenses data into GL module.
STEP 1. Contact Concur support team to get sftp access.
STEP 2. Create a Monthly/Weekly/Daily expense report.
STEP 3. Schedule Monthly/Weekly/Daily expense report and point report output to your sftp location.
STEP 4. Write a shell scriptget_
concure.sh (if oracle application on Linux/Unix)
or Batch program get_concure.bat (if oracle application on Windows)
4.1 Downloading Concur Expenses SAE data file from sftp location.
4.2 Calling gpg command line utility to decrypt SAE data file.
STEP 5. Write a PL/SQL package (XX_CONCUR_PKG)
5.1 Calling shell script/Batch Program (Calling OS Command from PL/SQL)
5.2 Reading Decrypted SAE data file and dumping data into staging table
5.3 Importing GL Currency conversion rate using Web Service API.
5.4 Running data validation for GL Code Combination, Currency rate etc
5.5 Creating GL_INTERFACE data from staging table
5.6 Submitting “Journal Import” concurrent program
5.7 Sending email alert to internal users with SAE data file attachment
Now your integration program is ready to go.
Define a concurrent program and schedule it Monthly/Weekly/Daily.
Ref : http://blog.optiosys.com/?p=325