Updates to OAS SQL for “Failed to Load SQL” error
While testing the BI Publisher to OAS migration in 23C, an issue was discovered where certain data models received a "Failed to Load SQL" error. It was determined this was due to how OAS interprets a "Regular Expression" syntax. We will be updating three of our product data models, used for our Aid Offer Letter, Aid Offer Letter (Max Award Version) and the Provisional Aid Offer Letter, to utilize the "ON OVERFLOW TRUNCATE WITH COUNT" operation. Please see our attachment to use as a template for updating any custom data models that currently contain a regular expression.
1