My Oracle Support Banner

Attachment Functionality Does Not Work For Maintenance Objects That Contains Space E.g. CUST CONTACT (Doc ID 2700472.1)

Last updated on AUGUST 13, 2020

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.6.0.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.6.0.1.0 version, ENV - Environment

Attachment Functionality does not work for Maintenance Objects that contains space e.g. CUST CONTACT
Duplicated the Attachment Zone C1-FA-ATTACH and implemented it to different Maintenance Object such as ACCOUNT, PERSON, PREMISE and CUST CONTACT.
The functionality works for Maintenance Objects ACCOUNT, PERSON and PREMISE however an error is being encountered for Maintenance Object CUST CONTACT.
Base objects related to Attachment is not able to handle base Maintenance Objects that has space like CUST CONTACT. It is being truncated.

ERROR
-----------------------
Error being raised is "Input request field Maintenance Object has an invalid value. Referenced FK F1-MO Maintenance Object CUST by table Maintenance Object does not exist.". Message Category/Number: 11001/1850.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Steps to Replicate:
1.Create a duplicate copy of the base Zone C1-FA-ATTACH. The duplicate version was updated for CUST CONTACT instead of FA. Please see attached bundle for the zone.
Note: The change is that all Maintenance Objects were updated from FA to CUST CONTACT. FA_ID was also updated to CC_ID.
2.The zone was attached to the base Customer Contact Portal Page (C1_CC_PRTL).
3.Load a Customer Contact and click on the Customer Contact Portal
4.Click Add on the Customer Contact Attachments. File Upload pop-up page is displayed.
5.Click a File and click Upload button
6.Upon click of Upload button, error is displayed
7.Notice that the Maintenance Object was truncated to CUST instead of CUST CONTACT.
8.AGAIN, THE STEPS ABOVE WORKED SUCESSFULLY WHEN WE DID IT FOR PERSON, PREMISE AND ACCOUNT MAINTENANCE OBJECT.

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.