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 SEPTEMBER 12, 2024

Applies to:

Symptoms

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

The error message shows the following:

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

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