Contract Import in Oracle Lease and Finance Management(OLFM)

Oracle Lease and Finance Management(OLFM) allows you to import contracts through a standard set of Interface Tables. The import program imports data from interface tables into the Oracle Lease and Finance Management tables. After interface tables are populated, we need to submit a request to import and process contracts.

• Navigation to submit the Import Contract Concurrent Program 

         Processing->Interfaces->Import Contracts. 

• Parameters used for the Contract import batch:  Batch Number, Contract Number, Customer Number, Start Date From, Start Date To, Number of Parallel Instance. 

• Based on the parameter(s) entered, a set of contracts will be selected for import for the specific request from the interface tables. You populate the following interface tables before submitting the contract import concurrent program.

• Populate the following interface tables before submitting the contract import concurrent program.

Interface Table Name	Description
OKL_HEADER_INTERFACE	Contract header table
OKL_LINES_INTERFACE	Contract lines table
OKL_PAYMENTS_INTERFACE	Payments table
OKL_PARTY_ROLES_INTERFACE	Party Roles
OKL_TERMS_INTERFACE	Contract Terms & Conditions

• We can import Contracts in Batches by populating the batch number field in the interface header table. The contract import program follows these processes:

1. Validate required values:–The program validates the required values are loaded for each contract in the interface tables. The system marks the record status as "ELIGIBLE" if all required values are found populated. else, it changes status to "ERROR" and reports the error detail in a concurrent log/output file.
2. Load into Lease Management tables:– After the validation phase, each "ELIGIBLE" contract is populated in the corresponding destination data table. The record status in the Interface is set to either "INTERFACED" or "ERROR" depending on the result of loading. This process continues for all "ELIGIBLE" contracts. The system generates a detailed report as a concurrent manager log/output file.
3. Process:– After the load, the import program processes loaded contracts. As each activation step is completed, the contract status is updated.

         

Contract Status Description	Description
NEW	Interface contract data is loaded to create a new contract
PASSED	Contract has been validated by the QA checker
COMPLETE	Streams are generated and draft journal entries created
APPROVED	Contract is approved using the activation approval workflow
BOOKED	Contract is activated and all booking activities are completed

• Based on the parallel processing capability, users can specify number of parallel workers as a parameter for contract import program.