My Oracle Support Banner

Error On Person Portal Screen Due To Non-existing Schema Constants (Doc ID 2143436.1)

Last updated on SEPTEMBER 26, 2022

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.4.0.3.0 to 2.5.0.1.0 [Release 2.4 to 2.5]
Information in this document applies to any platform.

Symptoms

**Examples provided in this article do not represent real life personal/confidential information**
**Disclaimer:** This KM article may include the following abbreviations:

BO - Business Object
CCB/CC&B - Oracle Utilities Customer Care and Billing
PD - Product Development
PFD - Product Fix Design

On : CC v.2.4.0.3, fresh install

When testing a new install of service pack 2.4.0.3.0 on the Person Portal page the following error occurs.
Is this error occurring because one is missing schema constants called "homePhone" and "businessPhone"?
This question is asked as in the CCB demo instance these schema constants are defined and the previous error is not reported.
Is the feature configurations for schema constants supposed to be supplied to customers as part of the base installation? Or do they need to add these themselves?

ERROR
-----------------------
"Schema field phone1 (schema/phone1) has an invalid default function is = %Constant(homePhone)"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Click the "Person Portal" tab
2. Observe error:
"Schema field phone1 (schema/phone1) has an invalid default function is = %Constant(homePhone)"

BUSINESS IMPACT
-----------------------
Customer is confused if this error is occurring because in the "Feature Configurations" the faulty instance does not have any Schema Constants defined.

Changes

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.