Wednesday, July 14, 2010

Process Locboxes: ARLPLB Program was terminated by signal 11

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_TYPEThis 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[19] and argv[20] (argv[0] 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)

4 comments:

  1. Hi,

    Even i added the two parameters what you specified i am still getting the same error for the "Process Lockboxes".

    Could you please tell me what would be the problem ASAP?

    ReplyDelete
    Replies
    1. If you submit lockbox (using Responsibility "Receivables Manager" and Navigation Interfaces -> Lockbox), you will notice there are 22 parameters.
      In Oracle Application Rel 12.1.3, one more parameter has been added but concurrent program definition "ARLPLB" definition has not been updated. The new parameter has not been added at the end, it has been added before submission type. I do not know the parameter name or its purpose but passing a value of "N" for this parameter solved our issue.

      Delete
  2. Could You share us the Code? I am still facing the issue.

    ReplyDelete
  3. Hi,

    We are upgrading from 11.5.10 to 12.1.3 and submitting lockbox from Interfaces -> Lockbox. Program completes normal but for few invoices it gives "Invalid Matching Number". Same file processed fine in 11i. Did anyone face this issue? Unable debug it.

    Thanks a ton!

    ReplyDelete