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:

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

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