Skip to Main Content
Forums

PeopleSoft Enterprise

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Recurring Lease Issue - RE_OPT_SCHED data gets removed

User_BRCFUJan 16 2020 — edited Feb 26 2020

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.

Comments

John_K

Well, if you have two facts and you want to combine them, then they need to contain the same set of dimensions. Imagine you have two facts - cars and people. Cars have a num_wheels dimension and people have a hair_colour dimension. It makes no sense to report how many people have four wheels!!

You can actually combine facts at different dimensionality though using the FILTER clause. See here: Combining Facts/Subject Areas in Oracle OBIEE - Part 2 - Beyond Blog

Christian Berg-0racle

OBI at ist core is a source agnostic query Generator for any source there is.

Logical dimensions and Logical Facts are - as their "Logical" bit of the Name implies - actually completely artificial concepts and have Zero to do with the physical model in the strictest sense of the word. I can happily and easily create a 10 fact, 30 Dimension model where only 4 dims will ever be conformed on one single flat file.

You must comprehend this to comprehend why OBI does things the way it does them.

a) all business model concepts are virtual

b) don't even think "this Logical Dimension just means a dimension table" - through multiple LTSs and multiple tables nested inside each LTS I can create you a "Dimension" which - while a logical entity - is sourced from 20 physical sources, 2 being tables, 4 being cubes, 11 being XML and 3 coming from Hadoop

Yes this is the strongest feature of the NQuire Server which people still don't get comprehend 20 years after its inception.

1 person found this helpful
Thomas Dodds

Every fact has a dimensional context

Every dimensional attribute is related through a fact (conformed dimensions & implicit facts)

Use of information drives fact star design (typically a related set of business questions are answered by a single fact star)

+ to @"Christian Berg"

^ the basic rules

1 person found this helpful
Christian Berg-0racle

True, but contrary to breathing and heartbeat they don't happen automagically

1 person found this helpful
1 - 4

Post Details

Added on Jan 16 2020
#peoplesoft-general-discussion
2 comments
107 views