Adding Contact Role - APP-AR-96282: ERROR: INVALID VALUE FOR RELATIONSHIP_CODE, SUBJECT_TYPE, OBJECT_T
(Doc ID 554795.1)
Last updated on MAY 05, 2021
Applies to:Oracle Advanced Collections - Version 12.0.2 and later
Information in this document applies to any platform.
You may have one of the following issues, or both:
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
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:
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