My Oracle Support Banner

R12:AR:API Error: While Executing arp_maintain_ps.maintain_payment_schedules API ,Error occurs : ORA-01400: cannot insert NULL into ("AR"."AR_PAYMENT_SCHEDULES_ALL"."DUE_DATE") (Doc ID 3061288.1)

Last updated on FEBRUARY 17, 2025

Applies to:

Oracle Receivables - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

While trying to create the missing AR_PAYMENT_SCHEDULES_ALL record for the transaction the following error occurs .

ORA-01400: cannot insert NULL into ("AR"."AR_PAYMENT_SCHEDULES_ALL"."DUE_DATE")
ORA-06512: at "APPS.ARP_MAINTAIN_PS", line 3561
ORA-06512: at "APPS.ARP_MAINTAIN_PS2", line 1427
ORA-06512: at "APPS.ARP_MAINTAIN_PS2", line 1417
ORA-06512: at "APPS.ARP_MAINTAIN_PS2", line 1212
ORA-06512: at "APPS.ARP_MAINTAIN_PS2", line 1200
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "APPS.ARP_MAINTAIN_PS2", line 1164
ORA-06512: at "APPS.ARP_MAINTAIN_PS2", line 1393
ORA-06512: at "APPS.ARP_MAINTAIN_PS", line 3247
ORA-06512: at line 8
01400. 00000 - "cannot insert NULL into (%s)"
*Cause: An attempt was made to insert NULL into previously listed objects.
*Action: These objects cannot accept NULL values.

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


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