A standard page (like Resource Details or Resource Crew) fails to load in the client and in Page Designer with `ORA-06502: PL/SQL: numeric or value error: NULL index table key value`, tracing into `DYNAMIC_REFERENCE_METADATA_API` and `MODEL_DESIGN_SYS`, after taking a delivery that worked fine in another environment on an older SU.

All FAQ questions / Developer Studio, deployment, and upgrades

Answer

This has been resolved in at least one case by creating a specific Resource Attribute record that the page's metadata generation apparently expects to exist — under Application Base Setup → Enterprise → Resource → Basic Data → Resource Attribute Manager, create a new attribute with Attribute Type "Resource", Attribute ID RESOURCE_ROLE, Data Type Text (length 100), and an LoV View referencing the resource-attribute-value view; after saving that record, the affected pages loaded normally. If you hit this exact error signature on these pages, check for that missing attribute record before assuming a broader metadata corruption issue.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Developer Studio, deployment, and upgrades questions