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 […]
In R12, you can launch three type of plans: Production Plan Manufacturing Plan Master Plan For MPS Planning item level, you should run Production PlanAnd for MRP Planning Item, you should run Manufacturing plan.Please see the explanation from Dev in similar question from other customers in Oracle Technical forum:“The below are the 3 plan types […]
Batch Close Variances can occur in the following situations when using Actual Costing, If the batch was released in one cost period and the debit to WIP is valued at one cost, but the batch was completed in a later cost period when the credit to WIP for the same quantities is valued at a […]
Requirement: change the Executable field into uppercase within the Concurrent Program Executable screen Follow these steps to make the Executable field uppercase using CUSTOM.pll: 1. Enable show custom events: Log in to the Application Developer responsibility and enable Show Custom Events. Check the blog post for enabling custom events: Custom events can be enabled through the below navigation: Once you enable show custom […]
SELECT mso.sales_order_number, md1.*,MSI1.ITEM_NAME||’ (‘||MSI1.INVENTORY_ITEM_ID||’)’ “COMPONENT (ID)”, substr( md1.order_number,1,22) order_num, MS1.NEW_ORDER_QUANTITY COMP_QTY — this is the pegged or previously pegged column, decode (ms1.order_type,’1′,’Purchase order’,’11’,’Intransit shipment’,’12’,’Intransit receipt’,’13’,’Suggested repetitive schedule’,’14’,’Discrete job co-product/by-product’,’15’,’Nonstandard job by-product’,’16’,’Repetitive schedule by-product’,’17’,’Planned order co-product/by-product’,’18’,’On Hand’,’2′,’Purchase requisition’,’27’,’Flow schedule’,’28’,’Flow schedule by-product’,’29’,’Payback Supply’,’3′,’Discrete job’,’30’,’Current repetitive schedule’,’32’,’Returns’,’4′,’Suggested aggregate repetitive schedule’,’41’,’User Supply’,’45’,’Demand Class Consumption’,’46’,’Supply Due To Stealing’,’47’,’Demand Due To […]
Recent Comments