Expenses

Get Involved. Join the Conversation.

Topic

    PRASHANT MENON
    Oracle Fusion expenses Integration Capabilities
    Topic posted July 31, 2018 by PRASHANT MENONGreen Ribbon: 100+ Points, last edited January 30, 2019, tagged Expenses, Payables 
    677 Views, 11 Comments
    Title:
    Oracle Fusion expenses Integration Capabilities
    Summary:
    Oracle Fusion expenses Integration Capabilities
    Content:

    Our existing client is not implementing Oracle Fusion expenses in Cloud.

    However, they are currently using iExpense module in R12 on ON Prem

    The requirement is to Use current Expense web application(R12 ON PREM) and integrate with Cloud for cost allocation/accounting/payments.

    Urgently, need your inputs and feasibility on the below options :

    1. Import Expense Reports to Cloud (No FBDI template present)
    2. Import AP Invoice to Cloud 
    3. Import Payment Request to Cloud (FBDI template present but project details are not there in FBDI )

    Comment

     

    • Becky Alvarez

      This is not  a recommended solution unless you plan to integrate the on premise expense solution with Cloud Expenses solution otherwise you are going to have to figure out how to pay employees in Cloud AP.  You could set them up as suppliers but you reisk violatating HIPPA laws and if you are thinking of using One Time Payments that too is a risk of violating HIPPA laws so your best option is to use Cloud Expenses to Pay out of Cloud or import the information from on prem after payment is made such as the journal entries.

      • PRASHANT MENON

        Hi Becky,

        Can you please elaborate on this point - use Cloud Expenses to Pay out of Cloud or import the information from on prem after payment is made such as the journal entries?

         
    • Becky Alvarez

      OK so maybe I misread your initial request upon rereading it, I would like to clarify, you want to import expense reports into Cloud expenses from on premise expenses, not payment requests from on premise expenses to AP correct?

      • PRASHANT MENON

        The requirement is to Use current Expense web application(R12 ON PREM) and integrate with Cloud expenses for cost allocation/accounting/payments.

        Our existing client is not implementing Oracle Fusion expenses in Cloud

        I would need your inputs and feasibility on the below options :

        1. Import Expense Reports to Cloud (Is this supported? I don’t find a FBDi template for this.)
        2. Import AP Invoice to Cloud (Process Expenses to AP Invoices in EBS and interface as AP Invoice to Cloud. Requires Employees as Suppliers in Cloud)
        3. Import Payment Request to Cloud (Process Expenses to AP Invoices in EBS and interface as Payment Request to Cloud. Does NOT require Employees as Suppliers in Cloud)
        • Rajasrinivas Adaikalam

          Using option one, you can import the expense report using webservice (If at all the organizations has capability) into saved status and then import the invoices using seeded Expenses import program. This needs setup of expenses in Fusion cloud.

           

    • Becky Alvarez

      Thanks. Sorry for the brain lapse.  Here are my inputs.

      1. Import Expense Reports to Cloud (Is this supported? I don’t find a FBDi template for this.) - without Cloud expenses this would not work because there would be no way to process them and  convert to AP invoices.
      2. Import AP Invoice to Cloud (Process Expenses to AP Invoices in EBS and interface as AP Invoice to Cloud. Requires Employees as Suppliers in Cloud) - Feasible but not recommended due to HIPPA concerns.
      3. Import Payment Request to Cloud (Process Expenses to AP Invoices in EBS and interface as Payment Request to Cloud. Does NOT require Employees as Suppliers in Cloud) - Also feasible but employee payee and payment information is stored and veiwable under Manage Invoices for editing and reporting purposes since this feature was not designed to be used to pay expenses in place of  the Cloud Expense module so also not supported/recommended due to HIPPA concerns.

      My only recommendation is, if you want to pay employee expenses out of the Cloud, implement Cloud Expenses and import the expense reports from on-prem expenses to Cloud Expenses and process through to AP from Cloud Expenses.  This will generate a payment that is not viewable outside the Expense Module and does not violate HIPPA laws.

      • PRASHANT MENON

        Believe, we do not have the FBDI template to load expense report, then how will Option 1 will work then..

        and secondly what challenges we face considering the integration challenges, reporting requirements for non-compliance/GL reporting, re-class of charge accounts, termination of employees, etc.

    • Becky Alvarez

      FBDI is not the only integration option in Cloud, there are other options like SOAP Web Services which do support importing expense reports.  As for your other challenges, what were your initial plans when you started considering this project for these?  All of the options you presented generate GL entries and will require you to maintain the chart of accounts between the two as well as employees as you will have users in both systems.  Cloud has Web Services, DRM, and FBDI solutions for GL and employee information.  I think employee information is handled through mainly through Web Services.  

      I am not in a position to comment specifically on any solution because I am not a consultant I am in development strategy, and I don't know enough about the environment, requirements, etc. you are working in to provide viable recommendations.  I am just telling you what we recommend and that we recommend it because the customer can get in big trouble if they improperly expose sensitive employee information.  You can choose whatever path you want but the easy path may risk law suits down the road.

       

    • Joe Gum

      Why would they implement Financials Cloud and not implement Expenses?

    • Becky Alvarez

      I should probably correct myself here.  It would not be HIPPA violations as you would not be showing confidential medical information it would be PIP violations which is personal information privacy violations.