R12: 'Multi-Org Profile Option Is Required' Error When Trying To Open Purchasing Options or Receiving Options Window Error JBO-30003 and JBO-29000 or on AME Approval (Doc ID 1296761.1)

Last updated on MARCH 13, 2017

Applies to:

Oracle Purchasing - Version 12.1.1 and later
Oracle iProcurement - Version 12.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 08-JAN-2013***

Symptoms

On R12.1 When attempting to open Purchasing Options or Receiving Options window the following error occurs.

Error:
JBO-30003: The application pool(arctestdb.azzawiyaoil.domUAT1531oracle.apps.po.setup.server.PurchasingSetupAM) failed to checkout an application module due to the  fallowing exception:
JBO-29000: Unexpected exception caught:
MESSAGE = java.sql.SQLException: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.

Same error occurs if  opening other pages like Document Types, Lines Types, Control Purchasing Period etc.
Financial Options form can be opened and setup is already done there.

Same error can also be present in some pages from payables module.

An additional symptom was noted when using the Approval Management Engine (AME) for approvals in Purchasing, after the approval action has been performed a notification with an error similar to the following is received.  And in this case the Operating Unit and Profile have already been set:

Error in Workflow REQAPPRV/####-#### 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

 

Steps to Reproduce:
1. Go to Purchasing Responsibility > Setup > Organizations
2. Press on Purchasing Options or Receiving Options menu function
3. Error occurs

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