Cannot Query Cycle Counts Made By Now-Inactive Employees (Doc ID 1612878.1)

Last updated on SEPTEMBER 07, 2021

Applies to:

Symptoms

When attempting to view cycle count entries performed by employees who are now inactive, an error occurs. These were not contingent employees, but were once-active employees who are no longer with the company and are, as a result, inactive.

Based on the trace files provided, the following query fails to return a row when querying counts made by an inactive employee:

SELECT DISTINCT FULL_NAME FROM PER_WORKFORCE_CURRENT_X WHERE PERSON_ID = :b1 AND ROWNUM = 1
END OF STMT

Using former employee 134 as a sample:

SELECT EMPLOYEE_NUMBER, CURRENT_EMPLOYEE_FLAG, FULL_NAME FROM PER_WORKFORCE_CURRENT_X WHERE PERSON_ID =<PERSONID> returns zero rows
SELECT EMPLOYEE_NUMBER, CURRENT_EMPLOYEE_FLAG, FULL_NAME FROM PER_WORKFORCE_X WHERE PERSON_ID = <PERSONID> returns 1 row.

ERROR

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility = INV
2. Cycle Counting
3. Approve Counts
4. Cycle Count = MFG Count
5. Find
6. Query counts Pending Approval = Yes
7. Find
8. Count Sequence = 83074
9. Count Status unchecked
10. Find
11. Get error
12. Ok
13. Query Caused no records to be retrieved.

Cause

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