Error when activating data in 0FI_GL_04 ODS (SIDS)

[Former Member]

Hi

I have succesfully loaded data for the 0FI_GL04 ODS but it is failing on activation with the following error: -

<i>Error when assigning SID: Action VAL_SID_CONVERT table 0POSTXT

Value '# ' (hex. '23 ') of characteristic 0POSTXT contains invalid characters

Process 000061 returned with errors</i>

I have the '# ' as a permitted charcter in IMG so does anyone have any ideas why this is failing.

I do have generate SIDS ticked on the ODS as this will be used for reporting and it supposedly makes it more efficient if done when loading....not this time )

Any ideas

Andy

[Former Member]

Hi,

0posttxt field contains the invalid chars #, you can execute this chars in RSKC Tcode or and try to activate it otherwise if you are loading data from PSA you can edit it there and repeat the load, and activate the ODS. you can get the record details in monitor details tab.

Regards

Sankar

[Former Member]

Thanks Sankar but this isn't the problem as i have these fields in my permitted characters

[Former Member]

Hi,

Then try to edit the data in PSA and load it. otherwise you have to edit the data in source system.

Regards

Sankar

[Former Member]

Hi Andrew,

the # is a special character which can't be posted as single character neither as first char in a master data ID...

did you solve your issue finally??

let us know

Olivier.

[Former Member]

Hi Olivier

At the moment I have not solved this. I have turned off the sid creation option in the ODS and then loads and activates fine.

I think I will need to investigate further once i get the time to breathe a little.

Thanks

Andy

[Former Member]

Hi,

Try the note 862701.

Best Regards,

Rajani

[Former Member]

Hi mate

Don't think this is the same thing??

As mine is to do with an incorrect value it states???

Andy

Message was edited by:

Andrew Watson

[Former Member]

<b>FURTHER INFORMATION</b>

If i take away the SID generation tick on the ODS settigns then it works fine

However, woudl still like to solve this

Andy

[Former Member]

any ideas anyone??

I think this is a general problem not neccessarily related to the FI ODS

[Former Member]

Hi,

this is not a "problem"; if you want to report on your ODS you'll have to mark the BEx reporting indicator. As soon as you do that, the activation of a request will check the SIDs of your IObjs. If an IObj master data ID doesn't have a SID the system will need to generate (for reporting). If your master data ID doesn't cope with the rules (permitted chars, lower case chars...) you'll get this errmsg.

hope this explain your issue;

Olivier.

[Former Member]

Yeah but how do you solve it as i cannot report on it if it doesn't activate???

Message was edited by:

Andrew Watson

[Former Member]

if you have invalid charaters, then add them in the permitted characters via RSKC.

If you don't want to add them then write a routine in order to cope with the rules.

What I did is to create a ZIObj and update these "free text" in the ZIOBj Text during the transactional load. Texts are definitively not as restrictive as master data IDs.

hope this helps...

Olivier.

Message was edited by:

Olivier Cora