- OracleApps Epicenter - http://www.oracleappshub.com -

Credit Card functionality within i-expense

Is your company is in process of enabling credit card functionality within Oracle Internet Expense?

If answer is yes

It means, once the credit card functionality is enabled in i-Expense, then its allows users to select open credit card transactions and include them in their expense report. The only pre-requisite for your organization would make an agreement with the credit card company to import an electronic file of credit card transactions that summarizes employees' expenses for a period. Once the electronic file is imported and validated, employees would be able to see their credit card transactions and then select them for expensing on their expense report.

AMEX (American Express) Corporate card is most popular one normally companies providing there employee who have requirement to frequent travel or other similar requirement.

American Express Corporate Service does provide these services to there corporate customer:

  1. KR/KP-1205 Cardmember Listing Report
  2. KR-1600 Corporate Express Cash Billed Data
  3. KR/KP-1300 Monthly (Cyclic) Aging Analysis
  4. KR/KP-1301 Interim Aging Analysis
  5. KR/KP-1100 Industry Summary
  6. KR-1022 Monthly (Cyclic) Billed Reconciliation Data
  7. KR-1025 Daily Unbilled Reconciliation Data
  8. KR-1072 Line Item Detail
  9. KR-1075 Line Item Detail-Daily Unbilled

Once your company is decided, to go for AMEX Corporate Card, then Finnace IT/ERP team tries to find out the way to do integration within Oracle.From the above mentions list Oracle does only provide the direct integration for Items #7, which is KR-1025 Daily unbilled Reconciliation Data.

Item #8, 9 are treated as level 3 data, and important to know these kinds of data is not currently supported in Oracle.

Level 3 transaction data refers to the detailed transactions that constitute a single transaction line on the credit card statement. For example, a single hotel transaction can contain the detailed transactions of room charge, meals, and room service.

Not only Amexm there are few more for which Oracle does support credit card transactions data file formats in EBS:

What is offered as a feature in EBS Suite:

  1. Import Credit Card Transactions :As discussed above, if employees in your company use corporate credit cards, you can set up Internet Expenses to enable users to automatically import credit card charges from the card issuer into an expense report. Employees can also categorize each charge as either Business or Personal and, depending on your implementation, place items in dispute.
  2. Flexible Credit Card Payment and Reimbursement Setup: Internet Expenses supports several different scenarios for paying the credit card company and reimbursing employees for corporate credit card charges. You can set up your system to indicate how payment must be remitted to the card issuer. Your choices are:
  • from your organization
  • from the employee
  • from both your organization and the employee

Next will share some setup activity to enable this functionality.

25 Comments (Open | Close)

25 Comments To "Credit Card functionality within i-expense"

#1 Pingback By Many Credit Card Options » Blog Archive » Credit Card functionality within i-expense On December 26, 2007 @ 2:19 am

[…] Read the rest of this great post here […]

#2 Pingback By Credit card Understand it Better On December 26, 2007 @ 10:50 am

[…] post by Sanjit Anand Thank you for reading this post. You can now Leave A Comment (0) or Leave A […]

#3 Comment By alant On January 16, 2008 @ 2:14 am

I’m and ex Oracle employee and I used to use the functionality which worked well. The only snag was the the dump from the credit card company only turned up every 2 weeks and we were supposed to enter expenses at the end of the week, so the credit card expense transactions never turned up in time! Something to think about if you are implementing this functionality

#4 Comment By Sanjit Anand On January 16, 2008 @ 2:54 am

Thanks Alant,

I completly agreed on the point you mention, but ultimatly Customer is king, what they want we have to offer them best of the tool.Moreover, I think this is best suited for those business who has T&E is one of major area in there payable, and more over they have to wait for such data to come.I worked with Finacial sector client, couple of entity have used such functionlity and they have enhnaced the payable cycle.

Any thoughts would be welcome..

#5 Comment By Atanu Roy On February 11, 2008 @ 4:52 pm

Can you please publish the set ups steps to implement Amex credit card

#6 Comment By Sanjit Anand On February 12, 2008 @ 8:14 am

Atanu , there is one white paper in metalink, that would be good to start with.Meanwhile, I will try to see old backups might have some documents(setups and BR80/100),would try to share you..will keep forwarding to you in a day or two.

#7 Pingback By MasterCard & iExpense On April 7, 2008 @ 4:56 pm

[…] Credit Card functionality within i-expense […]

#8 Comment By Dave Sample On April 28, 2008 @ 12:45 pm

Some international companies can get billed via the KR-1025 feed in multiple currenices… i.e. some employees in CDN, some in USD. Wondering if anyone knows how Oracle i-Expense handles this case. Can a single deployement of i-Expense handle multipe AMEX bill currencies?

#9 Comment By Atanu Roy On May 4, 2008 @ 8:56 am

I have just completed implementation of Amex Credit card in I-Expense. If someone has question, I will happy to help

Thanks
Atanu Roy
Singapore

#10 Comment By sanjit On May 4, 2008 @ 3:22 pm

