In BMC.CORE:BMC_RequesttableOffering you should have all SRDs (one entry per SRD). Do you see the one causing an error?
Is this one in BMC.ASSET?
In the SRD form you have:
-> RO Instance ID that matches the BMC.CORE:BMC_RequesttableOffering instance ID
-> RO Recon ID that matches the BMC.CORE:BMC_RequesttableOffering reconciliation ID
0 isn't normal, check in the SRD if "RO Recon ID" is 0 too or have another value, take this value and put it into the reconciliation Identity from BMC.CORE:BMC_RequesttableOffering entry.
To see the values stored in the SRD, go into the "Service Catalog Manager Console", open the SRD and run a report.
User aruser, type "control+F" and search the form "BMC.CORE:BMC_RequesttableOffering" for example, double click to open it.
Search the record you want to export.
Then "Tools->Reporting", double click ok "<<<New Style>>>" and choose the fields you want in your report.
Then "Report->Save As->File" (or "Report->export to->File" I have a french version, anyway the choice that gives you the opportunity to export the end result) and select file type "csv" for example. You'll have a report in csv
i export report to get "RO Recon ID, RO Instance ID from form service request defintion base and get the value for two field and put it in form BMC.CORE:BMC_RequesttableOffering (the field RO Instance ID match for two forms but the RO Recon ID not match i copy value from from service request defintion base and put it in form BMC.CORE:BMC_RequesttableOffering but still the problem
If you want to regenerate automaticaly "as it is" requestable offering CI from a SRD :
Overlay filter : SRD:SHR:CreateROInstanceID
Add Modify in Execution Options
Use KA367533 solution :
delete the 3 fields from the Service Request Definition Base Form: RO Instance ID, RO Recon ID and RO Dataset ID (make these 3 fields blank)
go back on your SRD form and save it