Data Load Error in BI

[Former Member]

Dear All,

We are receving this error.

"

Trace of execution of request returns this:

15:30:48:92 AUTH - - - S_RO_OSOA RC=12

Error in request:

You do not have authorization to extract from DataSource 8RUCRMDAR, comp. DM

Message no. R8073

Diagnosis

You are not authorized to extract from DataSource 8RUCRMDAR in application component: DM .

System response

The authorization check was performed with the following field values:

DataSource: 8RUCRMDAR

Application component: DM

Subobject: DATA

Activity: 03

Procedure

To be able to extract from the DataSource, you need authorization for authorization object S_RO_OSOA (authorizations SAPI-DataSource) with the field values specified above.

Procedure for System Administration

There is a role template S_RO_OSOA_TMPL (DataSource (OSOA) Display/Maintain/Extract) available that contains the authorizations to display, change and extract all DataSources.

Info from S_BCE_68001405:

26.11.2008 Dynamic List Display 1

-

---

-

---

Prof.name

Text

Type

Version

Changed by

Date

Time

-

---

&_SAP_ALL_1	Generated partial profile for SAP_ALL	G Generated	A Active Version	DDIC	23.11.2008	13:05:04
SAP_ALL	All SAP System authorizations	C Comp.profile	A Active Version	DDIC	23.11.2008	13:05:04
S_BI-WX_RFC	Business Information Warehouse, RFC-User Extraction	C Comp.profile	A Active Version	RINNEBERG	17.11.2006	13:16:50
S_RO_OSOAC	Complete SAPI DataSource	S Sgle profile	A Active Version	RINNEBERG	16.10.2006	10:01:52

-

---

"

After going through few links i have found solution to this as to "provide authorization for the appl.comp. you want in your user profile"

Kindly let meknow how to go about it.

Thanks in advance

[Former Member]

I have found that the object S_RO_OSOA is needed in BW and any other system that BW is doing a data load from. I have added it recently to my R3, BW and APO systems and it has resolved the error messages.

[Former Member]

Hi Malti - This is a new auth object for Data source which is not in earlier to ECC version, try assigning below object with following auth:

You can manually assign above object, if it exist on your version in PFCG-->Change Auth..

or you can copy profile 'S_RO_OSOAC' which comes with standard auth.

ACTVT: 03/23

OLTPSOURCE: *

OSOAAPCO:*

OSOAPART: DATA/DEFINATION.

Hope it helps you.

Thanks.