FRM-40212 INVALID VALUE FOR FIELD COUNTED_BY_CURRENT For Contingent Worker As Counter Via Cycle Count Entries Interface

(Doc ID 2410251.1)

Last updated on JUNE 19, 2018

Applies to:

Oracle Inventory Management - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

When a contingent worker is attempting to approve cycle counts using INVADCYC 120.17.12020000.10, the following error occurs.

ERROR
-----------------------
FRM-40212 Invalid value for field COUNTED_BY_CURRENT

Trace file shows this initial failure:

SELECT DISTINCT(P.FULL_NAME) FULL_NAME, P.FIRST_NAME FIRST_NAME,
 P.MIDDLE_NAMES MIDDLE_NAME, P.LAST_NAME LAST_NAME, P.PERSON_ID EMPLOYEE_ID,
 P.EMPLOYEE_NUMBER EMPLOYEE_NUM
FROM
PER_PEOPLE_F P, PER_ASSIGNMENTS_F A WHERE A.PERSON_ID = P.PERSON_ID AND
 A.PRIMARY_FLAG = 'Y' AND A.ASSIGNMENT_TYPE = 'E' AND TRUNC(SYSDATE) BETWEEN
 P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE AND TRUNC(SYSDATE) BETWEEN
 A.EFFECTIVE_START_DATE AND A.EFFECTIVE_END_DATE AND P.EMPLOYEE_NUMBER IS
 NOT NULL ORDER BY FULL_NAME

Changes

 

Cause

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