This Post is about Oracle applications RFQ to Receipt Cycle.In this Post I will explain the Cycle from RFQ to PO Receipt with screen shots. High -Lights of this Cycle is to Create: RFQ Quote Purchase Order Receive against PO. Once RFQ is created , Submit concurrent job “Request to Print the RFQ” for a supplier. […]
Script 1:(Works in Both 11i & R12) SELECT gcc.segment1 ||’.’ ||gcc.segment2 ||’.’ ||gcc.segment3 ACCOUNT, A1.DESCRIPTION ||’-‘ ||A2.DESCRIPTION ||’-‘ || A3.DESCRIPTION DECS FROM fnd_flex_values_vl A1, fnd_flex_values_vl A2, fnd_flex_values_vl A3, gl_code_combinations gcc WHERE a1.flex_value =gcc.segment1 AND a1.FLEX_VALUE_SET_ID IN (SELECT FLEX_VALUE_SET_ID FROM fnd_id_flex_segments WHERE application_id = 101 AND id_flex_code […]
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 […]
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 […]
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 […]
Recent Comments