Browser version scriptSkip Headers

Oracle® Fusion Procurement, Supplier Contracts and Agreements Guide
11g Release 5 (11.1.5)
Part Number E22850-06
Go to Documentation Home
Home
Go to contents  page
Contents
Book<br />List
Book
List
Go to Feedback page
Contact
Us

Go to previous page
Previous
Go to previous page
Next
PDF

Contract Terms Library Setups: How They Work Together

Setting Up Business Units for the Contract Terms Library

Frequently Asked Questions for Setup Overview

Managing Clauses in the Contract Terms Library

Managing Clause Relationships

Frequently Asked Questions About Managing Clauses

Managing Clause and Section Numbering Schemes

Importing Clauses into the Contract Terms Library

Creating Folders to Organize Clauses

Indexing Clauses for Keyword Searches

Managing Contract Terms Templates

Setting Up Contract Expert

Frequently Asked Questions About Contract Expert Setup

Setting Up Variables

Frequently Asked Questions About Variables

Setting Up Adoption of Content Between Libraries

Frequently Asked Questions About Adoption

Setting Up Contract Preview and Printing

Setting Up Contract Terms Deliverables for Procurement

Setting Up Text Search for Supplier Contracts and Their Attachments

How the Contract Terms Library Supports Translation: Explained

Contract Terms Library Setups: How They Work Together

This topic provides a brief overview of setups for the Contract Terms Library.

The following figure outlines the main setups for the Contract Terms Library which are described in the sections of this topic. The setups on the left are accomplished using tasks from the Setup and Maintenance work area. To set up most of the Contract Terms Library features, including clauses and contract terms templates, you must navigate to the Terms Library work area. Dashed boxes highlight features that are available only in procurement contracts.

This figure outlines Contract Terms
Library setups.

Setups in Oracle Fusion Functional Setup Manager

Different Oracle Fusion Functional Setup Manager tasks enable or affect Contract Terms Library features. These setups include:

Contract Terms Library Work Area Setups

The Contract Terms Library is built using the tasks within the Terms Library work area:

Setting Up Business Units for the Contract Terms Library

Contract Terms Library Business Unit Setup: Explained

You can specify a wide variety of Contract Terms Library settings for either customer or supplier contracts within each business unit, by using either the Specify Customer Contract Management Business Function Properties or the Specify Supplier Contract Management Business Function Properties tasks. These tasks are available by navigating to the Setup and Maintenance work area and searching on the task name.

For the Contract Terms Library in each business unit, you can:

Enabling Clause Adoption

If you plan to use clause adoption in your implementation, then set up the following:

Setting Clause Numbering Options

You can set up automatic clause numbering for the clauses in the business unit by selecting Automatic in the Clause Numbering field and entering a Document Sequence Category you previously set up in the Clause Sequence Category field. If clause numbering is manual, contract terms library administrators must enter unique clause numbers each time they create a clause.

You can choose to display the clause number in front of the clause title in contracts by selecting the Display Clause Number in Clause Title option.

Enabling Contract Expert

You must select the Enable Contract Expert option to be able to use the Contract Expert feature in a business unit. This setting takes precedence over enabling Contract Expert for individual contract terms templates.

Specifying the Printed Clause and Deviations Report Layouts

For each business unit, you can specify the Oracle BI Publisher RTF file that serves as the layout for:

How the Selection of a Business Unit Affects Clauses and Other Objects in the Library

The choice of a business unit while creating many Contract Terms Library objects restricts where you can use these objects. Objects affected include clauses, contract terms templates, and Contact Expert rules. Objects created in a local business unit can only be used in that local business unit. Objects created in a global business unit can be adopted or copied over to other business units provided they are specified as global. This topic details the impacts of the business unit choice on the different library objects.

The following figure shows a hypothetical implementation with four business units: one global business unit and three local business units. You can designate one business unit as global during Business Unit setup. The other business units are local business units.

This image shows an implementation
with four business units.

How Business Units Affect Terms Library Objects

This table details how the selection of a business unit affects different objects in the Contract Terms Library.


Terms Library Object

Impact of Business Unit

Clauses

Different restrictions apply depending on business unit type:

  • Local Business Unit

    Use restricted to the local business unit where it is created.

  • Global Business Unit

    Clauses created in the global business unit, can be made available to other business units by selecting the Global check box.

    Local business units can either adopt the clause as is or localize it.

Contract terms templates

Different restrictions apply depending on business unit type:

  • Local Business Unit

    Use restricted to the local business unit where it is created.

  • Global Business Unit

    Contract terms templates created in the global business unit, can be made available to other business units by selecting the Global check box.

    Local business units can copy the templates to their business units.

Contract Expert rules

Use of rules is restricted to the business unit where you create them.

Contract Expert questions

Use of questions is restricted to the business unit where you create them.

Contract Expert constants

Use of constants is restricted to the business unit where you create them.

User variables

No effect.

User variables created in any business unit and are available across all business units.

Contract terms sections

No effect.

Contract terms sections can be created in any business unit and are available across all business units.

Clause numbering schemes

No effect.

Numbering schemes can be created in any business unit and are available across all business units.

Frequently Asked Questions for Setup Overview

How can I set up the content of the Contact Terms Library?

You must navigate to the Terms Library work area to set up the content of the Contract Terms Library.

What drafts display in the Terms Library Overview page?

The Drafts region of the Contract Terms Overview page displays drafts or revisions that you either created or last updated.

Managing Clauses in the Contract Terms Library

Contract Terms Library Clauses: Explained

You can create different types of clauses for different uses and use clause properties to specify if a clause is protected from edits by contract authors, if it is mandatory, and if it is related to or incompatible with other clauses. A clause you create in the Contract Terms Library is available for use within the business unit where you create it after it is approved.

The types of clauses you can create include:

Using different clause properties you can:

Creating Standard Clauses

Any clause you create in the library becomes a standard clause that can be used in the business unit where you create it after it is approved. Unless you specify that the clause is protected, contract authors can edit the clause in a specific contract. Any edits they make are highlighted in a clause deviations report when the contract is approved. Similarly, contract authors can delete the clause from a contract, unless you specify the clause is mandatory.

Including Clauses by Reference

For clauses, such as Federal Acquisition Regulation (FAR), you can print the clause reference in the contract instead of the clause text itself. During contract creation, you enter the reference on the Instructions tab of the clause edit page and select the Include by Reference option.

Creating Provision Clauses for Contracts with a Buy Intent

For contracts with a buy intent, you can create provision clauses, clauses that are included in contract negotiations but are removed after the contract is signed. Provision clauses are used primarily in Federal Government contracting.

Altering Clause Behavior with Clause Properties

Using different clause properties, you can alter the behavior of a clause, You can:

Clause Versioning: Explained

To make changes in an approved clause, you must create a new version. Versioning permits you to make changes to outdated clause text in contracts.

You create a new version of a clause by making a selection from the Actions menu in the clause search page. Keep in mind that:

Clause Versioning is Restricted by Status

You can create versions for clauses in the approved or expired statuses only. You do not create new versions to edit clauses that were rejected in the approvals process. These should be edited and resubmitted for approval.

A New Version Is Not Effective Until Approved

When you create a new version of an approved clause, your edits do not take effect until the new version is approved. In the meantime, contract authors can continue to use the last approved version if there is one.

Not All Attributes Are Versioned

Not all clause attributes are versioned, so editing them immediately affects all versions, even those currently in use in contracts. These attributes are:

Viewing Versions and Comparing Text

You can view and compare clause versions, but you cannot restore a previous version.

Changing the Title of a Clause After the Clause Is Approved: Example

While you cannot change the entry you make in the Clause Title field after a clause is approved, you can change the title that is printed in contracts in subsequent versions by making an entry in the Display Title field. The display title overrides the original title in contracts.

Scenario

Suppose you want to change the title of the clause Liability to Limited Liability, but the clause is already approved and in use.

In this case, you:

  1. Create a new clause version.

  2. Enter Limited Liability in the Display Title field.

  3. Submit the new version for approval.

Contract authors can start using the new version of the clause after it is approved.

Different Ways of Removing a Clause from Use: Points to Consider

You can remove a clause from use by deleting it, putting it on hold, or entering an end date. Each of these actions is available and appropriate in different circumstances.

Deleting a Clause

You can delete a clause only when it is in the Draft or Rejected status. If the clause already exists in an approved version, then that original version can continue to be used in contract terms templates, Contract Expert rules, and in contracts.

Putting a Clause On Hold

You can place an approved clause temporarily on hold by selecting the Apply Hold action and remove the hold by selecting Remove Hold.

You can still add a clause that is on hold can to contract terms templates and to Contract Expert rules, but you receive a warning when you try to activate them. Similarly, contract authors receive a warning when they validate a contract with a clause that was placed on hold and the hold is also recorded in the contract deviations report.

Entering an End Date

Enter a past date as the end date while editing a clause in the Contract Terms Library to remove an approved clause from use permanently. This sets the clause to the Expired status. You can search for and view the most recent expired version of a clause in the Contract Terms Library and copy it to create a new clause.

Setting Up Numbering for Clauses in the Contract Terms Library: Explained

For each business unit, you can specify either automatic or manual numbering for clauses stored in the Contract Terms Library.

You specify the clause numbering method individually for each business unit during business unit setup by selecting either the Specify Customer Contract Business Function Properties or the Specify Supplier Contract Business Function Properties tasks from the Setup and Maintenance work area. If you specify manual numbering, requiring users to enter a unique number manually each time they create a clause in the library, then no further setup is required. If you want the clauses to be numbered automatically, then you must create a document sequence category and a document sequence as described in related topics before setting up the numbering method in the business unit. Use the following values for your setup.

Values to Use for Document Sequence Categories

When creating document sequence categories for numbering clauses in the Contract Terms Library, use the following values:

Values to Use for Document Sequences

When creating document sequences, use the following values:

Including a Clause by Reference: Example

This example illustrates how to create a clause that is printed in contracts as a reference.

Scenario

Suppose you want to include a Federal Acquisition Regulations clause 52.202-1 by reference. In this case, you would fill in the following information.

Selecting the Include by Reference option prints the clause reference instead of the clause text.


Field

Entry

Number

52.202-1

Title

52.202-1

Display Title

Definitions

Description

Clauses About Definitions

Instructions

As prescribed in 2.201, insert the following clause:

Text

Definitions (July 2004) (a) When a solicitation provision or contract clause uses a word or term that is defined in the Federal Acquisition Regulation (FAR).

Reference

http://www.acqnet.gov/far/

Reference Description

This contract incorporates one or more clauses by reference, with the same force and effect as if they were given in full text. Upon request, the Contracting Officer will make their full text available. Also, the full text of a clause may be accessed electronically at this address: http://www.acqnet.gov/far/

Include by reference

Select this option.

Importing Clause Text from Microsoft Word: Points to Consider

To enter the text of a clause in the Contract Terms Library, you can use the built-in rich text editor or import the text from a file created with Microsoft Word 2007 or later.

Entering Clause Text Using the Built-In Rich Text Editor

Use the built-in rich text editor to enter and edit clause text whenever possible. Doing so supports all of the application features.

