My Oracle Support Banner

R12 RMCS: The VRMERBD : Extract Revenue Basis Data Program Errors With ORA-01400: cannot insert NULL into ("AR"."VRM_EXTRACT_LINES"."SATISFACTION_MEASUREMENT_DATE") (Doc ID 2381367.1)

Last updated on APRIL 04, 2019

Applies to:

Oracle Order Management - Version 12.0 and later
Oracle Receivables - Version 12.1 to 12.2.7 [Release 12.1 to 12.2]
Oracle Fusion Revenue Management - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

On EBS 12.1 and 12.2 version

The VRMERBD : Extract Revenue Basis Data program is erroring out.

When running the program "Extract Revenue Basis Data", it errors with the following


ERROR
-----------------------

Cause: FDPSTP failed due to ORA-01400: cannot insert NULL into ("AR"."VRM_EXTRACT_LINES"."SATISFACTION_MEASUREMENT_DATE")
ORA-06512: at "APPS.VRM_EXTRACT_PKG", line 1099
ORA-06512: at line 1



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
   run the program "Extract Revenue Basis Data"

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the program "Extract Revenue Basis Data".

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
References


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