My Oracle Support Banner

Fields Deprecated From Ext Table Api_acc_loan_ext - Remove From Seed Data And Api Table too (Doc ID 2878048.1)

Last updated on JUNE 22, 2022

Applies to:

Oracle Financial Services Lending and Leasing Cloud Service - Version 14.12.0.0.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------

Fields ACC_SALES_ORDER_NBR and ACC_AGREEMENT_NBR were added to api_acc_loan_ext (and corresponding external tables for LINE and LEASE) in 14.12.0.0.0. The same fields were added to the seed data (input_file_record_details) as well as API table (API_ACCOUNTS)

However, they were deprecated from external tables in 14.12.0.0.1 . In that case, these fields also need to be removed from the seed data and the API table. But it is not done.
This is leading to issue during migration in 14.12.0.0.1, where the APIDMP batch job is failing since batch job is looking for these 2 fields in the external table but is not able to find them.

Either these 2 fields should be removed from the seed data and external tables also, or they should be re-added to the external tables (api_acc_loan_ext and its line/lease counterparts)

EXPECTED BEHAVIOR
-----------------------
Fields ACC_SALES_ORDER_NBR and ACC_AGREEMENT_NBR should be removed from the seed data and external tables also, or they should be re-added to the external tables (api_acc_loan_ext and its line/lease counterparts) .


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

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot have successful run of the APIDMP batch job.

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
Cause
Solution


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