HZ_ORG_CUST_BO_PUB.GET_ORG_CUST_V2_BO Returns Error (Doc ID 1902719.1)

Last updated on JUNE 30, 2014

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, APIs

When attempting to run API script HZ_ORG_CUST_BO_PUB.GET_ORG_CUST_V2_BO returns error in ONE Environment,
but runs fine in another where Extra User Attributes are not enabled.
the following error occurs.

ERROR
-----------------------
ORA-06531: Reference to uninitialized collection
ORA-06512: at line 45
06531. 00000 - "Reference to uninitialized collection"
*Cause: An element or member function of a nested table or varray
was referenced (where an initialized collection is needed)
without the collection having been initialized.
*Action: Initialize the collection with an appropriate constructor
or whole-object assignment.

Debug shows:
------------------

hz_org_cust_bo_pub.get_org_cust_v2_bo(+)
validate_ssm_id(+)
get_org_cust_v2_bo(+)
get_organization_bo(+)
get_orig_sys_ref_objs(+)
get_orig_sys_ref_objs(-)
ERROR-ERROR IN EGO_USER_ATTRS_DATA_P
get_organizations_updated(-)
ERROR-ERROR IN EGO_USER_ATTRS_DATA_P
get_organization_bo (-)
ERROR-ERROR IN EGO_USER_ATTRS_DATA_P
get_org_cust_v2_bo (-)
ERROR-ERROR IN EGO_USER_ATTRS_DATA_P
hz_org_cust_bo_pub.get_org_cust_v2_bo (-)
--------DEBUG MESSAGE: 16673437 for 5
--------DEBUG MESSAGE: 16673437 for 6
--------DEBUG MESSAGE: 16673437 for 7
--------DEBUG MESSAGE: 16673437 for 8

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
AIA Integration

Run API Script HZ_ORG_CUST_BO_PUB.GET_ORG_CUST_V2_BO


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms