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.
Invoice submitted to Invoice Approval workflow raises error ORA-20108.
The error message shows the following:
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:
- Log into Oracle Applications using Payables responsibility.
- Create a new AP Invoice.
- 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].
- The error message pops up.
This issue occurs only in the production instance. The issue DOES NOT replicate in the Non-Production instance.
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
|Changed AME attribute JOB_LEVEL_NON_DEFAULT_STARTING_POINT_PERSON_ID from STATIC to DYNAMIC|