Importing Clause Text from Microsoft Word 2007 or Later Version

Import clause text from a document created in Word instead of entering the text directly into the application if you want to preserve complex formatting not supported by the application's editor or if using Word is more convenient.

Note the following:

Note

If you want to import large numbers of clause records rather than the text of individual clauses, use the Import Clauses from XML File concurrent program instead.

Managing Clause Relationships

Alternate and Incompatible Clause Relationships: How They Work

While creating or editing a clause you can specify its relationship to other clauses in the Contract Terms Library.

There are two clause relationships to choose from:

Both of the relationships you establish are bidirectional but not transitive as illustrated in the following figure:

This figure illustrates clause relationship
setup.

Other relationship properties include:

Setting Up the Alternate Relationship

Set up alternate clauses if you want to let contract authors decide when to substitute an alternate clause for a standard clause in a contract.

The following figure illustrates alternate clause setup:

  1. Create the standard clause and include it in a contract terms template.

  2. Create the alternate clause or clauses.

    Tip

    By using variables to represent differences between clauses, you can reduce the number of alternate clauses you must create.

  3. Specify the alternate relationships between the standard clause and the alternate clauses.

  4. During contract authoring, the contract terms template applies the standard clause in the contract terms, but the contract author can replace it with either one of the alternate clauses.

This figure illustrates the setup of
an alternate relationship between clauses in the Contract Terms Library.

During contract terms authoring, contract authors are alerted to the presence of alternate clauses by a special clause icon. If they choose to substitute one of the alternate clauses for a standard clause, the substitution is recorded as a clause deviation in the contract deviations report.

In addition, by selecting the Analyze Clause Usage action, you can determine which contracts are using alternate clauses.

Setting Up the Incompatible Relationship

When you specify a group of clauses to be incompatible, the presence of more than one incompatible clause in a contract results in a warning during contract terms validation.

The following figure uses an example to illustrate the setup of incompatible clauses.

  1. During setup, you specify Clause 2 and Clause 3 as incompatible to Clause 1 and associate Clause 1 to a contract terms template.

  2. The contract author or a Contract Expert rule applies the contract terms template (including Clause 1) to a contract.

  3. The contract author or a Contract Expert rule adds Clause 3 to the contract terms.

  4. The application displays a warning during validation.

This figure illustrates
the incompatible clause relationship.

Setting Up Alternate Clauses: Examples

This topic uses the example of jurisdiction clauses to illustrate two different ways of setting up alternate clauses.

Suppose for example, that the standard jurisdiction for your contracts is the State of Delaware but you want to permit contract authors to select the following jurisdictions:

There are two ways of setting up the alternate clauses:

Creating Separate Alternate Clauses

Use this method to create one clause for each jurisdiction. Here is the setup for this example:

  1. Create the standard jurisdiction clause for State of Delaware.

  2. Associate the standard clause with a Contract Terms Template that will be used to default it into contracts.

  3. Create the three alternate clauses:

    Because you want each alternate clause to have the same title, Jurisdiction, you must use both the Clause Title and the Display Title fields when you create each alternate. Your entry in the Clause Title must be unique, for example, Jurisdiction_1, Jurisdiction_2, and Jurisdiction_3. But you can enter Jurisdiction in the Display Title field to make the same title appear in the printed contract for all the clauses.

  4. Specify the alternate relationship between the different clauses:

During authoring, agents are alerted to the presence of the alternate clauses by an icon and can select any one of the alternate clauses to replace the standard clause.

Creating one Alternate Clause with Variables

If you want to minimize the number of alternate clauses you must create to just one, use this alternate setup:

  1. Create the standard jurisdiction clause for Delaware.

  2. Associate the standard clause with a Contract Terms Template that will be used to default it into contracts.

  3. Create one alternate clause with two variables: one for the county and one for the state:This agreement is governed by the substantive and procedural laws of [@State of Jurisdiction@] and you and the supplier agree to submit to the exclusive jurisdiction of, and venue in, the courts in [@County of Jurisdiction@] County, [@State of Jurisdiction@], in any dispute arising out of or relating to this agreement.

  4. Specify the alternate relationship between the standard clause and the alternate clause.

During authoring, agents are alerted to the presence of the alternate clause by an icon. Agents who select the alternate clause must run Contract Expert and enter the state and county variable values.

Frequently Asked Questions About Managing Clauses

What are the clause statuses and what do they mean?

Clause statuses in the Contract Terms Library reflect the state of the current version you are editing and restrict what actions you can take.

The following table describes the clause statuses and explains their implications


Status

Description

Effect

Draft

A clause is automatically set to the Draft status after you create a clause initially or when you create a new version.

  • Available for authoring and adoption?

    Not available.

  • Effect contract approval?

    No effect. Contracts do not include draft clauses.

  • Editing?

    No restriction.

  • Inclusion in contract terms templates and Contract Expert rules?

    You can include a draft clause version, but the templates or rules cannot be activated until the clause version is approved.

  • Deletion?

    Yes. You can delete versions in the Draft and Rejected statuses

Pending Approval

The status of a clause after it is submitted for approval.

  • Available for authoring and adoption?

    Not available.

  • Effect on contract approval?

    None. Contracts do not include clause versions in this status.

  • Editing?

    Limited to description and the end date.

  • Inclusion in contract terms templates and Contract Expert rules?

    You can include clauses with their latest versions pending approval, but the templates and rules cannot be activated until the clause version is approved.

  • Deletion?

    No.

Rejected

The approvers rejected the clause version. You can edit clauses in this status and resubmit them for approval.

  • Available of version for authoring and adoption?

    Not available.

  • Effect contract approval?

    Contracts do not include clause versions in this status.

  • Editing?

    Unrestricted.

  • Inclusion in contract terms templates and Contract Expert rules?

    You cannot add a clause with its latest version rejected.

  • Deletion?

    Yes.

Approved

The clause was approved.

  • Available for authoring and adoption?

    Yes.

  • Effect contract approval?

    None.

  • Editing?

    Edits restricted to end date and description.

  • Inclusion in contract terms templates and Contract Expert rules?

    Yes.

  • Deletion?

    No.

Expired

The clause is past its end-date.

The application automatically enters a clause end date in the old version when a new version is approved. You can also manually enter an end date in an approved clause.

  • Available for authoring and adoption?

    No.

  • Effect contract approval?

    Creates an error during contract approval validation. The clause must be removed before submitting the contract for approval.

  • Editing?

    No edits permitted.

  • Inclusion in contract terms templates and Contract Expert rules?

    You cannot add an expired clause.

    If the latest version of a clause becomes expired when it is already in a template or rule, then the application displays an error during template or rule activation.

  • Deletion?

    No.

On Hold

Another Contract Terms Library administrator placed a hold on the clause version.

  • Available for authoring and adoption?

    No.

  • Effect contract approval?

    Creates an error during contract approval. The clause must be removed before submitting the contract for approval.

  • Editing?

    No.

  • Inclusion in contract terms templates and Contract Expert rules?

    Cannot add clauses with the latest version on hold.

    Existing templates and rules use the previously approved version, if one exists.

  • Deletion?

    No deletion possible.

How can I find clauses that I drafted or that require my action?

You can view clauses that you drafted and clauses that require your action on the Terms Library Overview page.

How do I use the Clause Title and Display Title fields?

The title you enter in the Clause Title field must be unique for each clause within a business unit and cannot be changed after the clause is approved. You can use the Display Title field, which has no uniqueness requirement, to modify the title that appears in contracts or to specify the same title for multiple alternate clauses.

How can I create clauses with the same title?

You cannot have two clauses with the same title entered in the Clause Title field in the Contract Terms Library, but by entering the same title in the Display Title field for each clause, you can create multiple clauses with the same printed title. The Display Title overrides the Clause Title in printed contracts.

How can I search for a clause in the library by its text?

You can search for clause text using the Keyword field. This field also searches clause title, display title, and description.

How can I set up the clause title to include the clause number?

You can have the clause number automatically added to the front of the clause title as a prefix in printed contracts by selecting the Include Clause Number in Display option during business unit setup. You will want to do this only if the clause number is meaningful in some way, for example when it refers to a number of a government regulation. The clause number is a number of the clause in the Contract Terms Library and it is usually generated by the application automatically. It is not the number of the clause in the contract generated by the numbering scheme.

How does Contract Expert use the default section for inserting clauses into contracts?

If you are using a Contract Expert rule to insert clauses into a contract, then Contract Expert inserts the clause into the section that is specified in the Default Section field in the General Information region on the create and edit clause pages. If you do not specify a default section for the clause, then Contract Expert uses the default section specified in the Contract Expert region on the General tab in the create and edit contract terms template pages. If the section doesn't already exist in the contract where the clause is being inserted, Contract Expert adds the section along with the clause.

How does creating a new version of a Contract Expert rule affect contracts?

Activating a new version of a rule makes that new version effective whenever the contract author runs Contract Expert. Authors who validate or submit for approval contracts that used a previous version of the rule receive an error asking them to run Contract Expert again. Approved contracts are not effected.

What can I use clause analysis for?

Use clause analysis to find out how the Contract Terms Library clauses, contract terms templates, and Contract Expert rules are used in contracts:

Use clause analysis to:

What do I enter as the clause text if I plan to include the clause reference instead?

Even if you are printing the clause reference instead of the clause text in a contract, you must still enter text in the clause text field. The text you enter in this field is not printed in the contract, but it is used for searching clauses by text. For this reason, it is preferable if you enter the text of your referenced clause.

What information is copied over when I duplicate a clause?

Duplicating a clause copies all information about the clause except for its historical information (the templates where it is used and adoption history). You can edit all of the information about the new clause except for its business unit.

Note

To copy a clause to another business unit, you must recreate the clause in that business unit.

Why can't I find a clause when I search by clause text?

You may not be able to find a clause by searching for its text if the clause text has not been indexed. The application administrator must periodically index clause text by running two processes: Build Keyword Search Index for Contract Clauses and Optimize Keyword Search Index for Contract Clauses.

How can I find clauses that are adopted by other business units?

If you are in the global business unit, you can search clauses that have been localized or adopted by other business units using the Search Clauses page (you select the business unit and the adoption type). In a local business unit, you can use the analyze clause usage action instead.

What's the difference between the clause Instructions and the clause Description fields?

Use the clause Instructions field to enter instructions for contract authors on clause use.

Use the clause Description field to enter any information about a clause.

Both text fields are visible to contract authors during contract terms authoring and the text of both can be searched using the Keyword field. Neither field is printed in contracts.

What's a clause intent?

The clause intent specifies if the clause is going to be used for sales or procurement contracts. You can only create a clause for one intent.

What's the difference between saving a clause and submitting a clause?

Saving a clause saves it as a draft.

Submitting a clause triggers validation checks and submits the clause for approval. While a clause is in the approval process, you cannot make any edits. The clause must be either approved or rejected for you to edit it again.

What's the difference between setting up multiple alternate clauses and one with a variable?

There are two ways of setting up alternate clauses:

This table highlights the differences between the two setup methods:


Setup Method

Advantages

Disadvantages

