Cost Rollup Gives "Bad Formula Effectivity" Error
(Doc ID 434115.1)
Last updated on OCTOBER 26, 2020
Applies to:Oracle Process Manufacturing Financials - Version 11.5.10 and later
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 that Formula.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document