My Oracle Support Banner

R12: APINVAPR ORA-20001: APP-FND-02902: Invoice Status is INITIATED even though invoice is Approved (Doc ID 2112531.1)

Last updated on MARCH 02, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Invoice Issues & MassAdd

ACTUAL BEHAVIOR
---------------
Create invoice ,validate it and approve it(go to Invoice Approval History and find the approval)
After that, the new status is still "Initiated"

Also, in output of $FND_TOP/sql/wfstat.sql you can see the error:

GET_HEADER_APPROVER #EXCEPTION -20001
ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.INIT, N, ERRNO, -20001, N, REASON, ORA-20001: APP-FND-02902: Multi-Org profile option is required.

Please set either MO: Security Profile or MO: Operating Unit profile option.

EXPECTED BEHAVIOR
-----------------------
Approval Status should be Approved

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Approve the invoice

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, invoice is still in 'INITIATED' Status

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
 Standard Patching Process
 Patch Wizard
 Have more questions?
References


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