Multiple Alternate Clauses

  • You can use clause analysis to track usage of the clause and its alternates

  • One-step selection: Contract authors select the clause from a list.

  • Language of the alternate clauses you create can vary.

  • Must create and maintain a large number of clauses.

  • Authors are restricted to the alternates you create.

  • Authors may have to search for the clause they want if there are many.

Single Alternate Clause with Variables

  • Permits you to create and maintain just one alternate clause.

  • Supports unlimited number of alternates.

  • Two-step selection: Authors select the alternate and then run Contract Expert to fill in the variable values.

  • Language of the alternate clause cannot change. The only difference is the information supplied by the variables.

Who can edit protected and mandatory clauses?

Only users with the Override Contract Terms and Conditions Controls privilege can edit mandatory and protected clauses. Contact your application administrator with questions about the privileges granted to you.

Why can't Iedit the clause information?

You cannot edit clause information if you lack the proper privileges or if the clause is not in the draft status. When the clause is pending approval, the approvers must approve or reject the clause before you can edit it. If the clause is rejected or approved, you must create a new version before editing.

Why can't I edit the clause text?

You cannot edit the clause text if it was imported from a Word document or if you do not have adequate privileges assigned to you. To edit imported clause text, download the clause text, use Word 2007 or later version to make your edits, and then import your changes. To edit protected or mandatory clauses, you must obtain the Override Contract Terms and Conditions Controls privilege from the application administrator.

Why can't I edit the clause title?

You cannot edit the clause title after you first save the clause. However, you can change the clause title in printed contracts by entering a new title in the Display Title field. The display title replaces the clause title in printed contracts.

Managing Clause and Section Numbering Schemes

Numbering Schemes: Explained

Use a numbering scheme to number sections and clauses in a contract terms template or in an individual contract. In addition to the preset numbering schemes that come with your application, you can create additional numbering schemes in the Terms Library work area.

Numbering Scheme Properties

Numbering schemes include the following properties:

Importing Clauses into the Contract Terms Library

Importing Clauses into the Contract Terms Library: Explained

You can import clauses, values sets, and manual user variables from external sources into the Contract Terms Library by using interface tables. You can either load your data directly into the interface tables using SQL*Loader, PL/SQL scripts, or JDBC or you can import the data from an XML file by running the processes described in this topic.

This topic describes:

What You Can Import

You can import:

Details about the fields and valid values for import are available in the import schema file OKCXMLIMPDFN.xsd which you can download from the following file location: fusionapps/crm/components/ contractManagement/okc/ termsLibrary/publicModel/ src/oracle/apps/contracts/ termsLibrary/publicModel/ libraryImport/model/ resource.

Note

Clause status determines when the clause becomes available for use in contract terms authoring:

Interface Tables

The same interface tables are used whether you are importing clauses using an XML file or loading data directly into the interface tables. The following are the database tables used for clause import:


Table

Description

OKC_ART_INTERFACE_ALL

The main interface table for loading clause data from external systems.

OKC_ART_RELS_INTERFACE

Table that stores information about clause relationships.

OKC_VARIABLES_INTERFACE

Table used to import variables used in clauses.

OKC_VALUESETS_INTERFACE

Table used to import value sets that are used by variables.

OKC_VS_VALUES_INTERFACE

Table that stores value set values.

OKC_ART_INT_ERRORS

Table that stores errors that are reported during import validation or import

OKC_ART_INT_BATPROCS_ALL

The internal system table that stores the batch run details. This includes the processing status as well as all the parameters that are used for each import.

Importing Clauses by Loading Them Into the Interface Tables

To import clauses by loading them directly into the interface tables:

  1. Format the data in a form that is suitable for loading into the interface tables. For example, if you are using SQL*Loader to load data into the interface tables, then you can use a comma separated data file (.csv) and a control file that describes the data format.

  2. Select the Manage Processes task link from the Terms Library work area.

  3. In the Managed Scheduled Processes page, click Schedule New Process and run the Import Clauses from Interface Tables process. It is recommended that you run the process first in the validation mode to review any errors. The following table describes the process parameters:


    Parameter

    Possible Values

    Mandatory

    Description

    Batch Name

    A name for identification purposes.

    Yes

    Provides a way for you to identify the records you are importing.

    Run in Validation Mode

    Yes or No

    No

    Set to Yes if you want to identify potential errors before you import.

    Commit Size

    1 to 300

     

    Indicates the maximum number of records that the process commits to the database at one time. For example, if you are importing 1,000 records and set the commit size to 100, then the process will commit records each time it processes 100 records without error. If an error occurs on the 150th record, then the process will not reprocess the first 100 the next time that you run the program. Consult your database administrator for the appropriate value.

  4. Use the Manage Process task available in the Terms Library work area to monitor the progress of your import and review the log for any error messages. Records with errors remain in the interface tables until you purged them or correct them.

  5. To improve performance, periodically purge the interface tables used in the import by running the Purge Contract Clause Import Tables process.

Importing Clauses From an XML File

To import clauses from a file:

  1. Prepare the XML file as specified in the schema file OKCXMLIMPDFN.xsd and the sample file OKCXMLIMPDFN.xml. You can download both files from the following location: fusionapps/crm/components/ contractManagement/okc/ termsLibrary/publicModel/ src/oracle/apps/contracts/ termsLibrary/publicModel/ libraryImport/model/ resource.

  2. Specify the location of the import file in the system profile Location of XML File for Importing Clauses. You can set this profile in the Oracle Fusion Setup Manager using the Manage Clause and Template Management Profiles task.

  3. Select the Import Clauses task link in the Terms Library work area and enter the following parameters for running the Import Clauses from XML File process:


    Parameter

    Description

    XML File Name

    The name of the file you are importing. The file must be uploaded to the location specified in the system profile Clause Import XML File Location.

    Default Business Unit

    The business unit where clauses are assigned when no specific business unit is included in a clause record you are importing. If the import file includes business units for all clause records, then you can leave this field blank.

    Create as Global Clause

    You can specify clauses imported into the global business unit as global clauses. This means they will be available for adoption by other business units.

    Default Clause Status

    The status you enter here is used to specify the status of clause records where no status is specified.

    Mode

    Use the Validate option to test the quality of your data. Use the Import option to import the clauses.

  4. Use the Manage Process task available in the Terms Library work area to monitor the progress of your import and review the log for any error messages. Records with errors remain in the interface tables until you purged them or correct them.

  5. To improve performance, periodically purge the interface tables used in the import by running the Purge Contract Clause Import Tables process.

Purging the Interface Tables

To optimize import performance, periodically run the Purge Contract Clause Import Tables process. This process purges records in all of the interface tables. The following table describes the parameters you can use to restrict the extend of the purge. If you do not enter any parameters, the process purges all records.


Parameter

Mandatory

Description

Start Date and End Date

No

Use the start and end dates to identify the date range for the interface records you want to purge.

Process Status

No

Enter a status if you want to purge interface records with that status. The possible values are Error, Success, and Warning.

Batch Name

No

You can restrict the purge to a specific batch by entering its name.

Creating Folders to Organize Clauses

Folders: Explained

You can use folders to organize clauses in the Contract Terms Library.

Folder Properties

Folders have the following properties

Indexing Clauses for Keyword Searches

Building and Maintaining the Text Index for Keyword Searches: Explained

In the Contract Terms Library, you can use the Keyword field to search the text of clauses and contract terms templates. You can automatically build and maintain the text index by running the processes listed in this topic.

Setting Up and Maintaining the Text Index

You can set up the processes listed in this table to automatically build and optimize the text index at desired intervals. How frequently depends on how often your clauses and contract terms templates are updated. New clause and template versions become available for searching after they are indexed.


Process

Description

Build Keyword Search Index for Contract Clauses

Builds the index for clauses. The process indexes the text in the following fields: Clause Text, Clause Title, Display Title, Description, and Instructions.

Optimize Keyword Search Index for Contract Clauses

Optimizes the clause search.

Build Keyword Search Index for Contract Terms Templates

Builds the index for clauses in contract terms templates. The process indexes the text in the following fields: Template Name, Description, and Instructions.

Optimize Keyword Search Index for Contract Terms Templates

Optimizes the clause search in contract terms templates.

To run the processes:

  1. Select the Manage Processes task link in the Terms Library work area.

  2. In the Managed Scheduled Processes page, click Schedule New Process.

Managing Contract Terms Templates

Contract Terms Templates: How They Work

You can create contract terms templates in the Contract Terms Library to insert appropriate terms and conditions into contracts during contract authoring. Contract authors can apply the templates manually or the application can apply the templates automatically using defaulting rules you set up.

Contract terms templates:

In addition, for a contract terms template you can:

This figure illustrates the different
aspects of contract terms templates.

Adding Sections

You can add sections that you have created in the library or create sections that are specific to the template itself.

Adding Clauses

You can add clauses in one of two ways:

For example, you may want to add a boilerplate jurisdiction clause directly into the template, but use a Contract Expert rule to insert the appropriate liability clause. This way a contract that calls for the shipment of hazardous materials will get a liability clause that's different from a contract that does not include any, for example.

The properties that you set up in the clause apply automatically. If you set up a clause as mandatory, contract authors will not be able to delete the clause after it is inserted by the template unless they have the special Override Contract Terms and Conditions Controls privilege. If you set up a clause with alternates, then authors can substitute any of the alternate clauses in the contract.

Note

You are not required to add any sections or clauses to a template directly. You can use Contract Expert rules exclusively, if appropriate.

Enabling Contract Expert on the Template

If you want to use Contract Expert in a contract where the template is applied, you must enable the template for Contract Expert by selecting the Enable option in the Contract Expert region in the Create Terms Template or Edit Terms Template pages.

When Contract Expert rules enabled for the template suggest additional clauses, these additional clauses are presented for review by contract authors before they are inserted in the default section specified in each clause. Depending on their level of privileges, some contract authors can choose which clauses to insert and which to omit. If you make Contract Expert suggestions mandatory for the template, then only users with the special Override Contract Terms and Conditions Controls privilege can reject the recommendations.

Adding Contract Terms Deliverables to Purchase Orders and Sourcing Contracts

For Oracle Fusion Purchasing purchase orders and Oracle Fusion Sourcing contracts, you can track compliance of tasks that the contract parties have agreed to execute as part of the agreement by adding contract terms deliverables.

You can use the deliverables to record the status of the tasks, keep everyone notified of past and future deadlines, and as a repository of the deliverable documents themselves. For example, vendors agreeing to supply a monthly report can log in to their sourcing portal and attach the report or ask for an extension. If they fail to respond by the specified deadline, the deliverable can trigger an automatic notification that the deliverable is overdue.

Assigning a Layout Template for Previewing the Contract Terms Template

You must assign a layout template with the contract terms template to make it possible for contract authors to get a preview of the template content, when they need to make a template selection, for example. The layout template, which you select on the General tab while editing the contract terms template, specifies what gets displayed in the preview, including the fields displayed, graphics such as a company logo, page numbering, headers and footers, and boilerplate text. This layout template is not used for printing the contract.

The layout template is an RTF file stored in the Enterprise Contracts folder in the Business Intelligence Presentation Catalog. A sample layout template is provided with your application. You can copy the sample template and edit it to create your own as described in a related topic.

