My Oracle Support Banner

Issues Defaulting Contract Header Context Segment From Contract Type (Doc ID 2945616.1)

Last updated on AUGUST 21, 2023

Applies to:

Oracle Fusion Enterprise Contracts Management Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Functional Setup Manager


Issues Defaulting Contract Header Context Segment from Contract Type.

Following instructions here as a guideline, but modifying for the business purpose.

By using the task 'Manage Contract Descriptive Flexfields' and using the Default Type set to SQL there is a need to create a mapping between some element on the Contract or Contract Type and these Contexts. The application, however, does not allow to use parameters in the SQL code area.


Assign context segments based on the Contract Type by providing the CHR_TYPE as a parameter


The issue can be reproduced at will with the following steps:

  1. Navigate to the task 'Manage Contract Descriptive Flexfields'.
  2. Select 'Contract Headers', edit.
  3. In the Context Segment section, for the Default Type LOV, select SQL.
  4. For the Default value write the SQL query with a where clause on the 'CHR_TYPE' field that uses a parameter.
  5. Notice that it is not possible to pass that parameter. 




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.