My Oracle Support Banner

Lease Attachments Program Error ORA-06512: at APPS.PN_LEASE_ATTACHMENTS (Doc ID 2945863.1)

Last updated on MAY 05, 2023

Applies to:

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

Symptoms

 On : 12.2.5 version, Lease Attachments Program.

Query the lease and click on the 'Generate Balances' button on the Lease form, system auto submits Upload Lease Attachments program, the following error occurs in the log file.

.........
PN:PNAttachments:runProgram: In the exception section
PN:PNAttachments:runProgram: Request completed with errors
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException: ORA-06503: PL/SQL: Function returned without value
ORA-06512: at "APPS.PN_LEASE_ATTACHMENTS", line 508
ORA-06512: at line 1

..........

Due to this issue, lease is not attached on Lease definition.

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


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