When I'm trying to create a 'Success Message' importer, it is failing with the below error:
"oracle.jbo.TooManyObjectsException: JBO-25013: Too many objects match the primary key oracle.jbo.Key[20003 SM_501017 US ]."
When I observed the standard integrator, which has 'Success Message' importer rule, the 'Importer' step has the same exception. Anyone create the 'Success Message' successfully without any error.
My requirement is that I get a value(reference as 'total') from a pre-importer sql query and I want to show this value ($importer$.total) in the success message.
I'm using :