Add a check for bom quantity values not accepted by sap

[ngiacom]

For a specific BOM I have an esi failure: Job-95961 Error in [ProcessDefinitions/ERPCommunication/SAP/BOM/Start_CBOBOM_SAPCreate_PD.process/Invoke_BAPI_MATERIAL_BOM_GROUP_CREATEServer] Input data invalid ,

but I can't understand which is the data input invalid and why.

With a simple check the system can tell to me that a quantity in a bom has 4 decimal numbers (1.3072) and that it is not valid!

PTC Case ... no spr or article because for ptc is a third part issue.

[Marco_Tosin]

Nicola,

I voted your idea because we are implementing to send BOM from Windchill to SAP.

We are now facing what you described, using standard BAPI.

We asked our colleague who manage BOM in SAP to find a solution for this issue.

He said at least it should be possible to catch this failures in a report and then send this information to Windchill admin via mail.

Stay tuned for more news.

[ngiacom]

Hello Marco, thank you for your vote.

We had the issue only 1 time. Then we are quiet about it.

But I think that you have to check quantities in Windchill, not in SAP. Maybe you can edit the ESI Release Workflow and add your custom check.

I will stay tuned.

Thanks

[Marco_Tosin]

Nicola,

below an error example we got.

This message is useless to Windchill users because they can't see what happened in SAP.

In this case you have to open a specific SAP transaction, then find job error, double click on it and finally look at the red message showing error you are looking for.

|||for more information regarding this error please refer to the SAP Application Log (transaction SLG1)||||Job-1008 Error in [ProcessDefinitions/ERPCommunication/SAP/BOM/Start_CBOBOM_SAPChange_PD.process/Invoke_CSAP_MAT_BOM_MAINTAIN]

BW-AE-100011

[ngiacom]

Ok, my error was different: Input data invalid (4 digit in Windchill BOM QTY)

Your error is BW-AE-100011

It seems a Tibco/SAP error: RPC Server returned error message.

[Marco_Tosin]

Yes, it is.

However we have also sometimes same error you described about input data invalid .

[BenPerry]

Nicola Giacomelli‌,

I'm just looking from the outside.  I'm not sure about the details.  But perhaps your situation can be flagged by implementing the use of Windchill Business Rules prior to release to ERP?  I also haven't implemented them myself, so I'm not sure if they can be leveraged to flag quantities with a certain amount of decimal places (for example 1.3072).

I also wonder if you can add a constraint to the quantity on the WTPartUsageLink - a regular expression constraint - that can mitigate the issue from the start?

[syadala]

Yes Business rules work. or alternatively you can write a custom BOMComponentRenderer and trim the quantity as per the requirement.

[ngiacom]

Ben, I like very much your idea but Quantity.amount in WTPartUsageLink is "Double". I don't have the regular expression constraint in this case.

I think that regular expressions are usable only in "String" attributes

[ngiacom]

I didn't know Business Rules before today but it seems very complicated. Xml with loader....

I customized BOMComponentRenderer in the past then I can try but not now for a single case.

Thank you for your suggestions. However I think that PTC must implement something to check data validity for a TIBCO/SAP target.

[syadala]

We have achieved the functionality in Business rules and BOMComponentRenderer. Where as Business rules will make the user to update the Quantity the Renderer simply trims the additional fractions. The users liked the Renderer as it is faster way to send data to ERP. I would like this as preference on distribution target as we can have multiple targets and the precision can vary.

[BenPerry]

Sudhakar Yadala,

I think you nailed it - add this into the DT settings, as shown in the screenshot below.  Maybe under BOM Settings - or maybe under General Parameters.  Not sure where it makes the best sense.  I think that would be the easiest method for PTC to implement this product idea.

But Nicola Giacomelli, I don't want to hijack your product idea.  Do you agree with it?  Or are you looking for something else?

[ngiacom]

I agree!