Adding Contact Role - APP-AR-96282: ERROR: INVALID VALUE FOR RELATIONSHIP_CODE, SUBJECT_TYPE, OBJECT_T (Doc ID 554795.1)

Last updated on SEPTEMBER 22, 2016

Applies to:

Oracle Advanced Collections - Version 12.0.2 and later
Information in this document applies to any platform.

Symptoms

You may have one of the following issues, or both:

 

ISSUE #1

When setting a Collections or Dunning contact from the Collections Agent form the following note message is encountered in R12:

APP-AR-96282: Error: Invalid value for relationship_code, subject_type, object_type. Please enter forward_rel_code, subject_type, object_type value from hz_relationship_types

 Steps to Reproduce
Advanced Collections Responsibility
Collections > Query Customer > Select Contact Name > Actions Menu > select Collections or Dunning contact

ISSUE #2

When setting a value for the profile option -  IEX: Default Correspondence Relationship and the following error is shown:

APP-FND-01436: List of Values cannot find any values for you to choose
Cause: The List of Values execution failed to find any values
Cause: The SQL statement specified to fdlfch() failed to return any values.
Action: Check the message stack for any SQL statement failure messages. Check to make sure your SQL statement works in SQL*PLUS

Profiles couldn't determine the valid values for profile
IEX_DEF_CORRESP_REL_TYPE. This problem is usually due to an
error in the SQL Validation for that profile. Use the
Define Profiles form to fix the SQL Validation for the
IEX_DEF_CORRESP_REL_TYPE profile. This error may appear
immediately following an Oracle error, which gives more
information about what was wrong with the SQL Validation

Checking AR_LOOKUPS does not show the following rows for Advanced Collections:

 

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