My Oracle Support Banner

Cost Rollup Gives "Bad Formula Effectivity" Error (Doc ID 434115.1)

Last updated on AUGUST 13, 2024

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

Goal

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

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.