OPM Formula Upload  Help

OPM Formula Upload creates and updates Oracle Process Manufacturing (OPM / GMD) formulas – the formula header plus its ingredient, product and by-product detail lines (and formula and formula-line descriptive flexfields) – from one Excel sheet, via the Oracle public APIs. It can also delete individual formula lines.

When to use it

• Mass-load new OPM formulas with all their lines instead of keying them in the Formula form.
• Bulk-update header attributes (description, class, owner) on many existing formulas.
• Add new lines, or update quantities/UOM/attributes on existing lines, in bulk.
• Remove specific formula lines in bulk.
• Maintain formula or formula-line descriptive flexfield values across many formulas.

Before you start

• Blitz Report is installed and you are signed in to a responsibility with access to a process-enabled organization.
• Items are recipe-enabled in the owner organization, and each line’s UOM is convertible from the item’s primary UOM.
• Every new formula must contain at least one Ingredient line and at least one Product line.

Step 1 – Choose a mode, set the parameters and download

In Blitz Report, open OPM Formula Upload, choose an Upload Mode (Create for an empty template, or Create, Update to download existing formulas in the chosen organization), and optionally set the Organization Code and a specific Formula. Run the upload to download and open the Excel file. Each formula is automatically handled as a create or an update depending on whether it already exists.

Step 2 – Enter the formulas

Use one row per formula line; repeat the header columns on every line of the same formula, and keep a formula’s rows together. On the header enter the Organization Code, Formula, Formula Version, Formula Description and Header Scale Type. On each line enter the Line Type (Ingredient / Product / By-Product), Item, Quantity and Detail UOM.

Step 3 – Delete lines (optional)

To remove an existing line, set Delete Line to Yes on its row (offered only for lines that already exist). The formula header itself is never deleted by this upload.

Step 4 – Validate and Save

Click Validate and Save. This checks for missing required values and runs the upload’s validation, then saves the file. Correct anything it flags before continuing.

Step 5 – Upload and view the result

Back in Blitz Report, click Upload and select your saved file. This submits the Blitz Upload request, which creates or updates each formula and its lines. When it finishes, a result report opens showing each row as success or error.

What’s produced

• Created and updated formulas with their ingredient/product/by-product lines; deleted lines where flagged.
• A result report listing every row with a status (success or error) and a message.

Common questions

How do I enter header values for a multi-line formula?
Repeat the header columns (Organization Code, Formula, Version, Description, Class, Owner, Header Scale Type) on every line row of that formula, and keep the formula’s rows together.

How do I add a by-product or extra ingredient?
Add another row for the same formula with the appropriate Line Type, item, quantity and UOM.

Can I delete a whole formula?
No. The upload deletes individual lines only (Delete Line = Yes); it does not delete the formula header.

Can I change a formula’s organization or version?
No – Organization Code + Formula + Formula Version identify the formula and cannot be changed.

Why won’t my new formula load?
Every new formula needs at least one Ingredient line and at least one Product line.

Troubleshooting