My Oracle Support Banner

PAXTRAPE Expenditure Inquiry Querying Fails With FRM-40212 Invalid Value For Field PROJECT_NUMBER (Doc ID 577274.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Grants Accounting - Version to [Release 11.5.10]
Oracle Project Costing - Version to 12.0.4 [Release 11.5.10 to 12.0]
Information in this document applies to any platform.


Expenditure Inquiry-->Actual->ALL) the Expenditure Inquiry  All gives the following error:
FRM-40212: Invalid value for field PROJECT_NUMBER

or  when trying to select either "ON
HOLD" or "CLOSED" status projects, no expenditure information is displayed.

The same projects show up as expected using either the Projects or
the Expenditure Inquiry > Project form.

Workarounds Used
The users with just the Expenditure Inquiry > All

FRM-40212: Invalid value for field PROJECT_NUMBER


The issue can be reproduced at will with the following steps:
Using the Project Costing Super User responsibility.
Navigate to Projects: query for <PROJECT1> or <PROJECT2>. Works correctly.
Navigate to Expenditure Inquiry > Project: query for project <PROJECT1> or <PROJECT2>. Works correctly.
Navigate to Expenditure Inquiry > All: query for project <PROJECT1 or <PROJECT2>. Receive Error
message FRM-40212: Invalid value for field PROJECT_NUMBER.
This happens with CLOSED  and PENDING CLOSE projects



<Patch 6272080> PERIODIC RELEASE FOR 11I.PJ_PF.M 26-OCT-2007
has been applied.


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.