My Oracle Support Banner

PAXTRAPR: Cannot Query Employees Expenditure Items by The Employee Number, Error: FRM-40212: Invalid value for field EMPLOYEE_NUMBER (Doc ID 3010374.1)

Last updated on MARCH 14, 2024

Applies to:

Oracle Project Foundation - Version 12.2.5 and later
Information in this document applies to any platform.


Unable to find employee related transactions in Expenditure Inquiry when querying by Employee Number.

This can be reproduce with the following steps:

  1. Log into a Projects responsibility
  2. Navigate to Expenditures > Expenditure Inquiry > All
  3. Click on the Resource tab
  4. Enter an Employee Number in the Employee Number field
  5. Receive Error FRM-40212: Invalid value for field EMPLOYEE_NUMBER.
  6. Also, running queries with other query information returns the related transactions with a blank Employee Number in the returned data.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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