Skip to main content
Kofax

MarkView Self Service Invoice - Unable to 'Add a Line' - PL/SQL table out of range error

Summary

5291

Applies To

  • ERP System: Oracle
  • MarkView Version: 7.1 and higher

Behavior

  • When attempting to add a Distribution Line through Self Service Invoice ( SSI ) an error similar to the following may occur:
    2012-08-24 10:02:58,873 [AJPRequestHandler-HTTPThreadGroup-5] ERROR com.markview.ssi.controller.DistributionEntryAction:215 - 
    java.sql.SQLException: ORA-06513: PL/SQL: index for PL/SQL table out of range for host language array
    ORA-06512: at line 1

Known Causes

  • This issue can occur if the value of the MAX_FLEXFIELD_SEGMENTS parameter is less than the total number of flex field segments in your environment.

Resolution

  • WebLogic
    • Stop the MarkView Application Server
    • Explode the self-service-invoice-ear.ear file
    • Open the ssi/WEB-INF/web.xml file for editing and find the following parameters:
      • <context-param>
        <param-name>MAX_FLEXFIELD_SEGMENTS</param-name>
        <param-value>100</param-value>
        </context-param>
    • Increase the value of the MAX_FLEXFIELD_SEGMENTS parameter such that it is greater than the total number of flex field segments. ( For example if you have 48 flex field segments, set the preference to a value of 50 to resolve the issue. )
    • Save the file and re-package the self-service-invoice-ear.ear file
    • Re-deploy the self-service-invoice-ear.ear file through WebLogic
    • Start the MarkView Application Server
  • Oracle Application Server (OAS)
    • Begin re-deploying the self-service-invoice-ear.ear file through Enterprise Manager.
    • Before fully deploying modify the deployment plan directly in Enterprise Manager to change the MAX_FLEXFIELD_SEGMENTS parameter such that it is greater than the total number of flex field segments. ( For example if you have 48 flex field segments, set the preference to a value of 50 to resolve the issue. )
    • Finishing deploying the self-service-invoice-ear.ear file.

Keywords: ssi, self service invoice, self-service invoice