SAP Commissions, stage table error codes ... decoded?

[pauldevlin]

In the SAP Commisions product, once upon a time, when it was Callidus, even before Callidus became the Callidus Cloud, there was a table - I think it was called CS_RIPreferences. After Callidus went Cloud that table was no longer visible, but it's existence could still be inferred. The function below could read a stage table and decode (into one field) the entire list of errors pertaining to a given row. I only have a very stale version of the data from the table.

Is there an SAP provided function that performs this task?

If not, could/would someone share the latest content of the presumed table?

I will be tremendously obliged, thank you

CREATE OR REPLACE FUNCTION explainErrorCode(iPackageName varchar2, codeVal integer) RETURN varchar2 IS
explanation varchar2(1024);
codeRemaining integer;

cursor rip is
select * from CS_RIPreferences where packageName = iPackageName order by errorCode desc;

BEGIN

explanation := null;
codeRemaining := codeVal;

if CodeVal > 0 then
for i in rip
loop
if codeRemaining - power(2,i.errorcode) >= 0 then
explanation := explanation||i.messageKey||' ';
codeRemaining := codeRemaining - power(2,i.errorcode);
exit when codeRemaining = 0;
end if;

end loop;
end if;

RETURN explanation;
END explainErrorCode;
/

[sveabecker]

Welcome and Thank you for visiting SAP Community to get answers to your questions. Please add more details to your question, e.g. you can also add a screenshot. With that, you can reach a broader range of experts to get your question answered. I also recommend to do this tutorial https://developers.sap.com/tutorials/community-qa.html

The more details you provide, the more likely it is that members will be able to assist you.

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Regards, Svea

SAP Community moderator

[Lara]

Yes, that's right. You'd use the MessageKey field instead now.

[Lara]

Hi, Paul, yes, it's no longer CS_RIPreferences. That information is now stored in CS_MESSAGE.

[pauldevlin]

Thank you Lara. Is it therefore true to say, when looking at the messages where the category = 'Validation', that the objectSeq on those rows will refer to the unique key of a CS_StageWhatsoever row? Is it also true to say that no longer can one use the stageErrorCode by itself to decode what errors a given stage row has experienced?

[Yogananda]

Hi pauldevlin
Let me check and confirm to you.. Would need little more time..

[pauldevlin]

Thank you Yogananda