Specifying a Numbering Scheme

You can associate a numbering scheme to the template that will automatically number sections and clauses in the contract. Several predefined numbering schemes are available with your application, and you can create additional numbering schemes of your own.

Defaulting the Template on Contracts

You can have a contract terms template apply automatically in all contracts based on:

If you enabled the feature Enable Contract Terms in Fusion Procurement for the option Procurement Contracts during implementation, then you can also apply templates to procurement documents based on document type.

The following document types become available:

While editing the contract terms template, you specify a template to be the default for a contract type or document type in the Document Types region. You can set up only one template as the default for each contract type or document type. You set up the Contract Expert template selection rules separately as described in a related topic. You can have multiple rules recommend the same template.

Here is how the defaults you enter in the Document Types region and the Contract Expert template selection rules interact to select and apply a template during contract authoring:

Activating and Revising Contract Terms Templates: Explained

For a contract terms template to be available for use by contract authors, it must pass an automatic validation check and be approved by the contract terms administrator. If you need to make changes after the template is approved and in use, you can create a new version by editing the approved template and submitting it for approval. After the revision is approved, it replaces the original automatically.

This topic discusses:

Validation Checks

The application performs the following validation checks for all contract terms templates. You must fix all errors before templates can be sent for approval. Fixing warnings is optional.


Validation Check

Type

Action

The template contains incompatible clauses.

Warning

Remove one of the incompatible clauses.

A clause you added to the template is in the draft status.

Error

While you can add draft clauses when creating a contract terms template, these clauses must be approved before the template can be sent for approval.

Note

If you create the draft clauses as part of the contract terms template, then these clauses are submitted for approval along with the template.

A clause in the template is in inactive, on hold, or rejected status.

Note

If a previous approved version of the clause is available, then this message does not appear. The template continues to use the previously approved version.

Error

You must obtain approval for the clause and resubmit the template for approval.

The template contains more than one alternate clause.

Error

You must remove one of the alternates.

If the template is a translation of another template, then the template it was translated from must be valid on the date you validate the translation.

Error

Obtain approval of the template you are translating before resubmitting.

Template contains no clauses.

Warning

Clauses are not required in a template.

For buy-intent templates that contain contract terms deliverables, the application performs the following additional checks:


Validation Check

Type

Action

The requester or the internal and escalation contacts in the deliverable are invalid.

Error

You must enter different requester or contacts. The internal contact and requester must be employees with e-mail addresses to receive notifications.

Supplier contact is invalid.

Error

The supplier must be entered as a contact with an e-mail address.

Deliverable dates are missing.

Error

Enter the missing dates.

Template Approval

After you submit a template for approval and it passes validation, the application sends a notification to the approvers specified in the Oracle BPEL Process Manager notification service process. If you have created clauses as part of the contract terms template, then the clauses are automatically submitted for approval and approved along with the template.

Template Statuses

Contract terms template statuses are set automatically during the template lifecycle.

This diagram shows the available statuses and the permitted transitions and actions in each:

This figure shows the available contract
terms template statuses and their relationships.

Creating New Contract Terms Template Versions

You can create a new version of a contract terms template by editing an active template. After the new version is approved, it automatically replaces the current version in the Contract Terms Library. The application does not save previous versions of templates.

If the template is a global template that was adopted by other business units, those business units must copy over the new version. The new template version appears in the Available for Adoption region of the Terms Library Overview page.

Frequently Asked Questions About Contact Terms Templates

How can I add a clause to a contract terms template?

You can add sections and clauses to a contract terms template on the Clauses tab while editing the template. Alternately, you can set up Contract Expert rules to suggest clauses based on the circumstances of each contract.

Use outline region on the left of the Clauses tab to add sections and clauses that will be present in all contracts created with the template. You must add at least one section using the Actions menu before you can add clauses. If you do not find the clause you need while adding clauses, you can create one from the Add Clauses window. You must refresh the preview of your template by clicking the Refresh icon on the right side of the tab to see your latest edits.

Create Contract Expert rules to add clauses that vary contract to contract. Contract Expert can add clauses based on variable values and answers to questions contract authors supply when they author the contract.

What's a default contract terms template?

A contract term template that is specified as the default template for a document type. A document type can be a buy or sell document that is considered a contract, such as a purchase order or a blanket sales agreement.

What's the difference between document types and contract types?

While both document types and contract types are contracts, document types encompass all purchasing and sales documents that are deemed contracts. Contract types include only enterprise contracts.

For sales, the list of document types is restricted to contract types, those contracts created within the Oracle Fusion Enterprise Contract Management (ECM) application itself. If you enabled the Enable Contract Terms in Fusion Procurement feature for the option Procurement Contracts during implementation, then the following procurement document types are available:

Contract type is an administrator-created classification for enterprise contracts which determines contract functionality, including the presence of lines and contract terms. You create contract types during contract setup by selecting the Create Contract Types task.

What validation checks get performed for contract terms templates?

The application performs the following validation checks for all contract terms templates. You must fix all errors before templates can be sent for approval. Fixing warnings is optional.


Validation Check

Type

Action

The template contains incompatible clauses.

Warning

Remove one of the incompatible clauses.

A clause you added to the template is in the draft status.

Error

While you can add draft clauses when creating a contract terms template, these clauses must be approved before the template can be sent for approval.

Note

If you create the draft clauses as part of the contract terms template, then these clauses are submitted for approval along with the template.

A clause in the template is in inactive, on hold, or rejected status.

Note

If a previous approved version of the clause is available, then this message does not appear. The template continues to use the previously approved version.

Error

You must obtain approval for the clause and resubmit the template for approval.

The template contains more than one alternate clause.

Error

You must remove one of the alternates.

If the template is a translation of another template, then the template it was translated from must be valid on the date you validate the translation.

Error

Obtain approval of the template you are translating before resubmitting.

If a new version of the clause is created while the current version is still in the approval process.

Warning

Optionally substitute the new version.

Template contains no clauses.

Warning

Clauses are not required in a template.

For buy-intent templates that contain contract terms deliverables, the application performs the following additional checks:


Validation Check

Type

Action

The requester or the internal and escalation contacts in the deliverable are invalid.

Error

You must enter different requester or contacts. The internal contact and requester must be employees with e-mail addresses to receive notifications.

Supplier contact is invalid.

Error

The supplier must be entered as a contact with an e-mail address.

Deliverable dates are missing.

Error

Enter the missing dates.

What's a global contract terms template?

A contract terms template that is created in a business unit designated during setup as the global business unit. A global template is automatically listed in the Term Library Overview page in the local business units and can be adopted by duplicating it.

What's a layout template?

RTF document that contains the contract layout for printing and preview.

The templates, which can include both formatting, graphics, text, and other layout elements, are stored in the Oracle BI Publisher library. You must specify layout templates when you create a contract type to enable contract printing and the preview of contract terms templates.

When do I create a clause as part of a contract terms template?

If you are creating a contract terms template and a clause you want to add does not exist in the Contract Terms Library, then you can quickly create the missing clause by clicking the Create Clause button. Creating a clause in this way automatically associates it to the terms template. While this abbreviated creation method does not permit the entry of some details, including clause instructions, references, and relationships to other clauses, you can always add any missing information later by editing the clause.

When do I need to make a contract terms template the default for a document type?

Specify a contract terms template as the default for a document type when you want that template to be automatically applied to a contract of that type.

You can also apply contract terms templates to contracts using Contract Expert rules. If a Contract Expert rule specifies a default contract terms template, the application ignores the document type default you specify here. However, should the Contract Expert rules you set up pick multiple templates, then the application uses the document type default you set here as a tiebreaker.

Why am I reviewing draft clauses when submitting a contract terms template for approval?

A contract terms template can be approved for authoring only when all of its clauses are approved as well. If any of the clause versions you added to the template are drafts, then the application lets you review a list of those drafts and submit them for approval along with the contract terms template. The draft clauses can include any draft clause versions as well as clauses drafted specifically as part of the contract terms template using the Create Clause button.

If any of the clauses are already available in an approved version, then you can choose to use the approved version in the template instead of submitting the drafts for approval. You can make the substitution on the review page by deselecting the draft.

Why are some clauses missing from a contract terms template I copied over for use in a local business unit?

You can copy a contract terms template from a global business unit for use in a local business unit. Before you do, you must ensure that any clauses you want copied along with the template are either adopted or localized. Any clauses in the copied template that are not adopted or localized in the local business unit are automatically removed.

Why can't I edit the contract terms template?

You cannot edit the contract template if you have insufficient privileges or the contract terms template is in a status that does not permit you to make modifications.

Why can't I add clauses to the contract terms template?

You must add at least one section to the contract terms template before you can add clauses and the template must be in a status that permits editing.

Why do I want to enable Contract Expert in a contract terms template?

You must enable Contract Expert in a contract terms template if you want to use Contract Expert rules with the template. Contract Expert rules can default the template to a new contract, recommend additional clauses, and flag any policy deviations in contracts that use the template.

Note

If you do not enable Contract Expert on a template, contract authors cannot run Contract Expert in contracts that use the template and no Contract Expert rules apply, not even those you specify as valid for all templates.

Setting Up Contract Expert

Contract Expert: How It Works

Use Contract Expert to enforce corporate policies and standards for all types of contracts, including enterprise contracts, purchase orders, and sourcing contracts.

Contract Expert makes it possible for you to set up business rules that can:

Contract Expert consists of two components.

The following figure illustrates the two components:

This figure illustrates the setup and
contract authoring components of Contract Expert.

Contract Expert Rule Setup

Depending on the type of rule that you are creating, you can base rule conditions on:

Contract Expert rules apply only to contract terms templates where Contract Expert is enabled. You can specify if you want a rule to apply to all or selected templates.

Contract Expert Rule Execution During Contract Authoring

Depending on their type, all active rules for the contract terms template used in a contract are evaluated automatically during contract terms authoring or when a contract author runs Contract Expert in the Contract Terms tab.

The following figure illustrates what happens when Contract Expert is run during contract authoring:

  1. If rule conditions require user input, Contract Expert prompts the contract author to enter variable values and answer questions. Answers to questions can trigger follow-up questions. In this figure, the answer to Question 1 triggered the follow-up Question 2.

  2. Contract Expert displays any recommended clauses for review by the author. Authors can choose which of the recommended clauses to insert into the contract provided that they have sufficient privileges.

  3. Contract Expert inserts the clauses in the contract terms section specified during clause setup in the Contract Terms Library. If no section is specified in the clause, the application uses the default section specified in the contract terms template. Contract Expert automatically inserts the default section if it does not already exist in the contract.

  4. On subsequent runs, Contract Expert first removes any clauses that it inserted into the contract in earlier runs, including clauses that have been moved or have been made nonstandard.

This figure illustrates the behavior
of Contract Expert during contract authoring.

Authors who do not make all the required entries or forget to run Contract Expert altogether receive warnings when they validate the contract terms or when they review the contract deviations report.

Contract Expert Rules: How They Work

You can set up Contract Expert rules to apply contract terms templates automatically to contracts, to suggest additional clauses for insertion during contract terms authoring, and to flag any contract deviations from company policy.

