Cost Rollup Gives "Bad Formula Effectivity" Error
Last updated on JULY 12, 2017
Applies to:Oracle Process Manufacturing Financials - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
EXECUTABLE:GMCROLL - OPM Cost Rollup Process
A Formula was created with an incorrect Item as the Product,
and a Recipe and Recipe Validity Rule were also created using
When this was noticed, we:
- deleted the incorrect Product Item from the Formula
- added the correct Product
- changed the Status of the Recipe and the VR to "Obsolete"
- created a new Recipe and VR
Everything seems fine except that OPM Cost Rollup now fails with
messages like :
BAD FORMULA EFFECTIVITY FOR ITEM No. :<Item> IN FORMULA No. :<Formula> VERSION <x>
.. where 'Item' is the Product, and 'Formula' is the Formula from which it has been removed.
In later versions of the code, this message may appear as :
Mrp Bill Error: set_form_eff_pointers-(MR_EFFMATLERR)-No product for form_eff formula_id xxxxx
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms