Retail Predictive Application Server (MOSC)

MOSC Banner

Batch Error: Function/Proc not found, even after Implementing Custom Package in schema

edited Feb 17, 2025 2:50PM in Retail Predictive Application Server (MOSC) 5 commentsAnswered

RPAS VM version: 24.1.201.0.8.1516

I am trying to populate a measure using a custom package in VM of RPAS virtual box. I followed the instructions provided on the website,

  1. As per the example, created a same package with provided body and specification but in RPAS_DATA_MART_PDSVBOX schema in sql developer
  2. Created three measures and set 'customer managed' as true.

3. Created a rule with an execplsql expression.

4. Made the same changes in batch_calcoat, and execas define in the example .

After successfully running the patch, I ran the batch job, but it is failing with an error.

Expression::restoreExpression() caught exception

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center