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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms