How to create RMA in Oracle Order Management:I am taking the case of creation of Return Sales Order with Receipt and Credit Memo.1.Create New Sales Order with Order Type = “Return Only . ( we can take Mixed or any other that allow return line)2.Since Header Order Type is “Return Only”, based on the transaction […]
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 […]
Recent Comments