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 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Oracle Project Costing - Version 11.5.10.0 to 12.0.4 [Release 11.5.10 to 12.0]
Information in this document applies to any platform.
PAXTRAPE.fmb


Symptoms

Navigate
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

ERROR
FRM-40212: Invalid value for field PROJECT_NUMBER

 

STEPS
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

 

Changes

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

Cause

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
Symptoms
Changes
Cause
Solution
References

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