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 and later
Information in this document applies to any platform.


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)

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





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

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