My Oracle Support Banner

Schedules And Items Failed On Prepayment Terms Missing Target Date (Doc ID 743876.1)

Last updated on NOVEMBER 19, 2019

Applies to:

Oracle Property Manager - Version 11.5.9 and later
Information in this document applies to any platform.
PNTLEASE
PNSCHITM


Symptoms

User created a payment term of type Prepayment (code 'PRE'). Not knowing of the requirement of indicating the Target Date on the payment term, they went ahead and saved the payment term and finalized the lease.

When the Schedules and Items ran for this lease, it errored out with an error inserting into the pn_payment_schedules_all with a blank scheduled date.  The error was due to the missing "target date" on the prepayment.

PNSCHITM module: Schedules and Items

ORACLE error 1400 in FDPSTP

Cause: FDPSTP failed due to ORA-01400: cannot insert NULL into ("PN".'PN_PAYMENT_SCHEDULES_ALL"."SCHEDULE_DATE")
ORA-06512: at "APPS.PN_SCHEDULES_ITEMS", line 6321

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
 Still Have Questions?
References

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