Each rule comprises conditions that must be met and the rule results. You can base rule conditions on:

Different Contract Expert rule types support different condition types, as illustrated in the following figure.

This figure illustrates the three types
of Contract Expert rules.

Key rule properties include:

Clause Selection Rules

Clause selection rules permit you to insert one or more clauses and sections into a contract.

The following table describes the rule properties.


Rule Property

Details

Rule outcomes

The rule can:

  • Recommend one or more clauses for insertion into the contract

    Contract authors can review the Contract Expert recommendations before the clauses get inserted into the contract. By setting the Expert Clauses Mandatory option when creating a contract terms template, you can specify if you want the clause insertion to be mandatory or if the authors can ignore the recommendations .

    If you make the insertion mandatory, then only contract authors with the Override Contract Terms and Conditions Controls privilege, a special privilege that allows deleting mandatory clauses from the contract, can reject the recommendations. Similarly, if the recommended clauses are standard clauses, then the authors must have the Author Additional Standard Contract Terms and Conditions privilege to reject the recommendations. This privilege allows the deletion of standard clauses from the contract.

    Contract Expert inserts each clause in the section specified as the default for the clause in the Contract Terms Library. If no default section is specified in the clause, then Contract Expert inserts the clause into the default section specified in the contract terms template. Contract Expert automatically inserts the default section if it does not already exist in the contract.

  • Ask follow-up questions

    You can ask follow-up questions by adding them in the Additional Questions region of the Results tab. Any additional question that you add must be part of another rule. Adding the follow-up question chains the rules together.

When the rule is evaluated

The rule is evaluated every time that a user runs Contract Expert.

Users receive an warning message during contract validation if they fail to run Contract Expert.

Conditions

Conditions can be based on:

  • clauses

  • questions

  • variables

    You can use both predefined system variables and user variables. Both types of user variables are supported: those that require entry by contract authors and those where the values are supplied by a Java procedure.

Where it applies

The rule applies only within the business unit and for the intent that you specify. You can have the rule apply to one of the following:

  • Specific contract terms templates

  • All contract terms templates for the business unit

Contract Terms Template Selection Rules

Contract terms template selection rules permit you to automatically apply a contract terms template to a contract.

The following table describes the rule properties.


Rule Property

Details

Rule outcomes

The application automatically applies a contract terms template to a contract. Or, if the author removed the contract terms using the Actions menu, the template displays the template name as the default when applying a new template.

When the rule is evaluated

The application evaluates the rule whenever the author navigates to the Contract Terms tab as long as no contract terms template is applied. If a contract terms template is applied to the contract, the template selection rules are not executed again, even if changes to the contract would result in a different rule outcome.

The rule is also evaluated to determine if the contract contains the recommended template whenever the contract author:

  • runs the clause deviations report

  • validates the contract terms or the contract

In both cases, the rule generates a warning if the author applied a different template from that recommended by the rule.

Conditions

Variables only

You can use predefined system variables and those user-defined variables where the values are supplied by a Java procedure.

Where it applies

The rule applies only within the business unit and for the intent specified in the rule.

Contract Expert does not apply a contract terms template if the contract terms template defaulting rules you set up recommend multiple terms templates for a single contract. Instead, Contract Expert applies the contract terms template specified as the default for the business document type during contract terms template setup. If no document type default is specified, then the application displays the Add Contract Terms button and permits authors to select a template of their own choice. The choices are restricted to the templates specified for the contract type.

This figure describes choosing a contract
terms template for application to a contract.

Policy Deviation Rules

Policy deviation rules flag deviations from company policies on the contract deviations report. This report is run by the contract author before submitting a contract for approval.

The following table lists the rule properties.


Rule Property

Details

Rule results

The rule displays a deviation in the contract deviations report.

The rule name becomes the deviation.

When the rule is evaluated

The rule is evaluated whenever the user:

  • Runs the contract deviations report

  • Validates the contract terms or the contract

Conditions

Conditions can based on:

  • Questions

  • Variables

    Both predefined system variables and those user-defined variables where the values are supplied by a Java procedure.

Where it applies

The rule applies only for the contract terms templates within the business unit and for the intent that you specify.

The following figure illustrates the policy deviation rule setup. You can build rule conditions out of both questions and variables. In the contract deviation report, your entry in the Rule Name field becomes the deviation name and your entry in the rule Description field becomes the deviation description.

This figure illustrates a Contract Expert
policy deviations rule.

Policy deviation rules list policy deviations in the contract deviations report, along with any clause deviations that are flagged automatically by the application. Contract authors can run the report before submitting the contract for approval and enter comments to explain the deviation to the approver. The report is rerun automatically when the author submits the contract for approval and a copy of the report is attached to the approval notification.

Activating and Validating Rules

After you set up a rule, you must activate it using the Activate Rule action. Rules do not require approval before activation, but the contract terms templates that they apply to do.

Note

In order to activate a rule, you must assign it to at least one contract terms template. The template does not have to be approved at the time that you make the assignment, but it does have to be approved before the rule can be used.

Activating a rule triggers an automatic validation process. You must correct all errors before the rule gets activated.

Contract Expert Rule Statuses and Available Actions: Explained

Statuses track the life-cycle of a Contract Expert rule from creation through activation and versioning and restrict available actions.

Contract Expert Statuses and Available Actions

This table describes available rule statuses and lists the permitted actions for each.


Status

Description

Available Actions

Draft

When you first create a rule, it remains in the Draft status until you activate it and it passes all the validation checks without error.

  • Activate

  • Edit

  • Delete

  • Duplicate

Active

The rule was activated and passed validation.

  • Edit

    You can edit an Active rule, to create a new version. This version remains in the Revision status until you activate it and it passes all the validation checks. Until it does, the old version remains active. Once the new version is in the Active status, it automatically replaces the old version.

  • Disable

  • Duplicate

Revision

The status of an active rule that was edited. The new version of the rule remains in this status until it passes validation and become active.

  • Activate

  • Edit

  • Delete

  • Duplicate

  • Disable

Disabled

The rule was disabled using the Disable action.

Duplicate

The following diagram illustrates the rule statuses and main actions.

This diagram details Contract Expert
rule statuses and the main actions they permit.

Contract Expert Question Setup: Explained

You can set up Contract Expert questions in the Contract Terms Library to solicit contract author input during contract authoring.

Contract Expert presents the questions to authors when they are part of a Contract Expert rule. The questions you create are restricted to one intent and their names must be unique within that intent. Questions can be reused across all business units.

Question Response Types

Question responses can be one of the following:

Note

Contract Expert does not permit you to provide default responses to user questions. However, the application sets numeric questions without a user response to 0.

Inserting Additional Clauses Based on Follow-up Questions : How It Works

You can ask follow-up questions and insert additional clauses into the contract terms based on the answers the contract author gives.

The following diagram illustrates how you can ask a follow-up question using the follow-up question to link two rules.

This diagram outlines how to ask follow-up
questions by chaining two Contract Expert rules.

Asking Follow-up Questions

To ask follow-up questions, you:

  1. Include the follow-up question as an additional question on the Results tab of a rule.

    In this example, contract authors get the follow-up question if they provide an answer that satisfies the condition with Question 1 (the only condition in Rule 1).

  2. Create a second rule with the follow-up question in a condition.

    In this example, the application inserts the additional clause if the contract author satisfies the condition based on the Follow-up Question (the only condition in Rule 2).

Contract Expert Constants: Examples

Contract Expert constants supply numerical values to numeric conditions in Contract Expert rules. The same constant can supply the value in multiple rules. Constants are specific to one intent, but can be used in all business units.

Scenario

For example, to default a payment terms clause when the contract amount is greater than $1 million, you create a Contract Expert rule with the condition: Contract Amount > 1,000,000.

Instead of entering the number directly into the condition, you create the constant Contract Amount Threshold and set its value to 1,000,000. The condition in your rule becomes: Contract Amount > Contract Amount Threshold.

You can use this same constant in multiple conditions. This way, if the threshold is later increased later to $2 million, you need only to update the constant instead of every rule that uses the condition.

Contract Expert Clause Selection Rules and Asking Follow-up Questions: Examples

Two examples illustrate how you can set up a Contract Expert clause selection rule to insert additional clauses and sections into a contract and how you can set up rules to ask follow-up questions.

Scenario

Suppose, that you want to add two additional insurance clauses under the section Additional Insurance when a shipment of hazardous materials is to be delivered within 30 days. You can handle this scenario by setting up one clause selection rule with two conditions:

Here is how you set up the rule:

  1. Ensure that both of the clauses that you want to add are created in the Contract Terms Library with the default section Additional Insurance. This guarantees that both appear in the contract under that section. If the section is not already in the contract, Contract Expert inserts it automatically.

    Note

    If you do not set up the clauses with a default section, Contract Expert inserts the clauses in the default section specified in the contract terms template.

  2. For condition 1, you must create a constant called Shipping and set its value to 30.

    This is because numerical values for conditions must be entered using constants rather than directly.

  3. Set up a question that requires a yes or no answer for the prompt "Is hazardous material involved?" for Condition 2.

  4. Create the clauses that you want to add to the contract in the Contract Terms Library.

    Note

    The clauses must be approved before the rule can be used.

  5. Create the Contract Expert rule with the two conditions.

    Selecting the Match All option means both conditions must be evaluated before the rule is true.

  6. Associate the rule with the contract terms templates where you want the rule to apply.

    You can assign the rule to individual templates or all templates with the same intent and within the same business unit.

  7. Activate the rule by clicking the Activate button while editing the rule.

The rule is evaluated for only those contracts that use templates that have been assigned to the rule. When both conditions in the rule are true, Contract Expert defaults the two insurance clauses.

This diagram illustrates the clause selection rule example.

This diagram illustrates the setup
of a clause selection rule to default two insurance clauses into a
contract.

Scenario

Now suppose you want to add an additional clause to the previous example if the hazardous material in the shipment is flammable. To do this, you create:

The following diagram illustrates the setup:

This diagram illustrates the setup
of an additional rule to insert an additional clause in the contract
based on the answer to a follow-up question.

Here are the steps in detail:

  1. Set up the follow-up question "Is the material flammable?" with yes and no answers.

  2. Create the additional insurance clause that you want to add to the contract in the Contract Terms Library.

  3. Create a new Contract Expert rule, Rule 2, with the follow-up question as the condition. The rule will be true if the author answers yes.

  4. Associate Rule 2 with the same contract terms templates where Rule 1 applies.

  5. Edit Rule 1 to add the newly created question in the Additional Questions region on the Results tab.

  6. Activate both rules using the Actions menu.

Contract authors see the question from Rule 2 in Contract Expert only if Rule 1 is true. Rule 2 inserts the additional clause in the contract if authors answer yes.

Frequently Asked Questions About Contract Expert Setup

What are Contract Expert questions?

Questions contract authors answer when running Contract Expert while authoring the contract. The answers can trigger Contract Expert to suggest additional clauses or ask follow-up questions, depending on how you set up the Contract Expert rules.

What does it mean to make clauses suggested by Contract Expert mandatory in a contract terms template?

