My Oracle Support Banner

Mapping Header/Lines Columns In Lease Contract Open Interface Tables (Doc ID 2474166.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Lease and Finance Management - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, Lease Authoring

ACTUAL BEHAVIOR
----------------------
In Lease Management,  there are few issues related to Lease Contract Open Interface Tables

1. In the Headers and Lines interface tables below columns are not available to be populated by user
On OKL_HEADER_INTERFACE - ORIG_SYSTEM_ID1, ORIG_SYSTEM_SOURCE_CODE
On OKL_LINES_INTERFACE - ORIG_SYSTEM_ID1, ORIG_SYSTEM_REFERENCE1, ORIG_SYSTEM_SOURCE_CODE

2. The Taxes and Duties Rule Group "Reported By Vendor" and "Tax Schedule Applies" Rule are Mandatory.
We are facing QA Check failure for our migrated contracts since the legacy system does not have values for these two columns.
For Tax Schedule Applies the column mapping is "Tax Schedule Applies" (ST_TAX_SCHEDULE_APPLIES_FLAG), but there is no column mapping for "Reported By Vendor" in the OKL_HEADER_INTERFACE table.

EXPECTED BEHAVIOR
-------------------------
The Expected behavior is that column mappings should be available on OKL_HEADER_INTERFACE and OKL_LINES_INTERFACE

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

  1. Review OKL_HEADER_INTERFACE and OKL_LINES_INTERFACE columns for the above columns
  2. Several column mapping are not present on header interface and line interface table

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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