Record Creation Through CSV Returns ""file:///studio/bp/action_service.xml:1052: com.skire.form.types.RuleException" (Doc ID 2400242.1)

Last updated on FEBRUARY 03, 2023

Applies to:

Symptoms

On Unifier : Any Version

The works space has a Rule defined that returns the value from the 'Show this message when condition is not met' when the Rule is violated, e.g., "Contracts Cannot Exceed $5,000,000.00".

EXPECTED OUTCOME: When a record that violates the Rule is created through CSV file import, the Failed external email notification that is received by the end user in their local email interface should return the value entered into the 'Show this message when condition is not met' setting of the Rule for the 'Reason', e.g., "Contracts Cannot Exceed $5,000,000.00".

ACTUAL OUTCOME: When a record that violates the Rule is created through CSV file import the Failed external email notification that is received by the end user in their local email interface returns a value of the following for the 'Reason: "file:///studio/bp/action_service.xml:1052: com.skire.form.types.RuleException"

STEPS TO REPRODUCE:

1. In one Project/Shell, setup a Rule, e.g., a source of 'Project Cost' at a 'Per Total for entire project' level and define some conditions that will throw a Rule Exception when a record is created that will violate the rule and set it to Active. Specifically notice the value that is defined in the 'Show this message when condition is not met' setting on the Rule tab of the Rule in Admin mode, e.g., "Contracts Cannot Exceed $5,000,000.00".
2. Ensure that the Business Process(es) (BP's) that are defined in the Limit and Data Expressions for the Rule have you (the tester) defined in the 'Send error notification to' setting in the BP Setup(s), and that preferences allow you to receive the email notifications.
3. At run time create one Business Process record manually through the UI that will violate the Rule and notice the Rule Exception that is thrown, specifically the value of of the 'Description' that is returned, in this case; "Contracts Cannot Exceed $5,000,000.00".
4. Terminate or Delete the Draft record that threw the Rule Exception.
5. Export the CSV template to create the record and its respective line item by clicking on 'Actions > Export CSV Template' from the BP log.
6. Save CSV template and populate it with the same data used to create the record manually through the UI that threw the Rule Exception in #3 above.
7. Import the CSV template by clicking on 'Actions > Import' from the BP log and notice that when a record that violates the Rule is created through CSV file import, the Failed external email notification that is received by the end user returns the following:

Reason: file:///studio/bp/action_service.xml:1052: com.skire.form.types.RuleException

Because of this the user is confused as to why the import failed and has to seek assistance from support.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.