My Oracle Support Banner

R12:AP:Payment Request Manager Fails: ORA-20001: APP-SQLAP-10000: ORA-01400: cannot insert NULL into ("AP"."AP_AWT_TEMP_DISTRIBUTIONS_ALL"."GROSS_AMOUNT") occurred in AP_CALC_WITHHOLDING_PKG. (Doc ID 2700462.1)

Last updated on AUGUST 27, 2020

Applies to:

Oracle Payables - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.8 version

When attempted to submit the PPR then the Payment process request program errors out
APXPBASL: Payment Process Request Program
+---------------------------------------------------------------------------+



Starts
SQL error and free
 ORA-01400: cannot insert NULL into ("AP"."AP_AWT_TEMP_DISTRIBUTIONS_ALL"."GROSS_AMOUNT") occurred in
AP_CALC_WITHHOLDING_PKG.<-Insert_Temp_DistributionAP_CALC_WITHHOLDING_PKG.Get_Withholding_On_Ranges<-AP_CALC_WITHHOLDING_PKG.AP_Calculate_AWT_Amounts<-AP_



ERROR Msg : ORA-20001: APP-SQLAP-10000: ORA-01400: cannot insert NULL into ("AP"."AP_AWT_TEMP_DISTRIBUTIONS_ALL"."GROSS_AMOUNT") occurred in
AP_CALC_WITHHOLDING_PKG.<-Insert_Temp_DistributionAP_CALC_WITHHOLDING_PKG.Get_Withholding_On_Ranges<-AP_CALC_WITHHOLDING_PKG.AP_Calculate_AWT_Amounts<-AP_WITHHOLDING_PKG.AP_Do_Withholding
with parameters ( Invoice Id = xxxx, Supplier Id = xxxxx, Payment Num = 1, Group Id =xxxx, Tax Name = xxxxx, CodeCombinationId =xxxxx)


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.