Report Is Showing All Clauses Instead Of Selected Under Contract Expert (Doc ID 2771342.1)

Last updated on MAY 07, 2021

Applies to:

Goal

Report is showing all the clauses present in the terms template instead of clauses selected based on the contract expert questions answered.

The following logical query was used:

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
  0 s_0,
  "Enterprise Contracts - Contracts Real Time"."Clause Type"."Clauses Article Title" s_1,
  "Enterprise Contracts - Contracts Real Time"."Contract Header Details"."Contract Header Description" s_2,
  "Enterprise Contracts - Contracts Real Time"."Contract Header Details"."Contract Header Name" s_3,
  "Enterprise Contracts - Contracts Real Time"."Contract Header Details"."Contract Header Number" s_4,
  "Enterprise Contracts - Contracts Real Time"."Contract Party"."Contract Party Name" s_5,
  "Enterprise Contracts - Contracts Real Time"."Status"."Status Name" s_6,
  "Enterprise Contracts - Contracts Real Time"."Contract Header"."Contract Amount" s_7
FROM "Enterprise Contracts - Contracts Real Time"
WHERE
(("Status"."Status Code" = 'ACTIVE') AND ("Contract Party"."Contract Party Primary Flag" = VALUEOF(NQ_SESSION."FLAG_Y_LOOKUP_MEANING")))
ORDER BY 1, 2 ASC NULLS LAST, 7 ASC NULLS LAST, 5 ASC NULLS LAST, 4 ASC NULLS
LAST, 3 ASC NULLS LAST, 6 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY
 

Solution

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