My Oracle Support Banner

R12: AP/AME: Invoice Approval Initiated Errors with ORA-20108 on AME Attribute JOB_LEVEL_NON_DEFAULT_STARTING_POINT_PERSON_ID (Doc ID 2888660.1)

Last updated on AUGUST 17, 2022

Applies to:

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

Symptoms

Invoice submitted to Invoice Approval workflow raises error ORA-20108.

The error message shows the following:

ORA-20108: The transaction ID specified returned an incorrect number of rows for JOB_LEVEL_NON_DEFAULT_STARTING_POINT_PERSON_ID.
Ensure you specify a valid transaction ID and the dynamic query of the attribute returns correct number of rows

Invoice(s) are stuck in Error due to "Service Hold" and pending on PO Receipt(s).  It is expected that once the PO Receipt is created, the "Service Hold" should be released and Invoices should be Approved using the "Retry Errored Workflow Activities" program.

But, the "Retry Errored Workflow Activities" program is run multiple times and not picking up these Invoices.

.
 
Steps to reproduce:

  1. Log into Oracle Applications using Payables responsibility.
  2. Create a new AP Invoice.
  3. Submit the new Invoice to the Payables Invoice Approval Workflow. 
    Query the Invoice in the Invoice Workbench screen and select the [Actions...] button, then check "Initiate Approval" and [OK].
  4. The error message pops up.

This issue occurs only in the production instance. The issue DOES NOT replicate in the Non-Production instance.

Changes

 

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
Changes
Cause
Solution
 Changed AME attribute JOB_LEVEL_NON_DEFAULT_STARTING_POINT_PERSON_ID from STATIC to DYNAMIC
 Customizations
References


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