When contract authors run Contract Expert on a contract, Contract Expert displays a list of any clauses that it recommends for insertion.

Contract authors can review the Contract Expert recommendations before the clauses get inserted into the contract. By setting the Expert Clauses Mandatory option when creating a contract terms template, you can specify if you want the clause insertion to be mandatory or if the authors can ignore the recommendations .

If you make the insertion mandatory, then only contract authors with the Override Contract Terms and Conditions Controls privilege, a special privilege that allows deleting mandatory clauses from the contract, can reject the recommendations. Similarly, if the recommended clauses are standard clauses, then the authors must have the Author Additional Standard Contract Terms and Conditions privilege to reject the recommendations. This privilege allows the deletion of standard clauses from the contract.

What happens if the clause to be inserted by the Contract Expert rule is versioned or removed from use?

If the current clause version is not approved or removed from use, Contract Expert automatically uses the previous approved version. If none exists, the contract author receives an error when validating the contract.

What happens to existing contracts if I disable a Contract Expert rule?

The change applies to all new contracts and to existing contracts whenever the contract authors run Contract Expert. Approved contracts are not affected. If you disable a clause selection rule, for instance, Contract Expert removes the suggested clause the next time Contract Expert is run. If you disable a contract terms template selection rule, the application does not make changes to the templates that are already applied to contracts, but does flag the change during contract validation and on the contract deviations report.

What validations get performed when I activate a Contract Expert rule?

The application automatically validates a Contract Expert rule when you attempt to activate it. You must correct any errors before the rule can become active.

The application performs the following checks:

What's a system variable?

A predefined variable that gets its value from an attribute of the contract.

For buy-intent contracts, system variables include payment terms, the purchase order number, and the purchase order amount. For sales-intent contracts, they include the customer name, the ship-to address, and the payment terms. System variables are supplied with your application and cannot be modified or deleted.

When does a Contract Expert rule become effective?

A Contract Expert rule becomes effective after you activate it and associate it to a contract terms template.

Why are some conditions unavailable for creating my Contract Expert rule?

Rule conditions are restricted by rule type. For example, rules for selecting default contract terms templates must be based on variables. However, clause selection rules can be based on variables, questions, or clauses.

Why can't I assign a Contract Expert rule to a contract terms template?

For you to assign a Contract Expert rule to a contract terms template, the template must be in a Draft or Approved status; it must be enabled for Contract Expert; and it must belong to the same intent as the rule.

Why doesn't a Contract Expert question display during authoring?

A question does not display during contract terms authoring if the rule is not activated or if the rule is not assigned to an active contract terms template. If you chain contract terms rules to ask follow-up questions, then the display also depends on the answer the contract author gives to the previous question.

Are Contract Expert rules affected by the relationships between clauses?

The alternate and incompatible relationships you specify for clauses do not affect the execution or setup of Contract Expert rules. However, the presence of more than one incompatible and alternate clause show up as warnings when the contract author validates the contract.

How are Contract Expert questions presented during contract authoring?

Contract authors see all of the activated Contract Expert questions that apply to a specific contract terms template on a single page when they run Contract Expert during authoring. Use the Reorder button on the View Question Sequence page to specify the order in which the questions are displayed. If you chained rules to ask additional follow-up questions, then each follow-up question appears underneath the previous question after the contract author answers it.

How can I find all the Contract Expert rules that use a question?

Use the Search Rule page to find all the Contract Expert rules that contain a particular question.

How can I find out which questions contract authors see when they run Contract Expert?

The Rules tab on the contract terms template edit page displays all of the possible questions contract authors may be required to answer when they run Contract Expert and in the order they are asked. A contract author may see only a subset of the questions, depending on what variable values they enter and how they answer the Contract Expert questions. You can view and change the order of questions from the Terms Template search page by selecting the Manage Question Sequence action.

How does creating a new version of a Contract Expert rule affect contracts?

Activating a new version of a rule makes that new version effective whenever the contract author runs Contract Expert. Authors who validate or submit for approval contracts that used a previous version of the rule receive an error asking them to run Contract Expert again. Approved contracts are not effected.

Setting Up Variables

Variables: Explained

You can use variables in the Contract Terms Library to represent information within individual clauses and for use within Contract Expert rule conditions.

Your application comes with predefined variables, called system variables. You can create additional variables, called user variables, with or without programming.

Predefined System Variables

Your application comes with predefined system variables that you cannot modify. These include:

To obtain a list of the predefined variables and the information that they represent, navigate to the Search Variables page and filter your search on the Variable type. Select the Document Association tab to view the application and document where the variable information originates. Alternately, you can search for variables by document type.

User Variables

There are two types of user variables that you can create:

Java Method user variables require you to create Java methods to capture attribute values. Sample code is provided in a related topic.

While Java Method user variables require programming knowledge, you can create manual user variables without programing. To do so, you:

  1. Create a value set using Oracle Fusion Application Setup Manager to validate the value entry for the variable.

    A value set can either specify the list of values that users must choose from or merely specify the variable format and length. Value sets are common application components described in the Oracle Fusion Applications Flexfields Guide.

  2. Navigate to the Create Variable page.

  3. Select the variable intent.

    Variables can be created for either buy (procurement) or sell contracts.

  4. Select the value set, and enter the name and the description that will help users identify the variable when they are inserting into a clause or entering its value in Contract Expert.

  5. If you are creating a variable for buy intent, then you can make the variable updatable by vendors in the Oracle Fusion Sourcing application by selecting the Updatable by External Parties option.

How User Variables Are Used

The user variables that you create can be:

When contract authors run Contract Expert during authoring, they are prompted to enter the variable value. The value is automatically substituted in the contract terms and any rules where the variable is used are evaluated.

Using Value Sets for User Variables and Contract Expert Rules: Explained

You can use value sets to determine what entries contract authors can make in user variables and in Contract Expert feature questions. You can use them either to specify the format an entry must take, or to create a list of values contract authors must choose from.

Value sets are a common application component which you can set up by navigating to the Setup and Maintenance work area and searching for the Manage Contract Terms Value Sets task. This topic highlights value sets nonprogrammers can set up for Oracle Fusion Enterprise Contracts.

This topic covers:

Using Value Sets for User Variables

You use value sets in the setup of user variables for one of the two following purposes:

Suppose, for example, that you need to create a user variable contract authors can use to enter the name of one of your warehouses into a clause during contract authoring. Without any knowledge of programming, you can:

Other value set features are also available for use by nonprogrammers. If you want to restrict the entry of the available warehouses by country, then you can make the above value set dependent on a second value set of countries, for instance.

Restrictions for Using Value Sets in Contract Expert Rules

If you are using the value set for a variable that will be used in Contract Expert rules or to specify the values used in responses to a question used in such a rule, then you only use a subset of the value set features as described in the following table.


Value Set Format Type

Value Set Validation Type

Supported?

Char

Independent

Yes

Valid operators are: Is, Is Not, In, and Not In

Char

Table

No

Char

Translatable Independent

Yes

Valid operators are: Is, Is Not, In, and Not In

Char

None

No

Char

Pair

No

Char

Special

No

Char

Dependent

No

Number

None

Yes

Numeric operators.

Standard Date / Standard Date Time

Not Applicable

No

Date / Date Time

Not Applicable

No

Creating Java Methods for User Variables: Examples

If you want to use attribute values captured in application documents and these attributes are not defined as existing system variables, then you can create user variables that obtain these values from Java methods you write based on the sample code in this topic.

This topic provides two sample methods with comments to help you write such Java methods. The sourcing of the Java variable value in these methods are different based on the database table and view object (VO).

If the Java user variable is an attribute of the Document Header VO (for example, Contract Header VO or PO Header VO) then use the first method. Use the second method if the Java user variable is an attribute on any child table of the document header VO.

Sample Java Method 1

This sample assumes that CurrencyCode is an attribute on the PO Header VO. This Contract Expert Java variable works even if the header information is not saved during document authoring. In this scenario, getCurrencyCode() is the method name associated with the user-defined Java variable in the variable definition page.

Note

Because Java is case sensitive, be careful when entering VO attribute names. Do not change the signature of any method or the parameter names.

  1. Using JDeveloper 11g, create an application and a project within that application.

  2. Within the project, create a Java file with the method for the Java user variable.

  3. Create a temporary folder and copy the ContractsTermsLibraryPublicModel JAR file from the fusionapps/jlib directory to this folder.

  4. Right click the project in jDeveloper and in the Project Properties:

    1. Select Libraries and Classpath.

    2. Add the ContractsTermsLibraryPublicModel JAR from the temporary folder.

  5. Create a JAR for the current project, by right-clicking on the project and selecting Project Properties and Deployment profile.

  6. Copy this new JAR to the following directory: mw_home_standalone/user_projects/domains/fusion_domain/servers/AdminServer/upload/ContractManagementApp/V2.0/app/ContractManagementApp/APP-INF/lib

  7. Bounce the server.

The following is a sample Java class to implement Java user variables. To customize, change the class name (MyPurchaseUDV). Do not change or remove any of the import statements.

/**
*/
MyPurchaseUDV.java
package oracle.apps.contracts.termsLibrary.publicModel.Attributes.model.java;
import java.math.BigDecimal;
import java.sql.*;
import java.util.Collection;
import java.util.HashMap;
import java.util.Iterator;
import oracle.apps.contracts.termsLibrary.publicModel.variables.model.java.ProgrammaticUDV;


/**
This class extends the abstract class ProgrammaticUDV. 
TO CUSTOMIZE: Change the Class name only (MyPurchaseUDV). 
*/

public class MyPurchaseUDV extends ProgrammaticUDV {


/**
CASE 1: For achieving CASE 1 use the methods registerAttributes() and getCurrencyCode().
*/


 /**
 The following method registers the Java variable present in the Header VO. The name of the variable should be the same as the name of the attribute in the Header VO. 
TO CUSTOMIZE: Change only the VO attribute name of the variable (in this case CurrencyCode) to match the attribute name in the Header VO. 
Do not change the method name or scope of the method. The only thing can be changed is the VO attribute name of the user variable. 
*/
       
protected void registerAttributes() {          
  registerAttribute("CurrencyCode");
 }
      
/**
 The following method obtains the value of java variable used in the Header VO. The attribute name of the java variable used in this method is CurrencyCode. This method returns the value of the CurrencyCode. The value of the variable which we are trying to get using this method (getCurrencyCode) should be registered in the previous method registerAttributes().  
TO CUSTOMIZE: Change the name of the method (getCurrencyCode()). Do not change the scope of the method.
The return type can be changed. To get the value of the variable we have to use the getAttributeValue() method only. 
 */
       
