Contract tables in oracle fusion

Contract tables in oracle fusion

In this post , We will be discuss about Contract tables in oracle fusion. Contract tables help to store the Contract related informations in oracle fusion. I will share some of the most important contract tables in oracle fusion. We can use these contract tables , to developed the custom BIP reports related to contracts in oracle fusion. Please find below the detail table list of Contract tables in oracle fusion.

10 Most Important Contract Tables in Oracle Fusion 

1.OKC_K_HEADERS_ALL_B

2.OKC_K_HEADERS_TL 

3.OKC_K_LINES_B

4.OKC_K_PARTY_ROLES_B

5.OKC_K_SALES_CREDITS

6.OKC_K_STATUS_HISTORY_B

7.OKC_PRICING_TERMS

8.OKC_CONTACTS

9.OKC_CONTRACT_TYPES_B

10.OKC_K_CHARGE_COMPONENTS

Detail Explanation of Contract tables in oracle fusion

OKC_K_HEADERS_ALL_B

Contract header is the top level component in a contract and is used to capture contract information like number, type, parties, business unit, start date, currency etc. In addition certain attributes captured at header level can be defaulted to contract lines.

OKC_K_HEADERS_TL

Translatable columns from OKC_K_HEADERS_B, as per MLS standards. See OKC_K_HEADERS_B for a description of the table.

OKC_K_LINES_B

A CONTRACT LINE is a supertype of CLIN (contract line item number), SUBCLIN and LINE DETAIL which group a set of deliverable ITEMS into a logical set usually defined by unitary price, delivery or some other classification. It also provides an association point for any specific RULES governing the performance of that particular delivery. LINES are hierarchical. A LINE may have children and may belong to one parent line. The topmost line (called the top line) has no LINE as its parent, but belongs to the CONTRACT HEADER. A RULE or PARTY association for a LINE flows down to all child lines until overridden. Each CONTRACT LINE must be of a specified LINE STYLE. This controls from where the LINE may source its data and what types of lines it may have as its children. Different SUBCLASSES of contracts may have different LINE STYLE hierarchies.

OKC_K_PARTY_ROLES_B

A contract is an agreement between at least two or more parties. Each party has a defined role within a contract. The primary roles for a party are Buyer and Seller (Vendor) but there can be other roles which may be defined like third party, buyer etc. Each party will have contacts which are captured as party contacts child entities.

OKC_K_SALES_CREDITS

Records sales credits for the sale of services in a contract. Functions in the same manner as sales credits in Order Management.

OKC_K_STATUS_HISTORY_B

This table stores Oracle Contracts history Information’s in Oracle Fusion

OKC_PRICING_TERMS

Base table for storing pricing terms for parent entities such as Sales Agreements, Promotions or Discount Lists.

OKC_CONTACTS

Contract contacts are child entities to Contract parties. Just like parties a contact has a defined role in a contract like Contract Manager, Buyer etc. The contact is the point of contact for the party in the context of the created contract.

OKC_CONTRACT_TYPES_B

This entity has the Contract Type Setup information.

OKC_K_CHARGE_COMPONENTS

Represents charge adjustments for a line charge

Contract tables in oracle fusion