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
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***
On R12.1 When attempting to open Purchasing Options or Receiving Options window the following error occurs.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms