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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.