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 or iProcurement Responsibility Access
(Doc ID 1296761.1)
Last updated on JUNE 30, 2023
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.
On R12.1 When attempting to open Purchasing Options or Receiving Options window the following error occurs. The multi-org error can also occur with AME and with iProcurement or iProcurement Catalog Administration access.
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
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