My Oracle Support Banner

Save Company To Company IG Transaction Error "ORA-01400: cannot insert NULL into ("XTR"."XTR_POSITION_HISTORY"."BASE_REF_AMOUNT") (Doc ID 466814.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Treasury - Version 11.5.10.0 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
Entering an Intercompany transaction between two "companies", an error appears when trying to
navigate to the "Intecompany Party Details" tab.
The error:

"ORA-01400: cannot insert NULL into ("XTR"."XTR_POSITION_HISTORY"."BASE_REF_AMOUNT")
ORA-06512: at "APPS.XTR_COF_P", line 783

--------------------------------------------------------------
FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01400."


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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.