*Error* FX-110 Executing SPRUNCONVERSION in BPC10 MS

[former_member447983]

Greetings,

I have received the below message when I execute the SPRUNCONVERSION in BPC10 MS:

*Error*  FX-110 Problem in Category or Categhory_for_ope check properties

I have made sure that the category dimension in my Environment  contains the same properties that the Enviromental_Shell contains:

• Category_for_OPE
• FX_DIFFERENCE_ONLY
• FX_SOURCE_CATEGORY

What else should I check?

As appears in script logic:

RUN_STORED_PROCEDURE=SPRUNCONVERSION('FINANCE','ACTUAL','USD','RATECALC','%SCOPETABLE%', '%LOGTABLE%')

Business rules in place as directed by guide.

Any help is appreciated.

Regards,

Greg Lakin

[Former Member · Accepted solution]

Hi Greg,

according to your script you should have an element with the ID RATECALC in the entity dimension in your rate model. Is that correct?

Also, please share the category dimension used in your finance model, what are the properties and how is the element ACTUAL defined.

BR,

Arnold

[former_member447983 · Accepted solution]

Arnold,

RATECALC is an element of the entity dimension of my rate model.

Category dim:

Your assistance is appreciated.

Regards,

Greg Lakin

[former_member186498 · Accepted solution]

Hi Greg,

your Category_for _ope is empty, please copy it from corresponding ID and retry.

Regards

     Roberto

[Former Member · Accepted solution]

Hi Greg,

In category dimension maintain property Category_for _ope = ACTUAL in front of actual category and then try to run again. Also share whole log of package.

[former_member447983 · Accepted solution]

Roberto,

Thank you for your input.  I tried populating the Category_FOR_OPE with Actual.  This did not produce the answer.  I found the answer by reviewing the Time dimension, I noticed that the BASE_PERIOD field was not populated, I populated it processed the dim.  Now FX works.  Thank you for your input and your ideas.

Regards,

Greg Lakin

[Former Member · Accepted solution]

Hi Greg,

Thanks for sharing Answer. Mark as correct answer and kindly close the thread so it will help full for other also.

Kindly close the thread.

How to close a discussion and why

The SCN Rules of Engagement

[former_member186498]

Hi Greg,

despite the title this note contains the error codes of all the standard SAP stored procedures, 1827841 - Error return codes for the SPRUNCONVERSION stored procedure

Regards

     Roberto

[former_member447983]

Roberto,

Thanks for the list of error codes.  I saw the one pertaining to FX-110 and I have these properties present in my Category Dimension.

Regards,

Greg

[Former Member]

Hi Greg,

1) have you use same category dimension for Rate model and for finance model?

2)If you have all required properties then try to process your all dimension.

Instead of giving hard coded value for time being you can change the your script as shown below.

*RUN_STORED_PROCEDURE = SPRUNCONVERSION([%APP%],[%CATEGORY_SET%],[USD],[GLOBAL],[%SCOPETABLE%],[%LOGTABLE%])

*commit

Where Global = RateEntity member.

and do some changes in the advance script of DM package something like

PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when running logic.",1,{"Yes, check for work status settings before running logic","No, do not check work status settings"},{"1","0"})

PROMPT(SELECTINPUT,,,"Please select category, entity and time for restatement",%CATEGORY_DIM%%ENTITY_DIM%%TIME_DIM%)

TASK(Execute formulas,USER,%USER%)

TASK(Execute formulas,Environment,%Environment%)

TASK(Execute formulas,Model,%Model%)

TASK(Execute formulas,SELECTION,%SELECTIONFILE%)

TASK(Execute formulas,LOGICFILE,%ModelPath%\..\AdminApp\%Model%\FXTrans.lgf)

TASK(Execute formulas,RUNMODE,1)

TASK(Execute formulas,LOGICMODE,1)

TASK(Execute formulas,CHECKLCK,%CHECKLCK%)

3)have you maintained  RATECALC in rate entity?

[former_member447983]

BPC User,

Thanks for your input.

1. Yes Category dim is same for both the finance and rate models
2. Processed all dimensions
3. Made changes to the SPRUNCONVERSION statement.  Yes, ratecalc is a member of the RATESRC dimension which is the Entity dimension for the Rate model

Unfortunately, I am still receiving the FX-110 error.

Any additional insight would be appreciated.

Regards,

Greg Lakin

[Former Member]

Hi Greg,

FX-110 Problem may occur  due to if u haven't maintain below properties.

Your parameter CATEGORY is not valid OR

You don' t have the Property CATEGORY_FOR_OPE In your CATEGORY Dimension OR

You don' t have the Property RATE_CATEGORY In your CATEGORY Dimension OR

You don' t have the Property FX-DIFFERENCE_ONLY In your CATEGORY Dimension

I think you don't have RATE_CATEGORY, Try to maintain the property in category dimension.

Hope you are using same category dimension for both model.

Hope this will help you

[former_member447983]

Thank you for your response.  RATE_CATEGORY is present in the Category dimension,

[Former Member]

Hi ,

Note 1623848 is about the "ERROR* FX-110 Problem IN Category..." .

Thanks,

Peter

[former_member447983]

Thank you for your response.  As you can see in My original post I have hard coded the category as Actual. so this note does not apply.

Regards,

Greg