Dave ,

Idonot have any clue for handling multiple bills in AMEX. My understanding is AMEX will provide you the file in one currency which is defined and agreed. Still You need to check with Oracle and Amex. I worked some long time, back, they clearly mentioned they provide the amount in settled currency.

#11 Comment By Atanu Roy On May 12, 2008 @ 12:09 am

AMEX file has both transaction currency and functional currency
If somenone requires file format or have any issue on AMEX Credit Card implementtaion, may write to me at
[1]

#12 Comment By sanjitanand On May 12, 2008 @ 12:38 am

Thanks Atanu, for Confirming the amount avaiablity in both the currency. Meanwhile, If not mind, could you share some thoughts and hurdles you faced while implementation.

Thanks
sanjit

#13 Comment By sravan On June 18, 2008 @ 7:43 pm

Thanks Atanu,
i’m going to implement the AMEX cc with iexpenses in my current project
i have lot of questions for you
what is the format of the data file ,how the user import the data file to iexpense ,from where the data file will come and what are validations that needed to be performed??

regards
sravan

#14 Comment By Don Weber On August 19, 2008 @ 9:50 pm

G’day, Atanu,

I was doing some research on Oracle iExpenses and AMEX data feed integration and I saw your comments on the OracleApps Epicenter website.

My colleagues and I have a few questions, and I hope that you can assist.

Our questions are the following:

1. Did your team have to setup a program to receive an AMEX data file on your Server?

2. Did your team have to write a SQL Data Loader to move data from the AMEX data file into the Oracle iExpenses?

3. Did your team have to do any additional changes to your Oracle iExpenses workflow or Accounting?

In closing, I thank you for your time and attention to this email message, and I look forward to your reply.

Sincerely,

Don Weber, Jr.

#15 Comment By Don Weber On August 19, 2008 @ 9:53 pm

Sanjit Anand,

Any updates on the “Next will share some setup activity to enable this functionality.”

Thank you.

Don Weber, Jr.

#16 Comment By srini On September 4, 2008 @ 10:58 am

Hey Atanu,

Did you Implement the KR1205( Card Member Listing). If so Please let know and I have couple of questions.

srini

#17 Comment By Sanjit Anand On September 4, 2008 @ 4:58 pm

Srini,

as mention earlier:
KR1025 is feed from AMEX of expense charges
KR1205 –is feed from AMEX of cardholder updates

As far as my knowledge there is no seeded Oracle Program or interface that takes care of feed update from Amex file in the format 1205 into Oracle. Still advice you to check with Oracle.

-sanjit

#18 Comment By kinnu On September 8, 2008 @ 2:00 pm

Hi ,
We are also implementing the AMEX credit card transactiosn into iExpense to prepare expense reports automatically. Do you have any prog or code where we can load the data from AMEX file KR1025.dat file into sqlldr and then to upload the data from staging table into Base table. I appreciate your help
Thanks
kinnu

#19 Comment By Sunil On September 12, 2008 @ 10:27 am

We are doing a raw implement. of iexp(11.5.9).

I am looking for expert advise as to how to segregate different business rules to get aligned with Diff. Expense Templates. The other question that I had is :
Is it possible to associate an employee with a expense template so that the employee will not be allowed to choose another template.

#20 Comment By Rajesh On December 4, 2008 @ 4:05 pm

Hi,

I have a question related to AMEX card. our client has a unique requirement. They use 1 AMEX card to book all there corporate travels. The booking is done throught an American Express booking agent. At the end of the week, my client downloads the KR1025 from AMEX site. The booking agent send them a file with details of all the bookings made. They use this booking file to may the transactions in the KR1025 to single users (the people who have travelled). By doing this the users can see only there transactions when they log on to iexpense to submit expenses.

my question is, i was looking at the AP_CREDIT_CARD_TRXNS_ALL table and there is no such field to do the mapping and also i think oracle looks for 1-1 relationship when it comes to credit cards for employees. does anyone have any idea how i can do this ??

#21 Comment By My On May 20, 2009 @ 7:02 am

i want to know is there any profile to default project number in internet expenses instead of selecting manually. If any one have any idea please advice.

#22 Comment By Sanjit Anand On May 22, 2009 @ 1:00 pm

just try these two

1.IEXP: Enable Projects profile option is set to ‘Yes’.
2.PA: Allow Project Time and Expense Entry profile option is set to ‘Yes’.

Check the details in user guide

sanjit

#23 Comment By Don Lastine On June 17, 2009 @ 5:16 pm

Where can I find the table layout for vcf4 files? I’ve Googled for quite a while with no luck.

#24 Comment By Krishnan On July 23, 2009 @ 1:52 pm

Can someone provide me a sample KR1025 file. The one that i have have format issues due to which i am not able to load the data. Please Help.

#25 Comment By Dhas On June 14, 2010 @ 10:39 pm

Can any one mail me the details of accounting entries relating to Credit Card functionality with in iExpenses to my mail id [2].