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 :
Please help me in resolving this issue.
Alternatively, copy from an existing uploader (search in BNE_INTEGRATORS_B) with the SQL below.
upload_param_list_app_id = 20003
,upload_param_list_code = <find one to copy from>
where integrator_code = <your code>
not supported, but does the trick.