       public String getCurrencyCode() throws Exception {
            
        String  retVal = null;
        
        retVal = getAttributeValue("CurrencyCode");
       
          return retVal;
      }     


 

Sample Java Method 2

The following method is used to get the value of Java variable through SQL queries. In this scenario, we want to add clauses to the contract terms if the contract has any sales credit. Sales credit information is stored in a different table from the contract header. To work this scenario, the document must be saved before invoking Contract Expert. Java variable used is in this case is Sales Credit. Use method getSalesCredit() if the Java user variable is an attribute on any child table of the document header VO.

To customize, change the name of the method getSalesCredit() and the return type of the method. The other attribute values, such as document ID and document type, which might be needed while executing the query, can be obtained from the getter methods getDocumentId(), getDocumentType(), and getDocumentVersion().

The executeQuery method:

In the following example, an ID value of a Yes or No value set value is returned based on whether the contract has sales credits entries or not.

*/
      
      
public int getSalesCredit() throws SQLException, Exception {
        int  retVal = 0;  
        int value = 0;              
        String s1 = null;        
        BigDecimal id = getDocumentId();                
        s1 = executeQuery("SELECT to_char(count(*)) FROM OKC_K_SALES_CREDITS where dnz_chr_id = " + id);              
        value = Integer.parseInt(s1);    
        
         if(value > 0) {
           retVal = 271230; // Value Set id for "YES"
          } else {
            retVal = 271229; // Value Set id for "NO"
          }
      
           return retVal;      
        
      }
 }


/*****************************************************
   The following file content is provided here only for reference. 
   DO NOT INCLUDE THE FOLLOWING CODE IN ANY USER METHOD.
*****************************************************/
ProgrammaticUDV.java
package oracle.apps.contracts.termsLibrary.publicModel.variables.model.java;

import java.math.BigDecimal;

import java.sql.ResultSet;

import java.sql.SQLException;
import java.sql.Statement;

import java.util.ArrayList;
import java.util.HashMap;

import oracle.jbo.server.DBTransaction;

public abstract class ProgrammaticUDV {
   
    private HashMap attributesData;
    private DBTransaction dBTransaction;
    private Statement statement;
    protected BigDecimal documentId;
    protected String documentType;
    protected BigDecimal documentVersion;
    private ArrayList<String> attributeNamesUsed = new ArrayList<String>();
   
     public ProgrammaticUDV(){
           registerAttributes();
       }
     
    protected abstract void registerAttributes();
   
    protected void registerAttribute(String attributeName) {
        attributeNamesUsed.add(attributeName);
    }
   
    protected String getAttributeValue(String attributeName) throws Exception {
    if(attributesData.get(attributeName) == null){
        throw new Exception("Attribute name '" + attributeName + "' is either invalid or not registered.");
    }
     return (String)attributesData.get(attributeName);
    }   
   
    public HashMap getAttributesData() {
        return attributesData;
    }
   
    public void setAttributesData(HashMap variableData) {
        this.attributesData = variableData;
    }
   
    public ArrayList getAttributesUsed() {
        return attributeNamesUsed;
    }

    public void setDBTransaction(DBTransaction dBTransaction) {
        this.dBTransaction = dBTransaction;
    }
    
    protected String executeQuery(String query) throws SQLException {
        ResultSet rs = null;      
        String s =null;
        if (statement != null) {
            statement.close();
        }
        statement = dBTransaction.createStatement(0);
        rs = statement.executeQuery(query);      
        if(rs.next()){
          s = rs.getString(1);
        }
        statement.close();
        return s;
    }
    
    protected void closeQuery() throws SQLException {
     if (statement != null) {
         statement.close();
         statement = null;
      }
    }
    
    public void setDocumentId(BigDecimal documentId) {
        this.documentId = documentId;
    }

    public void setDocumentType(String documentType) {
        this.documentType = documentType;
    }

    public void setDocumentVersion(BigDecimal documentVersion) {
        this.documentVersion = documentVersion;
    }

    public BigDecimal getDocumentId() {
        return documentId;
    }

    public String getDocumentType() {
        return documentType;
    }

    public BigDecimal getDocumentVersion() {
        return documentVersion;
    }
}


 

Frequently Asked Questions About Variables

How can I obtain a list of system variables for use in Contract Expert rules?

Use the Search Variables page to create a list of system variables you can use in Contract Expert rules. You can use the Document Type field to narrow down your search by contract document type, such as a purchase order or Request for Quote.

How do I enable, disable, and delete variables?

When you create a variable, it is immediately available for use in clauses and Contract Expert rules. While there is no activation process or validation for a variable, variable setup is validated when you use variables in rules.

You can delete any variable as long as it is not being used in a clause or a Contract Expert rule. If it is in use, you can only disable it. Disabling a variable by selecting the Disabled option in the Edit Variable page prevents a variable from being used. The application displays an error for all clauses and rules that already use the variable.

Setting Up Adoption of Content Between Libraries

Adoption of Content from Global to Local Terms Libraries: How It Works

Much of the content in the Contract Terms Library is available only in the business unit where you create it. When you designate one of the business units as global during business unit setup, however, the content you create within that business unit can be copied over by other business units, a process known as adoption.

Different kinds of content in the global library can be adopted for use in a local library in different ways, as outlined in the following figure.

Note

Sections, folders, and numbering schemes do not need to be adopted or copied. They are automatically available across all business units.

This figure details how different Contract
Terms Library content can be adopted from a global business unit to
a local business unit.

Clause Localization and Adoption

Here is how you adopt and localize clauses:

  1. In the global business unit, you create a clause with the Global option selected.

  2. After the global clause is approved, it is automatically listed as available for adoption on the Terms Library Overview pages in the local business units.

  3. Contract Terms Library administrators in local business units select Adopt or Localize from the Actions menu to adopt the clauses.

  4. Both adopted and localized clauses now exist as independent clauses in the local library and must be approved before they can be used in contracts.

    Note

    During the local business unit setup, you can make clause approvals automatic.

  5. When a new version of one of the adopted or localized global clauses is approved in the global business unit, the terms library administrators in the local business units are notified automatically

    Note

    You specify the administrator to receive the notification during the local business unit setup.

  6. Administrators in the global business unit can create a clause analysis report that details the adoption and localization of the global clauses in the local business units.

Contract Terms Template Adoption

You adopt contract terms templates by copying them:

  1. In the global business unit, you create a contract terms template with the Global option selected.

  2. After the global template is approved, it is automatically available for copying in the local business units.

  3. Contract Terms Library administrators can search for the global templates available for adoption by selecting the Global option in the Search Templates page.

  4. Global templates are copied over by selecting the Duplicate action.

    Note

    Clauses in the copied templates must be first adopted or localized in the local business unit.

  5. The copied contract terms template must be approved in the local business unit before it can be used.

Frequently Asked Questions About Adoption

How can I find clauses that are available for adoption?

Clauses that are available for adoption are listed in the Clauses for Adoption region on the Terms Library Overview page. You can also search for them using the Search Clauses page by selecting the Available for Adoption from the Adoption Type drop-down list.

What happens if the global library publishes a new version of the clause I localized?

The new version of the clause appears as available for adoption in the Terms Library Overview page and in clause searches. The Contract Terms Library administrator receives an automatic notification.

What's the difference between an adopted clause and a localized clause?

Adopt a global clause to reuse it without change in a local business unit.

Localize a global clause to use it with edits in a local business unit.

All clauses you adopt and localize must be approved within your local business unit before they can be used for contract authoring. You can set up approvals to be automatic for adopted clauses, but not for localized clauses.

Setting Up Contract Preview and Printing

Contract Printing and Layout Templates: Explained

Previewing and printing clauses, reports, contracts, and contract terms uses a number of Oracle Business Intelligence (BI) Publisher layout templates which specify what information is displayed in the contract and supply the headers, footers, text style, and pagination. The layout templates are RTF files stored in the BI Presentation Catalog. Samples of all the required layout templates are included with the application. You can copy the sample layout templates described here, and edit the copies to add your own boilerplate text, font styles, and logos.

You can copy and edit layout templates used for:

The sample layout templates are available in different subfolders within the Enterprise Contracts folder in the catalog. You can navigate to the folders in the catalog either from the Reports and Analytics pane or by selecting the Reports and Analytics link in the Navigator. Contact your system administrator to grant you the appropriate BI duty roles if these are not available.

You can download the sample templates, copy them, and edit the copies. When you upload your edited copy to the same directory, it becomes immediately available for use within the application.

Restriction

The catalog includes additional layout templates which are used internally by the application. You can edit only the layout templates listed below.

Printing Enterprise Contracts

The application uses two layout templates for printing enterprise contracts, including partner agreements:

You specify which templates you want to use during contract type setup. This means that you can create different layout templates for each contract type. To set up contract types, select Manage Contract Types action from the Setup and Maintenance work area or Contract Types under the Setup task heading in the Contracts work area.

The following figure outlines how the application uses the layout templates when you print an enterprise contract:

  1. The application uses the contract layout template, specified in the Contract Layout field of the contract type, to create a PDF of the contract. If the contract does not include any contract terms, this is the only layout template used.

  2. If the contract includes structured terms, then the application uses the contract terms layout template specified in the Terms Layout Template field to create the contract terms PDF. To create the contract terms PDF, you must set the terms layout template in contract type.

  3. If the contract terms are attached as a file and the file retains the structured terms format, the application creates the contract terms PDF from the file. Contract terms attached as a file can retain the structured XML format if the file was downloaded from the application using the Download Contract action.

  4. The application merges the two generated PDFs into a single PDF.

  5. If the contract terms are attached in a file that is not structured, then the application prints only the contents of the file. It does not print the contract information in the application or use either layout template. If you need help in editing the layout templates, download the sample XML file provided in Enterprise Contracts > Contract Printing > ContractPrintDm.

This figure shows how enterprise contracts
are printed.

Printing of Contract Terms on Purchase Orders and Sourcing Documents

For printing purchasing documents with structured terms, Oracle Fusion Procurement uses two layout templates.

You select both of these templates while setting up business unit properties using the Configure Procurement Business Function task available by navigating to the Setup and Maintenance work area.

If the contract terms are attached rather than authored in the application and the attached file is not structured, then Procurement uses a third layout template which includes a brief sentence explaining that the contract terms are contained in a separate document.


File Name

Description

Location in BI Publisher Catalog Directory

ContractTermsNoMerge

This layout template includes the following text: The contract terms for this (doc type} are listed in a separate document which is either attached to the e-mail you received or sent separately. These contract terms should be read in conjunction with this {doc type}.

The document type name is substituted in the printed contract.

Enterprise Contracts/Contract Terms Printing/Attached Contract Preview

Important

If you edit the ContractTermsNoMerge layout template, then you must save it under the same name in the same directory.

The following figure outlines how the procurement application uses these layout templates for printing

  1. The application uses the document layout template specified in the Document Layout field in the PO or purchase agreement to create the PDF.

  2. If the contract includes structured terms, then the application uses the contact terms layout template to generate the contract terms PDF.

  3. If the contract terms are attached as a file and the file retains the structured terms format, then the application creates the contract terms PDF from the file. Contract terms attached as a file can retain the structured XML format if the file was downloaded from the application using the Download Contract action.

  4. If the contract terms are attached as a file that is not structured, then the application creates a small PDF of the message contained in the layout template ContractTermsNoMerge.

  5. The application merges the two PDFs into a single document PDF.

This figure shows how procurement documents
are printed.

Printing the Contract Deviations Report

