We were upgrading from 11.5.9 to Release 12.1.2. We have a request set that submits many jobs and one of the jobs submits "Process Lockboxes".
"Process Lockboxes" was submitted but it completed with error “Program was terminated by signal 11”.
In Release 12, ARLPLB program has following two new parameters
|SUBMISSION_TYPE||This parameter does not have any value set associated with it. If you submit Process Lockboxes” using ‘Receivables -> Interfaces -> Lockbox, this parameter has a value of "L"|
|SCORING_MODEL||This parameter does not have any value set associated with it. If you submit Process Lockboxes” using ‘Receivables -> Interfaces -> Lockbox, this parameter has a value of NULL|
Our host program that submits “Process Lockboxes” using CONCSUB was passing only 11.5.9 parameters. It was not passing two new parameters. APLPBP is a Pro*C program, so it must be trying to access argv and argv (argv is first parameter) and it generated segmentation fault core dump. Signal 11 means segmentation fault.
So in order to fix this error, I just passed "L" and NULL for SUBMISSION_TYPE and SCORING_MODEL parameters. To pass NULL parameter using CONCSUB, one has to include two double quotes with single quote i.e '""'. (This found at http://freshers-oracleapplications.blogspot.com/2008/06/plsql.html, #28)