R12: APXINWKB : FRM-40350 APP-SQLAP-10108 : When Attempting to Create a Second Invoice with Distribution Window Open (Doc ID 2179351.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Payables - Version 12.1.3 to 12.2.3 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to create a second invoice on the invoice workbench and the distribution window is still open the following error occurs.

ERROR
FRM-40350 Query caused no records to be retrieved
APP-SQLAP-10108 An error occurred while trying to commit


STEPS
The issue can be reproduced at will with the following steps:

  1. Enter first invoice header
  2. Click on 'Lines' tab and enter amount
  3. Click on 'Distributions' button, enter amount, cost code etc and save - do not close the Distributions window
  4. Click on Invoice Workbench window and enter second invoice header
  5. Click on Lines tab - following error messages appear : 

    FRM-40350 Query caused no records to be retrieved 
    APP-SQLAP-10108 An error occurred while trying to commit

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms