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
Essbase data load rule and SQL interface error — 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

Essbase data load rule and SQL interface error

Received Response
15
Views
8
Comments
edited May 27, 2020 12:52PM in Essbase 8 comments

Summary

Object not found when running a SQL interface based rule

Content

Hello,

We have the following error when executing both a SQL interfaced based Data Load Rule or Data Build Rule.

1. We define a connection toward ADW which validates OK

2. We define a data source, the query is recognized and works OK

3. We create a script (rule) : database / inspect / scripts / rule, rules is set up and validates OK

4. We load data using the DLR KO

Error while executing SQL "Select 
    'C' || fc.compte as indicateur,
    'M' || TO_CHAR(fc.date_ecriture, 'MM') as mois,
    fc.cod_section as section,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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