My Oracle Support Banner

Schedules and Items (PNSCHITM) Program Fails with "EXCEPTION IN calc_intrst_amt :User-Defined Exception Proration rule/Annual interest rate/interest duration days/ interest method is null" (Doc ID 2786005.1)

Last updated on AUGUST 11, 2021

Applies to:

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

Symptoms

When attempting to amend a lease to early terminate it, the following error occurs in the Schedules and Items run:

ERROR in the schedules and Items concurrent request log file
---------------------------------------------------------------------------
ORACLE error 6510 in FDPSTP

Cause: FDPSTP failed due to ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PN_SCHEDULES_ITEMS", line 9285
ORA-06512: at line 1

......

EXCEPTION IN calc_intrst_amt :User-Defined Exception
Proration rule/Annual interest rate/interest duration days/ interest method is null
Params: Proration rule/Annual interest rate/interest duration /interest method :
999/.1139//SIMPLE
error in get_last_calc_balances: User-Defined Exception
Error in gen_amrtzn_schles_recalc_leases procedure
Error :1User-Defined Exception
Error in main procedure
Error :1User-Defined Exception


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Property Manager > Leases > Amend a lease to be terminated.
2. Schedules and Items (S&I) is kicked off.
3. S&I fails with the above error

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.