My Oracle Support Banner

Error While Creating Account Site Using Hz_cust_account_site_v2pub.create_cust_acct_site API (Doc ID 2391517.1)

Last updated on APRIL 30, 2018

Applies to:

Oracle Trading Community - Version 12.2.7 and later
Information in this document applies to any platform.


On : 12.2.7 version, APIs

When attempting to create an account site using hz_cust_account_site_v2pub.create_cust_acct_site API
the following error occurs.

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..

The issue can be reproduced at will with the following steps:
1. Use hz_cust_account_site_v2pub.create_cust_acct_site API to create the account site.
2. It gives the error

The issue has the following business impact:
Due to this issue, users cannot create an account site from using the API.




To view full details, 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 a vibrant support community of peers and Oracle experts.