R12-error 'unable to process your transaction. The operating unit is either invalid or it cannot B

In this document

Symptoms

Cause

Solution

Still have questions?

References

Applies to: Oracle trading community-version 12.1.1 and later
Information in this document applies to any platform.
* ** Checked for relevance 2-jul-2013 *** symptoms

In r12.1.1, run

Hz_cust_account_site_v2pub.create_cust_acct_site

And receive the following error message:

"Error-unable to process your transaction. The operating unit is either invalid or it cannot be derived. Please verify your multi-org Profile options.

The parameter for context used are from a valid receivables responsibility and was tested with receivables API without problems. now we are trying to create and update MERs with chloroform API, test with hz_cust_account_v2pub.create_cust_account API are fine, now tests with loading shows error because is not possible to validate org_id."

Steps to reproduce:

1. Execute the following to set the org_id:

Fnd_global.pai_initialize (user_id, repsp_id, reps_app_id );
Mo_global.set_policy_context ('s ', org_id );

2. Execute the following procedure:

P_cust_acct_site_rec.cust_account_id: = 5050;
P_cust_acct_site_rec.party_site_id: = 16051;
P_cust_acct_site_rec.created_by_module: = 'sistemas _ post ';
P_cust_acct_site_rec.application_id: = 222;
P_cust_acct_site_rec.status: = 'a ';
P_cust_acct_site_rec.org_id: = 82;

Hz_cust_account_site_v2pub.create_cust_acct_site
(P_init_msg_list => fnd_api.g_true,
P_cust_acct_site_rec => p_cust_acct_site_rec,
X_cust_acct_site_id => p_cust_acct_site_id,
X_return_status => p_return_status,
X_msg_count => p_msg_count,
X_msg_data => p_msg_data
);

 

Cause

Org context is not properly set.

Solution

To implement the solution, Please execute the following steps:

1) set the org context as follows:

Use the following queries to find responsibility ID and user ID:

A. query to find responsibility ID

Select responsibility_id, responsibility_name
From fnd_responsibility_vl
Where application_id = 222
And responsibility_name like '% & responsibility_name % ';

 
B. QUERY TO FIND user ID

Select user_id, user_name
From fnd_user
Where user_name = '& user_name ';

 
For example:
If resp_id = 50559 and user_id = 1318, then execute the following:

Fnd_global.pai_initialize (user_id => 1318, resp_id => 50559, resp_appl_id => 222 );
Mo_global.set_policy_context ('s ', <your_org_id> );

 
2) run the API.

Still have questions?

 

To discuss this information further with Oracle experts and industry peers, we encourage you to review, join or start a discussion in the my Oracle Support receivables community.

To provide feedback on this note, click on Rate this documentIcon at the top right corner of this note.

R12-error 'unable to process your transaction. The operating unit is either invalid or it cannot B