Entries by Oracle ERP Apps Guide

, , , , ,

Important OPM Process Execution & Inventory Tables in R12

OPM PROCESS EXECUTION TABLES R12 GME_BATCH_HEADER GME_BATCH_HEADER_MIG GME_BATCH_HISTORY GME_BATCH_MAPPING_MIG GME_BATCH_SALES_ORDERS GME_BATCH_STEPS GME_BATCH_STEPS_MIG GME_BATCH_STEP_ACTIVITIES GME_BATCH_STEP_ACTIV_MIG GME_BATCH_STEP_CHARGES GME_BATCH_STEP_CHARGES_MIG GME_BATCH_STEP_DEPENDENCIES GME_BATCH_STEP_DEP_MIG GME_BATCH_STEP_ITEMS GME_BATCH_STEP_ITEMS_MIG GME_BATCH_STEP_RESOURCES GME_BATCH_STEP_RESOURCES_MIG GME_BATCH_STEP_RSRC_SUMMARY GME_BATCH_STEP_TRANSFERS GME_BATCH_STEP_TRANSFERS_MIG GME_BATCH_TXNS_MIG GME_ERES_GTMP GME_EXCEPTIONS_GTMP GME_GANTT_DOCUMENT_FILTER GME_INVENTORY_TXNS_GTMP GME_LAB_BATCH_LOTS GME_MATERIAL_DETAILS GME_MATERIAL_DETAILS_MIG GME_MATERIAL_DISPENSING_GTMP GME_MIGRATION_CONTROL GME_PARAMETERS GME_PENDING_PRODUCT_LOTS GME_PROCESS_PARAMETERS GME_PROCESS_PARAMETERS_MIG GME_RESOURCE_TXNS GME_RESOURCE_TXNS_GTMP GME_RESOURCE_TXNS_MIG GME_RESOURCE_TXNS_SUMMARY GME_SCALE_DETAIL GME_TEMP_EXCEPTIONS GME_TEXT_HEADER GME_TEXT__TL GME_TRANSACTION_PAIRS GME_UNALLOCATED_ITEMS_GTMP OPM INVENTORY TABLE R12 BISOPM_ONHANDSALE_SUM BIS_OPM_PROD_SUM […]

, , , , , ,

How to Stop/Block Work Flow Mailer Send Mail from the Cloned Instance

YOur Work Flow mailer is triggering Mail often when you clone your Instance and you are unable to test the New stuff using work Flow Mailer Here is the solution for the Work flow mailer to stop sending older mails in the Test Instance UPDATE WF_NOTIFICATIONS SET STATUS = ‘CLOSED’ where status =’OPEN’; UPDATE WF_NOTIFICATIONS SET MAIL_STATUS = ‘SENT’ where […]

, , , ,

Oracle Back to Back Order in Order Management

Back Orders ·         The Oracle “term” backorder is a “status” on the order line or delivery line indicating that you have tried to release an order for picking in your warehouse, but that the pick release was UNSUCCESSFUL because there was no available inventory.(Backorder can be partial or complete). The Oracle term backorder does NOT mean that you […]