topic Reinstalling a blueprint? ( missing schema table ) in Data & Schema Discussions

Reinstalling a blueprint? ( missing schema table )

RADSr — Tue, 28 Jun 2022 17:52:54 GMT

I have the Oracle EBS blueprint installed but am getting an error ( lots of errors - but one at a time, eh? 😉 )

---

- Could not find parent EBS_FIN_COMMON.FINANCIALS_SYSTEM_PARAMS_ALL or child EBS_AP.AP_EXPENSE_REPORT_LINES_ALL of join EBS_AP.AP_EXPENSE_REPORT_LINES_ALL._@JOIN@_EBS_FIN_COMMON_FINANCIALS_SYSTEM_PARAMS_ALL.

---

The error makes sense because AP_EXPENSE_REPORT_LINES_ALL doesn't exist.

I tried to reinstall the blueprint, but no luck. I'm thinking of just deleting everything from the schema and reinstalling again, but thought I'd check here to see if anyone else had seen something like an incomplete blueprint install and how you 1) confirmed it and 2) resolved it.

I looked at the documentation and it seems the expense_lines_all table *should* exist as it is referenced in the documentation, but I didn't find an inventory of objects included w/ the blueprint.

Thx!

Re: Reinstalling a blueprint? ( missing schema table )

JoeM — Tue, 28 Jun 2022 20:02:05 GMT

@RADSr The guidance I am receiving is to try completing full loads on those schemas. After that, could you confirm if the problem still persists?

Re: Reinstalling a blueprint? ( missing schema table )

RADSr — Tue, 28 Jun 2022 20:12:38 GMT

I did - still getting the completed with errors message. Even upstream of that I'm getting an error for the model update status.

There is something *very* odd going on, I reinstalled the blueprint onto my cluster/tenant, but the sharing notification email for the reports is being sent with a link to a *different* cluster.

I'm onto support next and will update this w/ whatever we come up with. Thx!

Re: Reinstalling a blueprint? ( missing schema table )

JoeM — Tue, 28 Jun 2022 20:39:00 GMT

That sounds like the right move @RADSr!