R12 OPM Why is Negative Value to Batch Layer Cost Component? (Doc ID 2161945.1)

Last updated on JANUARY 01, 2024

Applies to:

Goal

Why negative value to batch layer cost component in gmf_layer_cost_details under actual cost type?

SELECT *
FROM gmf_layer_cost_details c
WHERE
c.layer_id IN
(SELECT il.layer_id
FROM gme_batch_header h, mtl_material_transactions t, gmf_incoming_material_layers il
WHERE h.batch_id = &&batch_id
AND h.batch_id = t.transaction_source_id
AND t.transaction_source_type_id = 5
AND il.mmt_transaction_id = t.transaction_id
AND il.mmt_organization_id = t.organization_id
);

Solution

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