1 Reply Latest reply on Jan 21, 2020 6:46 AM by Gyana Panda-Oracle

    Recurring Lease Issue - RE_OPT_SCHED data gets removed

    3201184

      Hi,

      I'm not sure if other organizations also face this issue, usually during amendments to the lease, users are unable to save the lease due to some SQL fatal error (refer the attached image). On setting up Peoplecode trace we notice, it looks for the pre-existing row in the RE_OPT_SCHED table, to resolve this, we usually end up inserting the data from the database backend based on the data we see in the other test/dev environment for particular SCHEDULE_KEY, and user can continue working on the lease. We would like to know what causes the row to get removed as it happens randomly for a lease not for every lease.

       

      image001-4.png

       

      Do anybody else also face the same/similar issue? We are on PUM image 29 for the Lease Management module PS 9.2.