My Oracle Support Banner

Where To Find Contract Terms Text Stored In Tables For BIP Report (Doc ID 2403979.1)

Last updated on MAY 28, 2018

Applies to:

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

Goal

On : 11.13.18.02.0 version, Analytics

Where to find Contract Terms text stored in tables for BIP report.
I have been looking at the tables OKC_K_HEADERS_ALL_B, OKC_TEMPLATE_USAGES, OKC_TERMS_TEMPLATES_ALL & OKC_XPRT_RULE_HDRS_ALL. I can see a field called 'TERMS_CONTENT_IN_HTML'.

However when I look at the records related to a specific contract number. The 'TERMS_CONTENT_IN_HTML' field is blank but I can see in the Contracts front end screen for that specific contract number.

Can I get assistance in how the contracts terms is stored and in which tables and how each table is linked back to the contract headers table 'OKC_K_HEADERS_ALL_B'.


 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.