R11i: R12: OIE: Credit Card Transactions Inactive Employees Process Is Not Updating Supervisor To Allow For Submission Of Unused Transactions for Inactive Employee
Last updated on DECEMBER 01, 2017
Applies to:Oracle Internet Expenses - Version 11.5 and later
Information in this document applies to any platform.
Credit Card Transactions Inactive Employees process
When running the Credit Card Transactions Inactive Employees Process the Supervisor is not notified that any outstanding transactions exist nor does the workflow appear to be granted the Securing Attribute ICX_HR_PERSON_ID in order to submit expense reports on an inactivated employee's behalf. Why is this occurring?
The issue can be reproduced at will with the following steps:
1. Terminate an employee that has unused credit card transactions present in OIE. Ensure that the Final Process Date is in the future.
2. Submit the Credit Card Transactions Inactive Employees Process
3. Review the workflow and see that the ICX_HR_PERSON_ID is being populated but then the value is deleted immediately because the workflow is not recognizing that any unused credit card transactions exist for the target employee. The follow command is used to run the wfstatus diagnostic script:
@wfstatus APCCARD <your item key value>
NOTE: select item_key from wf_notifications where NOTIFICATION_ID = <notification id shown on the notification sent to manager>;
22-JUL-14 11:34:46 Inform Manager of Inactive Employee CC Expenses/Check Manager Securing Attribute COMPLETE N
22-JUL-14 11:34:47 Inform Manager of Inactive Employee CC Expenses/Add Securing Attribute Preparer COMPLETE AP_PASS
24-JUL-14 11:39:51 Inform Manager of Inactive Employee CC Expenses/Wait COMPLETE #NULL
24-JUL-14 11:39:52 Inform Manager of Inactive Employee CC Expenses/Check CC Transactions exists COMPLETE N
24-JUL-14 11:39:52 Inform Manager of Inactive Employee CC Expenses/Clear Itemkey for CC Transactions COMPLETE Y
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms