OPM Recipe Upload
Description
OPM Recipe Upload creates and updates Oracle Process Manufacturing (OPM / GMD) recipes – the recipe header plus its validity rules, routing-step overrides, step/material associations, per-organization process loss, customers, and org-specific operation and resource overrides – all in one spreadsheet. A Row Type column on each row tells the upload which recipe entity that row represents.
When to use it
- Load new OPM recipes in bulk from a spreadsheet instead of keying them in the Recipe form.
- Mass-update recipe header fields (status, yield, process loss, flexfields) across many recipes.
- Add or update recipe validity rules in bulk.
- Set routing-step quantities/yields, step/material transfer quantities and delays, or per-organization process loss.
- Assign customers to recipes en masse.
- Apply org-specific operation (activity factor) and resource (usage, capacity, process parameters) overrides.
Before you start
- Blitz Report is installed and you are signed in to a responsibility with access to a process-enabled organization.
- The formula and routing the recipe is built on already exist in that organization.
- Steps, operations and material items referenced exist in the recipe’s routing and formula.
How the Row Type works
Each row represents exactly one recipe entity, chosen in the Row Type column. The recipe key (Organization Code + Recipe + Recipe Version) repeats on every row of the same recipe, and the rows are grouped and applied together.
| Row Type | What the row defines |
|---|---|
| Recipe | The recipe header (formula, routing, status, yield, process loss, flexfields). |
| Validity Rule | A recipe validity rule (product, quantities, effective dates, preference). |
| Routing Step | A routing-step override – step quantity / operation yield. |
| Step Material | A step/material association – min transfer quantity, min/max delay. |
| Process Loss | Per-organization process loss. |
| Customer | A recipe customer assignment. |
| Org Operation | An org-specific operation override (activity factor). |
| Org Resource | An org-specific resource override (usage, capacity, process parameters). |
Step 1 – Choose a mode, set the parameters and download
In Blitz Report, open OPM Recipe Upload, choose an Upload Mode (Create for an empty template, or Create, Update to download existing recipes), and optionally set the Organization Code and a specific Recipe. Run the upload to download and open the Excel file. Each recipe is automatically handled as a create or an update depending on whether it already exists.
Step 2 – Enter the recipe rows
On every row fill the recipe key (Organization Code, Recipe, Recipe Version) and choose the Row Type, then fill only that entity’s columns and leave the rest blank. A recipe normally has one Recipe row plus any number of detail rows.
Step 3 – 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 4 – Upload and view the result
Back in Blitz Report, click Upload and select your saved file. This submits the Blitz Upload request, which applies each recipe and its detail entities in order. When it finishes, a result report opens showing each row as success or error.
What’s produced
- Created and updated recipes with their validity rules, step and material overrides, process loss, customers, and org operation/resource overrides.
- A result report listing every row with a status (success or error) and a message.
Common questions
How does the upload know which fields apply to a row?
The Row Type column. Each row is one recipe entity; fill only that entity’s columns and leave the rest blank.
Do I repeat the recipe key on every row?
Yes – Organization Code, Recipe and Recipe Version must be filled on every row so the rows group to the correct recipe.
Does it create or update, and how do I choose?
It decides automatically per recipe – existing recipe = update, new = create. Use Create, Update to download existing recipes for editing; Create gives an empty template.
Can I delete recipes or rows with this upload?
No. This upload only creates and updates.
Why must the formula and routing already exist?
A recipe is built on an existing formula and routing – the upload references them by name/version and does not create them.
Troubleshooting
| Message | Cause | What to do |
|---|---|---|
| Organization is not a valid process-enabled organization | The Organization Code (or Sub-Organization Code) is not an OPM process-enabled org, or you have no access. | Use a process-enabled org from the dropdown that you have access to. |
| Routing step not found in the recipe routing | A Routing Step / Org Operation / Org Resource / Step Material row references a step that isn’t in the recipe’s routing. | Use a step that exists in the routing tied to this recipe. |
| Step or item not found in the recipe (Step Material) | The step or material item can’t be matched to the recipe’s routing step and formula line. | Ensure the item is a material line on the recipe’s formula and the step exists in the routing. |
| Customer not found | The customer account number isn’t an active customer. | Choose an active customer from the dropdown. |
| Recipe / Validity rule attributes error | A descriptive flexfield value failed validation. | Correct the flexfield Attribute values for the chosen Attribute Category. |
select null action_, null status_, null message_, null modified_columns_, row_number() over (order by x.recipe, x.recipe_version, x.row_type_sort, x.step, x.product, x.validity_rule_id) upload_row, x.organization_code, x.recipe, x.recipe_version, x.row_type, x.creation_organization_code, x.recipe_description, x.formula, x.formula_version, x.routing, x.routing_version, x.recipe_type, x.recipe_status, x.planned_process_loss, x.fixed_process_loss, x.fixed_process_loss_uom, x.recipe_yield, x.contiguous, x.enhanced_process_instructions, x.calculate_step_quantity, x.owner, x.ha_attribute_category, x.ha_attribute1, x.ha_attribute2, x.ha_attribute3, x.ha_attribute4, x.ha_attribute5, x.ha_attribute6, x.ha_attribute7, x.ha_attribute8, x.ha_attribute9, x.ha_attribute10, x.ha_attribute11, x.ha_attribute12, x.ha_attribute13, x.ha_attribute14, x.ha_attribute15, x.ha_attribute16, x.ha_attribute17, x.ha_attribute18, x.ha_attribute19, x.ha_attribute20, x.ha_attribute21, x.ha_attribute22, x.ha_attribute23, x.ha_attribute24, x.ha_attribute25, x.ha_attribute26, x.ha_attribute27, x.ha_attribute28, x.ha_attribute29, x.ha_attribute30, x.validity_rule_use, x.validity_organization_code, x.product, x.vr_revision, x.preference, x.standard_quantity, x.minimum_quantity, x.maximum_quantity, x.vr_detail_uom, x.start_date, x.end_date, x.vr_planned_process_loss, x.vr_fixed_process_loss, x.vr_fixed_process_loss_uom, x.va_attribute_category, x.va_attribute1, x.va_attribute2, x.va_attribute3, x.va_attribute4, x.va_attribute5, x.va_attribute6, x.va_attribute7, x.va_attribute8, x.va_attribute9, x.va_attribute10, x.va_attribute11, x.va_attribute12, x.va_attribute13, x.va_attribute14, x.va_attribute15, x.va_attribute16, x.va_attribute17, x.va_attribute18, x.va_attribute19, x.va_attribute20, x.va_attribute21, x.va_attribute22, x.va_attribute23, x.va_attribute24, x.va_attribute25, x.va_attribute26, x.va_attribute27, x.va_attribute28, x.va_attribute29, x.va_attribute30, x.step, x.operation, x.operation_version, x.step_quantity, x.operation_yield, x.material_line_type, x.material_item, x.minimum_transfer_quantity, x.minimum_delay, x.maximum_delay, x.sub_organization_code, x.process_loss, x.pl_fixed_process_loss, x.pl_fixed_process_loss_uom, x.pl_contiguous, x.customer, x.operation_line, x.activity_factor, x.resource_code, x.resource_usage, x.usage_uom, x.process_quantity, x.process_uom, x.minimum_capacity, x.maximum_capacity, x.process_parameter_1, x.process_parameter_2, x.process_parameter_3, x.process_parameter_4, x.process_parameter_5, x.recipe_id, x.validity_rule_id, x.routing_step_id, x.formulaline_id, x.recipe_process_loss_id from ( select mp.organization_code, grcv.recipe_no recipe, grcv.recipe_version, 'Recipe' row_type, (select mp2.organization_code from mtl_parameters mp2 where mp2.organization_id=grcv.creation_organization_id) creation_organization_code, grcv.recipe_description, (select ffmb.formula_no from fm_form_mst_b ffmb where ffmb.formula_id=grcv.formula_id) formula, (select ffmb.formula_vers from fm_form_mst_b ffmb where ffmb.formula_id=grcv.formula_id) formula_version, (select grb.routing_no from gmd_routings_b grb where grb.routing_id=grcv.routing_id) routing, (select grb.routing_vers from gmd_routings_b grb where grb.routing_id=grcv.routing_id) routing_version, xxen_util.meaning(to_char(grcv.recipe_type),'GMD_RECIPE_TYPE',552) recipe_type, (select gsv.meaning from gmd_status_vl gsv where gsv.status_code=grcv.recipe_status) recipe_status, grcv.planned_process_loss, grcv.fixed_process_loss, grcv.fixed_process_loss_uom, grcv.recipe_yield, xxen_util.meaning(decode(grcv.contiguous_ind,1,'Y','N'),'YES_NO',0) contiguous, xxen_util.meaning(grcv.enhanced_pi_ind,'YES_NO',552) enhanced_process_instructions, xxen_util.meaning(decode(grcv.calculate_step_quantity,1,'Y','N'),'YES_NO',0) calculate_step_quantity, (select fu.user_name from fnd_user fu where fu.user_id=grcv.owner_id) owner, xxen_util.display_flexfield_context(552,'GMD_RECIPES_FLEX',grcv.attribute_category) ha_attribute_category, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE1',grcv.rowid,grcv.attribute1) ha_attribute1, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE2',grcv.rowid,grcv.attribute2) ha_attribute2, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE3',grcv.rowid,grcv.attribute3) ha_attribute3, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE4',grcv.rowid,grcv.attribute4) ha_attribute4, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE5',grcv.rowid,grcv.attribute5) ha_attribute5, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE6',grcv.rowid,grcv.attribute6) ha_attribute6, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE7',grcv.rowid,grcv.attribute7) ha_attribute7, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE8',grcv.rowid,grcv.attribute8) ha_attribute8, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE9',grcv.rowid,grcv.attribute9) ha_attribute9, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE10',grcv.rowid,grcv.attribute10) ha_attribute10, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE11',grcv.rowid,grcv.attribute11) ha_attribute11, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE12',grcv.rowid,grcv.attribute12) ha_attribute12, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE13',grcv.rowid,grcv.attribute13) ha_attribute13, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE14',grcv.rowid,grcv.attribute14) ha_attribute14, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE15',grcv.rowid,grcv.attribute15) ha_attribute15, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE16',grcv.rowid,grcv.attribute16) ha_attribute16, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE17',grcv.rowid,grcv.attribute17) ha_attribute17, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE18',grcv.rowid,grcv.attribute18) ha_attribute18, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE19',grcv.rowid,grcv.attribute19) ha_attribute19, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE20',grcv.rowid,grcv.attribute20) ha_attribute20, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE21',grcv.rowid,grcv.attribute21) ha_attribute21, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE22',grcv.rowid,grcv.attribute22) ha_attribute22, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE23',grcv.rowid,grcv.attribute23) ha_attribute23, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE24',grcv.rowid,grcv.attribute24) ha_attribute24, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE25',grcv.rowid,grcv.attribute25) ha_attribute25, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE26',grcv.rowid,grcv.attribute26) ha_attribute26, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE27',grcv.rowid,grcv.attribute27) ha_attribute27, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE28',grcv.rowid,grcv.attribute28) ha_attribute28, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE29',grcv.rowid,grcv.attribute29) ha_attribute29, xxen_util.display_flexfield_value(552,'GMD_RECIPES_FLEX',grcv.attribute_category,'ATTRIBUTE30',grcv.rowid,grcv.attribute30) ha_attribute30, null validity_rule_use, null validity_organization_code, null product, null vr_revision, null preference, null standard_quantity, null minimum_quantity, null maximum_quantity, null vr_detail_uom, null start_date, null end_date, null vr_planned_process_loss, null vr_fixed_process_loss, null vr_fixed_process_loss_uom, null va_attribute_category, null va_attribute1, null va_attribute2, null va_attribute3, null va_attribute4, null va_attribute5, null va_attribute6, null va_attribute7, null va_attribute8, null va_attribute9, null va_attribute10, null va_attribute11, null va_attribute12, null va_attribute13, null va_attribute14, null va_attribute15, null va_attribute16, null va_attribute17, null va_attribute18, null va_attribute19, null va_attribute20, null va_attribute21, null va_attribute22, null va_attribute23, null va_attribute24, null va_attribute25, null va_attribute26, null va_attribute27, null va_attribute28, null va_attribute29, null va_attribute30, null step, null operation, null operation_version, null step_quantity, null operation_yield, null material_line_type, null material_item, null minimum_transfer_quantity, null minimum_delay, null maximum_delay, null sub_organization_code, null process_loss, null pl_fixed_process_loss, null pl_fixed_process_loss_uom, null pl_contiguous, null customer, null operation_line, null activity_factor, null resource_code, null resource_usage, null usage_uom, null process_quantity, null process_uom, null minimum_capacity, null maximum_capacity, null process_parameter_1, null process_parameter_2, null process_parameter_3, null process_parameter_4, null process_parameter_5, grcv.recipe_id, null validity_rule_id, null routing_step_id, null formulaline_id, null recipe_process_loss_id, 1 row_type_sort from gmd_recipes_vl grcv, mtl_parameters mp where grcv.owner_organization_id=mp.organization_id and grcv.delete_mark=0 and grcv.owner_organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and :p_upload_mode like '%'||xxen_upload.action_update union all select mp.organization_code, grcv.recipe_no recipe, grcv.recipe_version, 'Validity Rule' row_type, null creation_organization_code, null recipe_description, null formula, null formula_version, null routing, null routing_version, null recipe_type, null recipe_status, null planned_process_loss, null fixed_process_loss, null fixed_process_loss_uom, null recipe_yield, null contiguous, null enhanced_process_instructions, null calculate_step_quantity, null owner, null ha_attribute_category, null ha_attribute1, null ha_attribute2, null ha_attribute3, null ha_attribute4, null ha_attribute5, null ha_attribute6, null ha_attribute7, null ha_attribute8, null ha_attribute9, null ha_attribute10, null ha_attribute11, null ha_attribute12, null ha_attribute13, null ha_attribute14, null ha_attribute15, null ha_attribute16, null ha_attribute17, null ha_attribute18, null ha_attribute19, null ha_attribute20, null ha_attribute21, null ha_attribute22, null ha_attribute23, null ha_attribute24, null ha_attribute25, null ha_attribute26, null ha_attribute27, null ha_attribute28, null ha_attribute29, null ha_attribute30, xxen_util.meaning(grvr.recipe_use,'GMD_FORMULA_USE',552) validity_rule_use, (select mp2.organization_code from mtl_parameters mp2 where mp2.organization_id=grvr.organization_id) validity_organization_code, (select msiv.concatenated_segments from mtl_system_items_vl msiv where msiv.inventory_item_id=grvr.inventory_item_id and msiv.organization_id=grcv.owner_organization_id) product, grvr.revision vr_revision, grvr.preference, grvr.std_qty standard_quantity, grvr.min_qty minimum_quantity, grvr.max_qty maximum_quantity, grvr.detail_uom vr_detail_uom, grvr.start_date, grvr.end_date, grvr.planned_process_loss vr_planned_process_loss, grvr.fixed_process_loss vr_fixed_process_loss, grvr.fixed_process_loss_uom vr_fixed_process_loss_uom, xxen_util.display_flexfield_context(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category) va_attribute_category, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE1',grvr.rowid,grvr.attribute1) va_attribute1, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE2',grvr.rowid,grvr.attribute2) va_attribute2, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE3',grvr.rowid,grvr.attribute3) va_attribute3, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE4',grvr.rowid,grvr.attribute4) va_attribute4, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE5',grvr.rowid,grvr.attribute5) va_attribute5, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE6',grvr.rowid,grvr.attribute6) va_attribute6, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE7',grvr.rowid,grvr.attribute7) va_attribute7, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE8',grvr.rowid,grvr.attribute8) va_attribute8, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE9',grvr.rowid,grvr.attribute9) va_attribute9, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE10',grvr.rowid,grvr.attribute10) va_attribute10, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE11',grvr.rowid,grvr.attribute11) va_attribute11, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE12',grvr.rowid,grvr.attribute12) va_attribute12, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE13',grvr.rowid,grvr.attribute13) va_attribute13, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE14',grvr.rowid,grvr.attribute14) va_attribute14, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE15',grvr.rowid,grvr.attribute15) va_attribute15, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE16',grvr.rowid,grvr.attribute16) va_attribute16, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE17',grvr.rowid,grvr.attribute17) va_attribute17, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE18',grvr.rowid,grvr.attribute18) va_attribute18, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE19',grvr.rowid,grvr.attribute19) va_attribute19, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE20',grvr.rowid,grvr.attribute20) va_attribute20, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE21',grvr.rowid,grvr.attribute21) va_attribute21, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE22',grvr.rowid,grvr.attribute22) va_attribute22, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE23',grvr.rowid,grvr.attribute23) va_attribute23, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE24',grvr.rowid,grvr.attribute24) va_attribute24, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE25',grvr.rowid,grvr.attribute25) va_attribute25, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE26',grvr.rowid,grvr.attribute26) va_attribute26, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE27',grvr.rowid,grvr.attribute27) va_attribute27, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE28',grvr.rowid,grvr.attribute28) va_attribute28, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE29',grvr.rowid,grvr.attribute29) va_attribute29, xxen_util.display_flexfield_value(552,'GMD_RECIPE_VALIDITY_RULES_FLEX',grvr.attribute_category,'ATTRIBUTE30',grvr.rowid,grvr.attribute30) va_attribute30, null step, null operation, null operation_version, null step_quantity, null operation_yield, null material_line_type, null material_item, null minimum_transfer_quantity, null minimum_delay, null maximum_delay, null sub_organization_code, null process_loss, null pl_fixed_process_loss, null pl_fixed_process_loss_uom, null pl_contiguous, null customer, null operation_line, null activity_factor, null resource_code, null resource_usage, null usage_uom, null process_quantity, null process_uom, null minimum_capacity, null maximum_capacity, null process_parameter_1, null process_parameter_2, null process_parameter_3, null process_parameter_4, null process_parameter_5, grcv.recipe_id, grvr.recipe_validity_rule_id validity_rule_id, null routing_step_id, null formulaline_id, null recipe_process_loss_id, 2 row_type_sort from gmd_recipes_vl grcv, gmd_recipe_validity_rules grvr, mtl_parameters mp where grcv.recipe_id=grvr.recipe_id and grcv.owner_organization_id=mp.organization_id and nvl(grvr.delete_mark,0)=0 and grcv.delete_mark=0 and grcv.owner_organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and :p_upload_mode like '%'||xxen_upload.action_update union all select mp.organization_code, grcv.recipe_no recipe, grcv.recipe_version, 'Routing Step' row_type, null creation_organization_code, null recipe_description, null formula, null formula_version, null routing, null routing_version, null recipe_type, null recipe_status, null planned_process_loss, null fixed_process_loss, null fixed_process_loss_uom, null recipe_yield, null contiguous, null enhanced_process_instructions, null calculate_step_quantity, null owner, null ha_attribute_category, null ha_attribute1, null ha_attribute2, null ha_attribute3, null ha_attribute4, null ha_attribute5, null ha_attribute6, null ha_attribute7, null ha_attribute8, null ha_attribute9, null ha_attribute10, null ha_attribute11, null ha_attribute12, null ha_attribute13, null ha_attribute14, null ha_attribute15, null ha_attribute16, null ha_attribute17, null ha_attribute18, null ha_attribute19, null ha_attribute20, null ha_attribute21, null ha_attribute22, null ha_attribute23, null ha_attribute24, null ha_attribute25, null ha_attribute26, null ha_attribute27, null ha_attribute28, null ha_attribute29, null ha_attribute30, null validity_rule_use, null validity_organization_code, null product, null vr_revision, null preference, null standard_quantity, null minimum_quantity, null maximum_quantity, null vr_detail_uom, null start_date, null end_date, null vr_planned_process_loss, null vr_fixed_process_loss, null vr_fixed_process_loss_uom, null va_attribute_category, null va_attribute1, null va_attribute2, null va_attribute3, null va_attribute4, null va_attribute5, null va_attribute6, null va_attribute7, null va_attribute8, null va_attribute9, null va_attribute10, null va_attribute11, null va_attribute12, null va_attribute13, null va_attribute14, null va_attribute15, null va_attribute16, null va_attribute17, null va_attribute18, null va_attribute19, null va_attribute20, null va_attribute21, null va_attribute22, null va_attribute23, null va_attribute24, null va_attribute25, null va_attribute26, null va_attribute27, null va_attribute28, null va_attribute29, null va_attribute30, frd.routingstep_no step, (select gov.oprn_no from gmd_operations_vl gov where gov.oprn_id=frd.oprn_id) operation, (select gov.oprn_vers from gmd_operations_vl gov where gov.oprn_id=frd.oprn_id) operation_version, grrs.step_qty step_quantity, grrs.oprn_yield operation_yield, null material_line_type, null material_item, null minimum_transfer_quantity, null minimum_delay, null maximum_delay, null sub_organization_code, null process_loss, null pl_fixed_process_loss, null pl_fixed_process_loss_uom, null pl_contiguous, null customer, null operation_line, null activity_factor, null resource_code, null resource_usage, null usage_uom, null process_quantity, null process_uom, null minimum_capacity, null maximum_capacity, null process_parameter_1, null process_parameter_2, null process_parameter_3, null process_parameter_4, null process_parameter_5, grcv.recipe_id, null validity_rule_id, frd.routingstep_id routing_step_id, null formulaline_id, null recipe_process_loss_id, 3 row_type_sort from gmd_recipes_vl grcv, fm_rout_dtl frd, gmd_recipe_routing_steps grrs, mtl_parameters mp where frd.routing_id=grcv.routing_id and grrs.recipe_id(+)=grcv.recipe_id and grrs.routingstep_id(+)=frd.routingstep_id and grcv.owner_organization_id=mp.organization_id and grcv.delete_mark=0 and grcv.owner_organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and :p_upload_mode like '%'||xxen_upload.action_update union all select mp.organization_code, grcv.recipe_no recipe, grcv.recipe_version, 'Step Material' row_type, null creation_organization_code, null recipe_description, null formula, null formula_version, null routing, null routing_version, null recipe_type, null recipe_status, null planned_process_loss, null fixed_process_loss, null fixed_process_loss_uom, null recipe_yield, null contiguous, null enhanced_process_instructions, null calculate_step_quantity, null owner, null ha_attribute_category, null ha_attribute1, null ha_attribute2, null ha_attribute3, null ha_attribute4, null ha_attribute5, null ha_attribute6, null ha_attribute7, null ha_attribute8, null ha_attribute9, null ha_attribute10, null ha_attribute11, null ha_attribute12, null ha_attribute13, null ha_attribute14, null ha_attribute15, null ha_attribute16, null ha_attribute17, null ha_attribute18, null ha_attribute19, null ha_attribute20, null ha_attribute21, null ha_attribute22, null ha_attribute23, null ha_attribute24, null ha_attribute25, null ha_attribute26, null ha_attribute27, null ha_attribute28, null ha_attribute29, null ha_attribute30, null validity_rule_use, null validity_organization_code, null product, null vr_revision, null preference, null standard_quantity, null minimum_quantity, null maximum_quantity, null vr_detail_uom, null start_date, null end_date, null vr_planned_process_loss, null vr_fixed_process_loss, null vr_fixed_process_loss_uom, null va_attribute_category, null va_attribute1, null va_attribute2, null va_attribute3, null va_attribute4, null va_attribute5, null va_attribute6, null va_attribute7, null va_attribute8, null va_attribute9, null va_attribute10, null va_attribute11, null va_attribute12, null va_attribute13, null va_attribute14, null va_attribute15, null va_attribute16, null va_attribute17, null va_attribute18, null va_attribute19, null va_attribute20, null va_attribute21, null va_attribute22, null va_attribute23, null va_attribute24, null va_attribute25, null va_attribute26, null va_attribute27, null va_attribute28, null va_attribute29, null va_attribute30, (select frd.routingstep_no from fm_rout_dtl frd where frd.routingstep_id=grsm.routingstep_id) step, null operation, null operation_version, null step_quantity, null operation_yield, (select xxen_util.meaning(to_char(fmd.line_type),'GMD_FORMULA_ITEM_TYPE',552) from fm_matl_dtl fmd where fmd.formulaline_id=grsm.formulaline_id) material_line_type, (select msiv.concatenated_segments from fm_matl_dtl fmd, mtl_system_items_vl msiv where fmd.formulaline_id=grsm.formulaline_id and msiv.inventory_item_id=fmd.inventory_item_id and msiv.organization_id=fmd.organization_id) material_item, grsm.minimum_transfer_qty minimum_transfer_quantity, grsm.minimum_delay, grsm.maximum_delay, null sub_organization_code, null process_loss, null pl_fixed_process_loss, null pl_fixed_process_loss_uom, null pl_contiguous, null customer, null operation_line, null activity_factor, null resource_code, null resource_usage, null usage_uom, null process_quantity, null process_uom, null minimum_capacity, null maximum_capacity, null process_parameter_1, null process_parameter_2, null process_parameter_3, null process_parameter_4, null process_parameter_5, grcv.recipe_id, null validity_rule_id, grsm.routingstep_id routing_step_id, grsm.formulaline_id, null recipe_process_loss_id, 4 row_type_sort from gmd_recipes_vl grcv, gmd_recipe_step_materials grsm, mtl_parameters mp where grcv.recipe_id=grsm.recipe_id and grcv.owner_organization_id=mp.organization_id and grcv.delete_mark=0 and grcv.owner_organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and :p_upload_mode like '%'||xxen_upload.action_update union all select mp.organization_code, grcv.recipe_no recipe, grcv.recipe_version, 'Process Loss' row_type, null creation_organization_code, null recipe_description, null formula, null formula_version, null routing, null routing_version, null recipe_type, null recipe_status, null planned_process_loss, null fixed_process_loss, null fixed_process_loss_uom, null recipe_yield, null contiguous, null enhanced_process_instructions, null calculate_step_quantity, null owner, null ha_attribute_category, null ha_attribute1, null ha_attribute2, null ha_attribute3, null ha_attribute4, null ha_attribute5, null ha_attribute6, null ha_attribute7, null ha_attribute8, null ha_attribute9, null ha_attribute10, null ha_attribute11, null ha_attribute12, null ha_attribute13, null ha_attribute14, null ha_attribute15, null ha_attribute16, null ha_attribute17, null ha_attribute18, null ha_attribute19, null ha_attribute20, null ha_attribute21, null ha_attribute22, null ha_attribute23, null ha_attribute24, null ha_attribute25, null ha_attribute26, null ha_attribute27, null ha_attribute28, null ha_attribute29, null ha_attribute30, null validity_rule_use, null validity_organization_code, null product, null vr_revision, null preference, null standard_quantity, null minimum_quantity, null maximum_quantity, null vr_detail_uom, null start_date, null end_date, null vr_planned_process_loss, null vr_fixed_process_loss, null vr_fixed_process_loss_uom, null va_attribute_category, null va_attribute1, null va_attribute2, null va_attribute3, null va_attribute4, null va_attribute5, null va_attribute6, null va_attribute7, null va_attribute8, null va_attribute9, null va_attribute10, null va_attribute11, null va_attribute12, null va_attribute13, null va_attribute14, null va_attribute15, null va_attribute16, null va_attribute17, null va_attribute18, null va_attribute19, null va_attribute20, null va_attribute21, null va_attribute22, null va_attribute23, null va_attribute24, null va_attribute25, null va_attribute26, null va_attribute27, null va_attribute28, null va_attribute29, null va_attribute30, null step, null operation, null operation_version, null step_quantity, null operation_yield, null material_line_type, null material_item, null minimum_transfer_quantity, null minimum_delay, null maximum_delay, grpl.orgn_code sub_organization_code, grpl.process_loss, grpl.fixed_process_loss pl_fixed_process_loss, grpl.fixed_process_loss_uom pl_fixed_process_loss_uom, xxen_util.meaning(decode(grpl.contiguous_ind,1,'Y','N'),'YES_NO',0) pl_contiguous, null customer, null operation_line, null activity_factor, null resource_code, null resource_usage, null usage_uom, null process_quantity, null process_uom, null minimum_capacity, null maximum_capacity, null process_parameter_1, null process_parameter_2, null process_parameter_3, null process_parameter_4, null process_parameter_5, grcv.recipe_id, null validity_rule_id, null routing_step_id, null formulaline_id, grpl.recipe_process_loss_id, 5 row_type_sort from gmd_recipes_vl grcv, gmd_recipe_process_loss grpl, mtl_parameters mp where grcv.recipe_id=grpl.recipe_id and grcv.owner_organization_id=mp.organization_id and grcv.delete_mark=0 and grcv.owner_organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and :p_upload_mode like '%'||xxen_upload.action_update union all select mp.organization_code, grcv.recipe_no recipe, grcv.recipe_version, 'Customer' row_type, null creation_organization_code, null recipe_description, null formula, null formula_version, null routing, null routing_version, null recipe_type, null recipe_status, null planned_process_loss, null fixed_process_loss, null fixed_process_loss_uom, null recipe_yield, null contiguous, null enhanced_process_instructions, null calculate_step_quantity, null owner, null ha_attribute_category, null ha_attribute1, null ha_attribute2, null ha_attribute3, null ha_attribute4, null ha_attribute5, null ha_attribute6, null ha_attribute7, null ha_attribute8, null ha_attribute9, null ha_attribute10, null ha_attribute11, null ha_attribute12, null ha_attribute13, null ha_attribute14, null ha_attribute15, null ha_attribute16, null ha_attribute17, null ha_attribute18, null ha_attribute19, null ha_attribute20, null ha_attribute21, null ha_attribute22, null ha_attribute23, null ha_attribute24, null ha_attribute25, null ha_attribute26, null ha_attribute27, null ha_attribute28, null ha_attribute29, null ha_attribute30, null validity_rule_use, null validity_organization_code, null product, null vr_revision, null preference, null standard_quantity, null minimum_quantity, null maximum_quantity, null vr_detail_uom, null start_date, null end_date, null vr_planned_process_loss, null vr_fixed_process_loss, null vr_fixed_process_loss_uom, null va_attribute_category, null va_attribute1, null va_attribute2, null va_attribute3, null va_attribute4, null va_attribute5, null va_attribute6, null va_attribute7, null va_attribute8, null va_attribute9, null va_attribute10, null va_attribute11, null va_attribute12, null va_attribute13, null va_attribute14, null va_attribute15, null va_attribute16, null va_attribute17, null va_attribute18, null va_attribute19, null va_attribute20, null va_attribute21, null va_attribute22, null va_attribute23, null va_attribute24, null va_attribute25, null va_attribute26, null va_attribute27, null va_attribute28, null va_attribute29, null va_attribute30, null step, null operation, null operation_version, null step_quantity, null operation_yield, null material_line_type, null material_item, null minimum_transfer_quantity, null minimum_delay, null maximum_delay, null sub_organization_code, null process_loss, null pl_fixed_process_loss, null pl_fixed_process_loss_uom, null pl_contiguous, (select hca_c.account_number from hz_cust_accounts hca_c where hca_c.cust_account_id=grc.customer_id) customer, null operation_line, null activity_factor, null resource_code, null resource_usage, null usage_uom, null process_quantity, null process_uom, null minimum_capacity, null maximum_capacity, null process_parameter_1, null process_parameter_2, null process_parameter_3, null process_parameter_4, null process_parameter_5, grcv.recipe_id, null validity_rule_id, null routing_step_id, null formulaline_id, null recipe_process_loss_id, 6 row_type_sort from gmd_recipes_vl grcv, gmd_recipe_customers grc, mtl_parameters mp where grcv.recipe_id=grc.recipe_id and grcv.owner_organization_id=mp.organization_id and grcv.delete_mark=0 and grcv.owner_organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and :p_upload_mode like '%'||xxen_upload.action_update union all select mp.organization_code, grcv.recipe_no recipe, grcv.recipe_version, 'Org Operation' row_type, null creation_organization_code, null recipe_description, null formula, null formula_version, null routing, null routing_version, null recipe_type, null recipe_status, null planned_process_loss, null fixed_process_loss, null fixed_process_loss_uom, null recipe_yield, null contiguous, null enhanced_process_instructions, null calculate_step_quantity, null owner, null ha_attribute_category, null ha_attribute1, null ha_attribute2, null ha_attribute3, null ha_attribute4, null ha_attribute5, null ha_attribute6, null ha_attribute7, null ha_attribute8, null ha_attribute9, null ha_attribute10, null ha_attribute11, null ha_attribute12, null ha_attribute13, null ha_attribute14, null ha_attribute15, null ha_attribute16, null ha_attribute17, null ha_attribute18, null ha_attribute19, null ha_attribute20, null ha_attribute21, null ha_attribute22, null ha_attribute23, null ha_attribute24, null ha_attribute25, null ha_attribute26, null ha_attribute27, null ha_attribute28, null ha_attribute29, null ha_attribute30, null validity_rule_use, null validity_organization_code, null product, null vr_revision, null preference, null standard_quantity, null minimum_quantity, null maximum_quantity, null vr_detail_uom, null start_date, null end_date, null vr_planned_process_loss, null vr_fixed_process_loss, null vr_fixed_process_loss_uom, null va_attribute_category, null va_attribute1, null va_attribute2, null va_attribute3, null va_attribute4, null va_attribute5, null va_attribute6, null va_attribute7, null va_attribute8, null va_attribute9, null va_attribute10, null va_attribute11, null va_attribute12, null va_attribute13, null va_attribute14, null va_attribute15, null va_attribute16, null va_attribute17, null va_attribute18, null va_attribute19, null va_attribute20, null va_attribute21, null va_attribute22, null va_attribute23, null va_attribute24, null va_attribute25, null va_attribute26, null va_attribute27, null va_attribute28, null va_attribute29, null va_attribute30, frd.routingstep_no step, null operation, null operation_version, null step_quantity, null operation_yield, null material_line_type, null material_item, null minimum_transfer_quantity, null minimum_delay, null maximum_delay, groa.orgn_code sub_organization_code, null process_loss, null pl_fixed_process_loss, null pl_fixed_process_loss_uom, null pl_contiguous, null customer, goa.activity operation_line, groa.activity_factor, null resource_code, null resource_usage, null usage_uom, null process_quantity, null process_uom, null minimum_capacity, null maximum_capacity, null process_parameter_1, null process_parameter_2, null process_parameter_3, null process_parameter_4, null process_parameter_5, grcv.recipe_id, null validity_rule_id, null routing_step_id, null formulaline_id, null recipe_process_loss_id, 7 row_type_sort from gmd_recipes_vl grcv, gmd_recipe_orgn_activities groa, fm_rout_dtl frd, gmd_operation_activities goa, mtl_parameters mp where grcv.recipe_id=groa.recipe_id and groa.routingstep_id=frd.routingstep_id(+) and groa.oprn_line_id=goa.oprn_line_id(+) and grcv.owner_organization_id=mp.organization_id and grcv.delete_mark=0 and grcv.owner_organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and :p_upload_mode like '%'||xxen_upload.action_update union all select mp.organization_code, grcv.recipe_no recipe, grcv.recipe_version, 'Org Resource' row_type, null creation_organization_code, null recipe_description, null formula, null formula_version, null routing, null routing_version, null recipe_type, null recipe_status, null planned_process_loss, null fixed_process_loss, null fixed_process_loss_uom, null recipe_yield, null contiguous, null enhanced_process_instructions, null calculate_step_quantity, null owner, null ha_attribute_category, null ha_attribute1, null ha_attribute2, null ha_attribute3, null ha_attribute4, null ha_attribute5, null ha_attribute6, null ha_attribute7, null ha_attribute8, null ha_attribute9, null ha_attribute10, null ha_attribute11, null ha_attribute12, null ha_attribute13, null ha_attribute14, null ha_attribute15, null ha_attribute16, null ha_attribute17, null ha_attribute18, null ha_attribute19, null ha_attribute20, null ha_attribute21, null ha_attribute22, null ha_attribute23, null ha_attribute24, null ha_attribute25, null ha_attribute26, null ha_attribute27, null ha_attribute28, null ha_attribute29, null ha_attribute30, null validity_rule_use, null validity_organization_code, null product, null vr_revision, null preference, null standard_quantity, null minimum_quantity, null maximum_quantity, null vr_detail_uom, null start_date, null end_date, null vr_planned_process_loss, null vr_fixed_process_loss, null vr_fixed_process_loss_uom, null va_attribute_category, null va_attribute1, null va_attribute2, null va_attribute3, null va_attribute4, null va_attribute5, null va_attribute6, null va_attribute7, null va_attribute8, null va_attribute9, null va_attribute10, null va_attribute11, null va_attribute12, null va_attribute13, null va_attribute14, null va_attribute15, null va_attribute16, null va_attribute17, null va_attribute18, null va_attribute19, null va_attribute20, null va_attribute21, null va_attribute22, null va_attribute23, null va_attribute24, null va_attribute25, null va_attribute26, null va_attribute27, null va_attribute28, null va_attribute29, null va_attribute30, frd.routingstep_no step, null operation, null operation_version, null step_quantity, null operation_yield, null material_line_type, null material_item, null minimum_transfer_quantity, null minimum_delay, null maximum_delay, gror.orgn_code sub_organization_code, null process_loss, null pl_fixed_process_loss, null pl_fixed_process_loss_uom, null pl_contiguous, null customer, goa.activity operation_line, null activity_factor, gror.resources resource_code, gror.resource_usage, gror.usage_uom, gror.process_qty process_quantity, gror.process_um process_uom, gror.min_capacity minimum_capacity, gror.max_capacity maximum_capacity, gror.process_parameter_1, gror.process_parameter_2, gror.process_parameter_3, gror.process_parameter_4, gror.process_parameter_5, grcv.recipe_id, null validity_rule_id, null routing_step_id, null formulaline_id, null recipe_process_loss_id, 8 row_type_sort from gmd_recipes_vl grcv, gmd_recipe_orgn_resources gror, fm_rout_dtl frd, gmd_operation_activities goa, mtl_parameters mp where grcv.recipe_id=gror.recipe_id and gror.routingstep_id=frd.routingstep_id(+) and gror.oprn_line_id=goa.oprn_line_id(+) and grcv.owner_organization_id=mp.organization_id and grcv.delete_mark=0 and grcv.owner_organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and :p_upload_mode like '%'||xxen_upload.action_update ) x where 1=1 |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Upload Mode |
| LOV | |
| Organization Code |
| LOV | |
| Recipe |
| Char |