Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Create Temporary Table or View for complex agreement template — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Create Temporary Table or View for complex agreement template

Received Response
12
Views
1
Comments
edited Aug 8, 2022 5:13AM in Reporting and Analytics for HCM 1 comment

Summary:

Seeking advice regarding BI publisher capabilities to create temporary data tables.

Content (required):

Hi team,

I am seeking advice as to whether it is possible to create temporary tables or views within BI publisher for referencing complex queries.

Our use case is that we are needing to conditionally display a complex table within the offer letter for employees hired under award conditions. Currently this data is maintained using an excel worksheet and a number of formulas. This is both due to ease of use and also ease of maintenance where award rates could change at any time.

We would like to create a temporary SQL table within a query that we can then reference with formulas to determine rates that will populate the agreement. The thought process is that by using a temporary table we could update the top of the query without constantly updating the body of the model where the formulas need to retrieve values.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!