My Oracle Support Banner

Extract Revenue Basis Data from Oracle Fusion Applications Ends in Error 'Total Number of records extracted, having validation errors: 38' (Doc ID 2732331.1)

Last updated on NOVEMBER 27, 2020

Applies to:

Oracle Fusion Revenue Management Cloud Service - Version 11.13.20.07.0 and later
Information in this document applies to any platform.

Symptoms

The "Extract Revenue Basis Data from Oracle Fusion Applications" ends in error and doesn´t launch the subprocess for a new setup of integration between Fusion Receivables (AR) and Revenue Management (RMCS)

ERROR
-----------------------
Total Number of records extracted, having validation errors : 38



Activating the AFLog profile, the following message was captured in the log:

Exception raised in procedure POPULATE_CANONICAL_2

Exception raised in VRM_EXTRACT_PKG.run_source_canonical_proc:ORA-06550: line 224, column 2:
PL/SQL: ORA-00957: duplicate column name
ORA-06550: line 140, column 13:
PL/SQL: SQL Statement ignored

 

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.