My Oracle Support Banner

"Copy draft data from final failed" Error When Trying to Complete the Resume Changes Activity by Pressing Generate Balances or Discard Changes Button on Amend Lease Form (Doc ID 2976764.1)

Last updated on NOVEMBER 16, 2023

Applies to:

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

Symptoms

Resume Changes button is active (amendment is in progress).
Clicking on this button and entering to the "Amend Lease" form 2 buttons are active:
1/ Generate Balances
2/ Discard Amendment

Clicking on 1/ Generate Balances – there is error message on the bottom of the screen:

"Copy draft data from final failed".

In the FND Debug log file the error message displayed is :

"Error while synching the data from final to draft: ORA-01400: cannot insert NULL into ("PN"."PN_PAYMENT_SCHEDULES_ALL"."PAYMENT_SCHEDULE_ID")
PN Error while synching the data from final to draft: ORA-01400: cannot insert NULL into ("PN"."PN_PAYMENT_SCHEDULES_ALL"."PAYMENT_SCHEDULE_ID") "



STEPS
-----------------------
1. (N) Property Manager responsibility > Leases and Documents > Main Lease > Enter Leases and Documents

2. query the Lease in Find Leases form

3. in Leases form the Resume Changes button is active for the Lease in case

Clicking on this button and entering to the "Amend lease" form 2 buttons are active:
1/ Generate Balances
2/ Discard Amendment

Clicking on 1/ Generate Balances – there is error message on the buttom of the screen:
"Copy draft data from final failed".
Clicking on Discard Amendment and choosing YES , nothing happens.

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
References


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