The application uses the contract deviations layout template to generate a PDF report of deviations of a contract from company standards. This report can be automatically attached to the notification sent to the contract approvers during contract authoring. You can create different layout templates for each business unit. You specify which layout template you want to use in a specific business unit using either the Specify Customer Contract Business Function Properties or the Specify Supplier Contract Business Function Properties tasks. These tasks are available in the Setup and Maintenance work area.

Separate sample layout files are available for buy-intent and sell-intent contracts. Both are located in the same directory:


File Name

Description

Location in BI Publisher Catalog Directory

SupplierContractDeviations

Layout for printing the contract deviations for all buy-intent contracts.

Enterprise Contracts/Deviations Report/Deviations Report

CustomerContractDeviations

Layout for printing the contract deviations for all sell-intent contracts.

Enterprise Contracts/Deviations Report/Deviations Report

Previewing Contract Terms Templates

Contract Terms Library administrators as well as contract authors can preview the content of a template by selecting the preview icon. For example, a contract author may want to preview a template to verify they are selecting the correct one. The preview lists all the clauses and sections the template contains and any boilerplate included in the layout template. It does not list any additional clauses inserted by Contract Expert rules.

You can create different layout templates for each contract terms template. You specify the layout template to be used for the preview on the General tab while editing the contract terms template. The sample layout template is:


File Name

Description

Location in BI Publisher Catalog Directory

ContractTermsTemplate

This layout template specifies the layout of the contract terms template preview.

Enterprise Contracts/Contract Terms Printing/Contract Terms Download and Preview

Previewing and Importing Clauses

The application uses the clause layout template for:

You can specify which template you want to use in a specific business unit using either the Specify Customer Contract Business Function Properties or the Specify Supplier Contract Business Function Properties tasks. These tasks are available in the Setup and Maintenance work area.

The sample layout template provided is:


File Name

Description

Location in BI Publisher Catalog Directory

ContractTermsLibraryClause

Specifies the layout of clause text in the Contract Terms Library.

Enterprise Contracts/Contract Terms Printing/Clause Export and Preview

Can you still print the contract if there are no layout templates specified for a contract type?

No, you cannot print or create a PDF of a contract if no contract layout template is specified in the contract type that was used to create the contract. If you do not specify the terms layout template, then you cannot preview the contract terms as a PDF.

Setting Up Contract Terms Deliverables for Procurement

Contract Terms Deliverables: Explained

Contract terms deliverables establish and track both contractual and noncontractual commitments that must be fulfilled as part of negotiations and contractual agreements between businesses and their partners. These deliverables can be used only in procurement contracts and in negotiations. They cannot be used in enterprise contracts.

This topic provides an overview of:

Using Contract Terms Deliverables

You can use contract terms deliverables:

Creating and Managing Contract Terms Deliverables

You create and manage the deliverables in two separate interfaces. You create the deliverables while the contract is in negotiations. You manage the deliverables while the contract is active and in the process of being executed. Here is how it works:

  1. You create the deliverable as part of a contract terms template or in an individual contract entering the responsible party, the deliverable deadlines, and what notifications you need.

  2. If deliverables are present in a contract terms template you apply to a contract, then the deliverables get copied to the contract automatically. The type of deliverables that are applied automatically can vary based on the document type.

  3. The application creates deliverable instances with the calculated deadlines based on your setups at the time the contract becomes active. For instance, if you created a deliverable that calls for the supplier to submit a report every week after the contract is signed, then the application creates a separate instance of the deliverable for each week based on the date the contract was signed.

  4. You and the suppliers use the Manage Deliverables page to access and update each deliverable instance. In the above example, each week the supplier updates the deliverable instance that is due that week and attaches any collateral. Both internal employees and suppliers logging into their supplier portals use the same interface to communicate the deliverable progress and to attach required documents.

  5. Based on your setups, the parties are automatically notified when the deliverable is due or overdue, or when one of the parties changes its status (dashed lines).

  6. The contractual deliverables you set up are listed in the printed contract terms when you add the deliverable variable to a clause.

This diagram illustrates the two different
interfaces you use to create and manage contract terms deliverables.

One-Time and Repeating Deliverables

You can create both one-time and repeating deliverables.

A one-time deliverable tracks the performance and deadlines for an individual required action that must be performed by one of the parties in the contract.

A repeating deliverable tracks a deliverable that must be performed periodically, for instance a progress report that must be submitted every week after the agreement is signed.

The following diagram uses an example to illustrate the two variable types:

After the contract is signed, the application automatically creates the instances of the two deliverables which can be viewed and updated both by the internal party and the supplier using the Manage Contract Terms Deliverables task. The due dates for each deliverable in this example are based on the date the contract was signed.

Note

Note that the name of each deliverable instance for a repeating deliverable is the same. The only difference is the due date.

The supplier attaches the report file to the appropriate instance of the deliverable and changes its status to complete to indicate that it has been fulfilled.

This diagram illustrates the example
of one-time and repeating deliverables.

Where You Can Create and Use Contract Terms Deliverables

You can create contract terms deliverables both in buy-intent contract terms templates and in individual Oracle Fusion Purchasing and Oracle Fusion Sourcing contracts.

For purchasing, you can create and use deliverables on documents which include:

For sourcing, the documents include:

Contract Terms Deliverable Types

Deliverable types restrict where a deliverable is available and where it can be printed. There are three deliverable types:


Fulfillment Type

Where Available

Description

Where It Prints

Contractual Deliverables

Purchasing and sourcing

Deliverables that must be fulfilled as part of the contract.

Prints in all documents:

  • As part of the Contract Terms Template preview

  • Procurement contracts

  • Sourcing documents

Negotiation Deliverables

Sourcing only

Deliverables that are a part of a negotiation document but are not part of the final contract.

Prints as part of:

  • As part of the Contract Terms Template preview

  • Sourcing documents

Internal Purchasing Deliverables

Purchasing only

Purchasing deliverables that are used to track internal schedules and commitments.

Not printed as part of the contract terms.

Note

If you create a deliverable as part of a contract terms template and that deliverable is of a type that is not compatible with the contract where the template is applied, then the deliverable does not get created in that contract. For instance, a negotiation deliverable in a template is dropped when that template is applied to a purchase order but added when that same template is used for an RFQ.

Fixed and Relative Due Dates

You can specify a deliverable to be due on a fixed date, such as the first of the month, or relative to a contract event, such as one week after the contract is signed.

The available events include:

The available contract events differ depending on where you create the deliverable and the deliverable type. For instance, for contractual deliverables you create in a contract terms templates, you can base the due dates on: Contract Canceled, Contract Closed, Contract Signed, Contract Start Date, and Contract End Date. Negotiation deliverables can be based on: Negotiation Closed, Negotiation Opened, and Response Received.

Deliverables Notifications

You can notify interested parties using Oracle BPEL Process Manager via e-mail, voice message, instant messaging (IM), or short message service (SMS).

You can send automatic notifications:

Who receives the notification depends on a combination of the notification type and the party who is responsible for the deliverable as listed in the following table. The requester is an internal party. The external contact is a supplier contact.


Notification Type

Responsible Party

Recipients

Prior to due date

Internal

Internal Contact

Prior to due date

External

External Contact

Overdue

Internal

Requester, Internal Contact

Overdue

External

Requester, Internal Contact, External Contact

Status Change

Internal

Requester, Internal Contact

Status Change

External

Requester, Internal Contact, External Contact

Escalation

Internal and External

Requester, Internal Contact, Escalation Contact

Frequently Asked Questions About Contract Terms Deliverables

What does it mean to change the printing sequence for contract terms deliverables?

Contract terms deliverables can be listed by title in a clause in your terms and conditions. You can change the sequence in which the titles appear on this list by modifying the print sequence.

What's the difference between contract terms deliverables and contract deliverables?

Contract terms deliverables establish and track both contractual and noncontractual commitments that must be fulfilled as part of negotiations and contractual agreements between businesses and their partners. These deliverables can be used only in procurement contracts and in negotiations. They cannot be used in enterprise contracts.

Contract deliverables are contract fulfillment lines that track contractual and noncontractual commitments, but in procurement enterprise contracts. In addition, you can use contract fulfillment to initiate and monitor purchasing activity in integrated procurement applications. For example, you can use a contract fulfillment to create a purchase order in Oracle Fusion Purchasing for items in a contract line and then monitor the purchasing activity on that purchase order as it is being executed.

Setting Up Text Search for Supplier Contracts and Their Attachments

Setting Up Contract Text Search: Highlights

If you have implemented the Oracle Enterprise Crawl and Search Framework, you can enable text searches of contracts and their attachments from within the contracts application by running the following indexing schedules:


Indexing Schedule Name

Description

Enterprise Contracts

Indexes and enables text search on contracts created in Oracle Fusion Enterprise Contracts.

Purchasing Contracts

Indexes and enables text search in the POs and agreements within Oracle Fusion Purchasing.

Sourcing Contracts

Indexes and enables text search in the RFIs and other negotiation documents in Oracle Fusion Sourcing.

Contract Documents

Indexes and enables text search in documents attached to Oracle Fusion Enterprise Contracts.

Purchasing Contract Documents

Indexes and enables text search in documents attached to Oracle Fusion Purchasing POs and agreements.

Sourcing Contract Documents

Indexes and enables text search in the documents attached to Oracle Fusion Sourcing RFIs and other negotiation documents.

Running Indexing Schedules

The management of indexing schedules is fully described in the Managing Search with Oracle Enterprise Crawl and Search Framework chapter in the Oracle Fusion Applications Administrator's Guide.

How the Contract Terms Library Supports Translation: Explained

You can set up your contract terms library to handle the translation of clauses, templates, and other content in multiple languages.

This topic discusses the features included in Oracle Fusion Enterprise Contracts that support translation, making it possible for you to

These two features are only a small part of a translation solution, however. The rest of the setup is very much open-ended. For instance, when you have different business units that operate in different languages, you can use the adoption and localization feature of contracts to keep separate libraries in different languages. Alternately if you are using only one business unit, you can create separate numbering or naming schemes to keep the content in multiple languages separate.

Indicating a Localized Clause is a Translation of Another

If you have set up the multiple business unit structure that supports clause adoption and localization, you can use the localization feature to translate clauses. The global clause you create in the global business unit becomes the clause you are translating from. To translate the global clause, you localize it using the localize action and enter the translation on the Localize Clause page. The Localize Clause page displays both the original and translated text. You can indicate the localized clause is a translation-only clause by selecting a check box. This check box is for informational purposes only and can be used to generate reports.

Note

Unlike contract terms templates, clauses have no language field that tracks the language of the clause.

Tracking Contract Terms Template Translations

For each contract terms template you can specify the template language and the template it was translated from, if it is a translation.

The Translations tab in the contract terms template edit page shows all of the templates related by translation. For instance, if you translate an English template into French, Japanese, and Chinese, then each of the templates lists the translations as shown in the following diagram.

All of the templates listed display the source template in the Translated From column. For the source template, this column is blank.

In this example, you can tell the English template is the source template for the French, Chinese, and Japanese translations because there is no entry in the Translated From column.

This diagram shows the translation
relationships between four contract terms templates, three of which
are translations of the English template.

To manage the translated templates, you can search for all of the templates in a particular language and for all templates translated from a specific template.