R11i: R12: OIE: Credit Card Transactions Inactive Employees Process Is Not Updating Supervisor To Allow For Submission Of Unused Transactions for Inactive Employee (Doc ID 1916486.1)

Last updated on JULY 05, 2023

Applies to:

Goal

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?


STEPS
-----------------------
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
...

Solution