My Oracle Support Banner

Unable to Migrate Payment Terms using iSetup from Source to Target Instance. Error Message - "The total <RelativeAmount> of all the lines is not equal to the <BaseAmount> for the payment term" (Doc ID 2501308.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Receivables - Version 12.1.3 and later
Oracle iSetup - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

The Payment Term is not able to get migrated from Source Instance to Target Instance using iSetup process.
Below is the error message that is being encountered for the concurrent request - AZR12LOADER: iSetup R12 Loader

 AZR12LOADER: iSetup R12 Loader

+------------------------------------------+

Concurrent Request Parameters
******************************
SNAPSHOT_REQUEST_TYPE=E
JOB_NAME=PAYMENT_EXTRACT
RELOAD_REQUEST_ID=
SNAPSHOT_NAME=PAYMENT_EXTRACT
USER_NAME=
RELOAD_METHOD=
DBC_FILE_NAME=
IS_REMOTE=N
REQUEST_TYPE=L

Error Message encountered:
-------------------------------
Update Existing has been turned off. Existing records would be skipped.The total <RelativeAmount> of all the lines is not equal to the <BaseAmount> for the payment term.

Exception occurred while checking whether Import is INSERT or UPDATE for oracle.apps.ar.ispeed.paymentTerm.server.TermsTlVOImpl@162f77, {Language=US,
Name=xxxxxx, SourceLang=US, Description=}, Application: FND, Message
Name: FND_RECORD_DELETED_ERROR., this record will be skipped.

STEPS TO REPRODUCE:
---------------------------
Loaded only one Payment Term - xxxxxx using I-setup thru which the iSetup R12 Loader concurrent request gets submitted automatically.

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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


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