APP-FND-01242: Cannot Read Value from Field $PROFILES$.MFG_ORGANIZATION_ID
(Doc ID 183523.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle Cost Management - Version 11.5.5 to 11.5.5 [Release 11.5]Information in this document applies to any platform.
Symptoms
APP-FND-01242: Cannot read value from field $PROFILES$.MFG_ORGANIZATION_ID
The field $PROFILES$.MFG_ORGANIZATION_ID could not be located or read.
APP-FND-00730: The flexfield has an invalid value set.
The field $PROFILES$.MFG_ORGANIZATION_ID could not be located or read.
APP-FND-00730: The flexfield has an invalid value set.
APP-FND-00730: This flexfield has an invalid set. It may use a special value that uses an Edit event user exit, and the user exit has failed. If you are using a form on a graphical user interface (GUI) you may have an invalid value set of a different type, possibly a table-validated value set where the table or view does not exist or where there is an invalid WHERE clause. Contact your system administrator or support representative to check and correct the value sets this flexfield uses.
Further message is:-
APP-1242: Cannot read value from field $profiles$.mfg_organization_id
Cause: The field $profiles$.mfg_organization_id could not be located or read.
Action: This error is normally the result of an incorrectly-entered field name string in a trigger, or a field name string that does not uniquely specify a field in your form. Correct your trigger logic to precisely specify a valid field.
Cause: The field $profiles$.mfg_organization_id could not be located or read.
Action: This error is normally the result of an incorrectly-entered field name string in a trigger, or a field name string that does not uniquely specify a field in your form. Correct your trigger logic to precisely specify a valid field.
Looks like the Organization is not being prompted for when the report is being fired. This is the reason the profile option $profiles$.mfg_organization_id is not being populated. Had checked using sysadmin: Concurrent--> Program--> Define
Query up CSTRIVTI here.
Click on parameters button and then take a screen shot. The screen shot shows the parameter Organization_id having a Validation value set :- CST_SRS_NUMERIC_OPTION with default Type: PROFILE and Value : MFG _ORGANIZATION_ID.
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! |