My Oracle Support Banner

R12: AP/IBY: Create Payment Error:FRM-41105: You cannot query records without a saved parent record. (Doc ID 2098313.1)

Last updated on MARCH 04, 2024

Applies to:

Oracle Payables - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to create payment the following error occurs.

Exception occurred when performing payment creation
FRM-41105: You cannot query records without a saved parent record.

After pressing the [Save] icon, the error message raises, and payment document number is displayed as "-1" 


Steps to reproduce:

  1. Log into Oracle Applications using a Payables responsibility
  2. Open the Invoice Workbench screen
    (N) Invoices > Entry > Invoices
  3. Query an invoice to be paid.
  4. Click on [Actions] > Pay In Full
  5. The Payment Workbench screen opens
    (N) Payments > Entry > Payments
  6. Enter the new Quick Payment information
  7. Hit the [Save] icon, you get the error message mentioned.
      

A FND Debug Log of the issue reproduced, shows the following error/messages:

IBY_DISBURSE_SINGLE_PMT_PKG.submit_single_payment : Found payment request 175 in "assignment complete" status.
IBY_DISBURSE_SINGLE_PMT_PKG.submit_single_payment : Going to validate documents for payment request 175
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets : IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets:ENTER
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets : IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets:Payment request id: 175
IBY_VALIDATIONSETS_PUB.initDocDataForPPR : IBY_VALIDATIONSETS_PUB.initDocDataForPPR:Enter initDocDataForPPR
IBY_VALIDATIONSETS_PUB.initDocDataForPPR : IBY_VALIDATIONSETS_PUB.initDocDataForPPR:Process Type is:IMMEDIATE
IBY_VALIDATIONSETS_PUB.initDocDataForPPR : IBY_VALIDATIONSETS_PUB.initDocDataForPPR:Exit initDocDataForPPR
IBY_VALIDATIONSETS_PUB.initDocDataForPPR : IBY_VALIDATIONSETS_PUB.initDocDataForPPR:SQL code: -12899
IBY_VALIDATIONSETS_PUB.initDocDataForPPR : IBY_VALIDATIONSETS_PUB.initDocDataForPPR:SQL err msg: ORA-12899: value too large for column
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets : IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets:ORA-12899: value too large for column "IB
IBY_DISBURSE_SINGLE_PMT_PKG.submit_single_payment : Exception occured when validating documents. Document validation will be aborted and no docu
IBY_DISBURSE_SINGLE_PMT_PKG.submit_single_payment : SQLCODE: 1
IBY_DISBURSE_SINGLE_PMT_PKG.submit_single_payment : SQLERRM: User-Defined Exception.

 

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
 CODE-FIX
 WORKAROUND
 OTHER CAUSES/SOLUTIONS
 IF STILL NOT RESOLVED
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.