EEX 9.2: Expense Processing Allowing Partial Stage Of An Expense Report And Marking Partially Paid Expense Report To Paid (Doc ID 2941552.1)

Last updated on APRIL 12, 2023

Applies to:

Symptoms

Expense Processing  partial staging of an Expense Report and marking partially paid Expense Report To Paid

Setup:
1. Setup Direct Deposit sync Between HCM and FSCM integrated environments.
       a. Make Sure Service Operation (DIRECT_DEPOSIT_SYNC) is Active , Handler is Active and Routing has been setup. In HCM it should be Outbound and in FSCM it is Inbound.
              Navigation : PeopleTools > Integration Broker  > Integration Setup > Service Operation
       b. On General tab , cllick on "View Queue" and make sure Queue Status is set to "Run".
2. In FSCM - Make sure Default Payment Method in Expenses Installation Option is ACH
      Navigation:  Setup Financials/Supply Chain >  Install > Installation Options - Expenses
3. In FSCM - Take any employee and Make sure he has a Credit Card added in his profile that is no expired.
      Navigation:  Travel and Expenses > Manage Employee Information > Update Employee Detail - Corporate Card Information

Steps:
In HCM
1. Log in as a User of same Employee ID that we identified in above setup.
2. Go to Payroll for North America > Employee Pay Data USA > Request Direct Deposit
3. Add a new Direct Deposit account and save it
      -- This triggers IB message DIRECT_DEPOSIT_SYNC and Data gets sync to FSCM environment in PS_DIRECT_DEPOSIT record
In FSCM
4. Log in as a user
5. Go to Travel and Expenses > Manage Employee Information > Load Employee Data and run the process with all the options enabled.
6. Go to Travel and Expenses > Manage Employee Information > Update Employee Detail , search with Employee ID  and Review Bank Account  tab
      -- Direct deposit  Account added to employee profile with default Payment Method of ACH
In HCM -
7. Log in as a User of same Employee ID that we identified in above setup.
8. Go to Payroll for North America > Employee Pay Data USA > Request Direct Deposit
9. Now delete the same account in HCM and save
      -- Again this triggers IB message DIRECT_DEPOSIT_SYNC and Data gets sync to FSCM environment in PS_DIRECT_DEPOSIT record
In FSCM
10. Log in as a user
11. Go to Travel and Expenses > Manage Employee Information > Load Employee Data and run the process with all the options enabled.
12. Go to Travel and Expenses > Manage Employee Information > Update Employee Detail , search with Employee ID  and Review Bank Account  tab
      -- Direct deposit  Account deleted from employee profile but default Payment Method remains ACH , based on the setup from installation option.
13. Go to Employee Self Service (Fluid) > Expense Report (Tile) > Create Expense Report (Tile)
14. Create and Submit an Expense Report with more than one line , one with cash payment and other with Credit Card payment.
15. Get the Expense Report Approved by the Approvers.
16. Go to Travel And Expenses > Process Expenses > Expenses Processing , Open it for Run Control.
17. Select only "Stage Payment" check box and run the process.

• Process Partially staged the Expense Report . Expense Report Line (Table PS_EX_SHEET_LINE) for employee payment (cash) remains in APY as employee doesn't have default account for ACH payment method.

18. Pay the staged Expense Report using PayCycle.
19. Repeat the Steps 1-3 in HCM to add account to employee profile again.
20. Repeat the Steps 16-17

• Its not staging the employee payment line even if now employee doesn't have default account for ACH payment method.

21. Go to Travel And Expenses > Process Expenses > Expenses Processing , Open it for Run Control.
22.  Select only "Update Paid Statuses" check box and run the process.

• It is updating the Expense Report Header and Paid Credit Card Line to Paid even if the other line is not paid.
  
  

•  For Staging process:       Either Expense Report should not be partially staged   OR  It should let stage employee payment when other lines supplier/Credit Card payment is already paid
•  For Update Paid Status:   Process should not update the Status to Paid until both the lines are paid
  
  

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps PDF Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.