tag:blogger.com,1999:blog-35382209234569464402024-02-20T17:03:06.701-08:00Order ManagementiBizSofthttp://www.blogger.com/profile/11168350594962689642noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-3538220923456946440.post-2035269805404574902010-12-20T03:22:00.000-08:002010-12-20T03:23:21.642-08:00Credit Card Order ManagementIn this post I will explain in detail about the new changes that Oracle made in R12 about handling of the credit card transaction. Oracle has made significant changes in R12 about handling of Credit Card Transaction. <br /><br /> To begin with now in R12 Order Management “Credit Card Type “ will be refer as “Card Brand”, also we need to enable OM profile OM: Credit Card Privileges, in order to enter credit card information in Sales Order and Payments form.<br /><br /> With R12 onwards OM will not store any of the Credit card/Bank Account related Information in it’s tables, all the credit and Bank related information will be encrypted and stored in a centralized system (i.e. Payments). This would give enhanced security and control over such critical information.<br /><br />Order Management has to link to these table to retrieve the related information. <br /><br />NOTE – we can still see the Credit Card related fields in OE_ORDER_HEADERS_ALL in R12, but OM don’t store any of the credit card information in these tables and these are their for Backward compatibility.In orders to protect their customer from Credit frauds (mostly when Credit Card is not Physically Present (Online/Over the Phone) credit card companies has provide the security code to enhance the security. In R12 Order management, Oracle has provide the field to capture the Security Code for the Credit card, value in this field will not be store any where in the system. <br /><br />Security Code – It is 3 or 4 digit code provide by credit card companies, and we call it CCV/CCV2 <br /><br />As shown below, I have define the Security Code Setup as mandatory in Payments and also in the Masking Rules I have set “Display only last 4 Digits”<br /><br /><br /><br />Once the Security Code set as mandatory, OM UI’s will mark the security Code filed as required field. But if it is not defined as mandatory in Payment Module, It remains options in Order Management.<br /><br /><br /><br />Below are examples of the Billing Address is define as mandatory in Payments and user try to process the Orders without providing Billing details.<br /><br /><br /><br /><br /><br /> <br /><br />Security Code mandatory setup<br />Security Code is not a mandatory field, depending on your requirement you can make it required or option from the Payment Setup, flexibility to make it required or optional is one the best feature in this Area.<br /><br /> Copy Orders with Security Code Set as Mandatory<br /><br />In R12, if the security Code is set as mandatory in Payments module and user try to Copy a Sales order which as credit card information, System will prompt user to uncheck “Copy payment” information and proceed.<br /><br /> Authorization Hold<br /><br />Please make a note that Security Code is masked completely once we save the Sales order and ALSO SECURITY CODE is cleared from the UI, once Credit card is Authorized.This some time leads to issue of Order line being put on “Authorization Hold”. <br /><br />Let me explain it in details, as I have explained that security code will be cleared from the line record as soon as authorization is done. Now if user tries to Reauthorize the card , at the point of time, the security code value is null (authorization process clears the security code value and it is not stored in the system). Since it is an essential attribute for authorization, reauthorization attempt would first put the transaction on CC Auth Hold. The user can then provide the security Code value and proceed with reauthorizationiBizSofthttp://www.blogger.com/profile/11168350594962689642noreply@blogger.com1tag:blogger.com,1999:blog-3538220923456946440.post-4763602399198142652010-12-20T03:21:00.001-08:002010-12-20T03:21:57.962-08:00Item OrderabilityItem Orderability - This is new feature introduced in Oracle R12.1.1.This is rule that user can define to restrict the items that can be ordered from the Sales Order form.<br /><br /> Because of the complex business scenario in the Modern time organization want to control which customer are allowed to order which product.<br /><br /><br /> Now Order management Provide a new UI in R12.1.1 to define the rule to restrict the Item order, this UI is name as Item Orderability Rules.<br /><br />It allow user to Order the Item to customer based on the Rules.<br /><br />As of Now Oracle has provided rules to control only the 11 attributes - like you can ally the restriction based on<br /><br />Customer<br /><br />Customer class<br /><br />Order types,<br /><br />Customer category etc.<br /><br /> <br /><br />Below is Simple Flow<br /><br />1. Define the Rules<br /><br />2. Order the Item through UI/Order Import/Process Order API.<br /><br /> <br /><br />Below is Simple test case for Item Orderability feature. <br /><br />Define the Item Orderability -<br /><br />Define the Rules by selecting any of 11 attributes<br /><br />Define the Criteria – Item or Category.<br /><br />Define the Rule.<br /><br /> <br /><br />For Example – I want to define the Rule that Item AS54888 should not be Ordered for an Order with Item Type = Mixed.<br /><br />For that I selected the<br /><br />Criteria = Item<br /><br />Rule level = Order Type<br /><br />Rule Value = Mixed.<br /><br /> <br /><br />Please make sure that Enabled Flag = Yes for your Rule.<br /><br /><br /><br /><br /><br /> Once Rule is defined ,Entered Sales Order .<br /><br />Customer ID = 1006<br /><br />Order Type = Mixed<br /><br />Item = AS54888<br /><br /> <br /><br />Try to save Order, System will Throw Error , because of the Item Order ability Rule as shown below.iBizSofthttp://www.blogger.com/profile/11168350594962689642noreply@blogger.com0tag:blogger.com,1999:blog-3538220923456946440.post-59436761052590887772010-12-20T03:19:00.000-08:002010-12-20T03:20:20.571-08:00Purge Shipping ExecutionIn R12 E-business Suite Oracle has introduced another new feature to Purge Shipping Execution data.<br /><br />In this Post I will explain the various feature offered in Oracle Shipping.<br /> <br />Shipping Purge allow us to purge Shipping data for<br />• Delivery<br />• Trip<br />• Delivery Lines<br />• LPN<br /><br />For purge, Oracle in R12 (e-business suite) has added a new concurrent program “Shipping Purge”, It has lot of parameters and allow you to purge shipping data based on parameters.<br />Some of parameters are<br />• Organization<br />• Sales Order From and To<br />• Ship Date From and To<br />• Purge “in Transit Stop”<br />• Creation Data From and To<br />• Beyond x days etc<br /> <br />Oracle e-business suite has offered this Concurrent program in 2 modes.<br />• View Purge Selection<br />• Purge<br /> <br />View Purge Selection - If concurrent program executed in this model it will not delete any data, it rather print the data that is selected for purge , so that user can verify the data<br /> <br />Purge - If concurrent program executed in this model it will Purge the selected data.<br /> <br />Purge featured offered in R12 make sure about the data Integrity and will not purge any data that result in orphan’s records in other modules. It ensure that<br /> <br />1. Purge process purges complete set of records , e.g if you want to purge the trip and that trip is 5 deliveries , 4 are closed but 1 is still open then system will not let you purge the trip data.<br />2. It also validate the other Integrated modules before purging data, eg before purging delivery /delivery details/Trip it check the Order management data and make sure that order lines related to shipping data are not exists, same is the case with warehouse management data. If any such validation/restriction fails, Shipping will not purge data.<br /> <br />This is great feature offered in R12, as it help user to purge the Not required Shipping data and Save disk Space.iBizSofthttp://www.blogger.com/profile/11168350594962689642noreply@blogger.com0tag:blogger.com,1999:blog-3538220923456946440.post-13340144619694236982010-12-20T03:10:00.000-08:002010-12-20T03:11:14.577-08:00EBS Order ManagementHow a Sales Order Basic processes/stages set up is done in Order Management is explained in this<br /><br />ebs_order_to_invoice.pdfiBizSofthttp://www.blogger.com/profile/11168350594962689642noreply@blogger.com0tag:blogger.com,1999:blog-3538220923456946440.post-17663295002017739232010-12-19T22:20:00.000-08:002010-12-19T22:21:13.451-08:00Workflow WSH<span class="Apple-style-span" style="border-collapse: separate; color: rgb(255, 255, 255); font-family: 'Times New Roman'; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; font-size: medium;"><span class="Apple-style-span" style="font-family: 'Lucida Grande',Verdana,Arial,sans-serif; font-size: 12px; line-height: 16px; text-align: justify;"><p style="font-size: 1.05em;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Oracle has offered many new features in R12.In this post I will talk about the Introduction of the workflow in Oracle Application Shipping Module offered in R12.</span><span style="font-family: Arial,sans-serif; font-size: 10pt;"> </span><span style="font-family: Arial,sans-serif; font-size: 10pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">In R12 Oracle Shipping (WSH) is utilizing the workflow, with the introduction of the workflow now user can</span></span></p><ul style="margin-left: 0px; padding: 0px 0px 0px 10px; list-style-type: none; text-indent: -10px; margin-top: 0in;" type="disc"><li class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Automate the Shipping business process by adding them in the Shipping workflow.</span></li><li class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Routing based on the business rules.<span id="more-647"></span></span></li><li class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Send the Notification to user about some Important event, e.g sending notification about</span><ul style="margin-left: 0px; padding: 0px 0px 0px 10px; list-style-type: none; text-indent: -10px; margin-top: 0in;" type="circle"><li class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Backorder delivery</span></li><li class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Dollar Amount or Volume in Delivery etc</span></li></ul></li><li class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Best of all now with workflow user can visualize the Shipping process, by means of workflow monitor and thus improve our visibility.</span></li><li class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Integration with the 3<sup>rd</sup><span class="Apple-converted-space"> </span>party APIs will be easy , we can just add them where every they requited by customizing the workflow.</span></li><li class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">In case we want to Print the documents at some point in the shipping flow, just add the Print document activity in the flow and it will get printed when workflow reaches to that activity.</span></li></ul><p style="font-size: 1.05em;"><span style="font-family: Arial,sans-serif; font-size: 10pt;"></span><span style="font-family: Arial,sans-serif; font-size: 10pt;"></span><span style="font-family: Arial,sans-serif; font-size: 10pt;"></span><span style="font-family: Arial,sans-serif; font-size: 10pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">In R12 Oracle has offered workflow for</span></span></p><ul style="margin-left: 0px; padding: 0px 0px 0px 10px; list-style-type: none; text-indent: -10px; margin-top: 0in;" type="disc"><li class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Delivery</span></li><li class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Trip</span></li><li class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Ship Confirm Process</span></li></ul><p style="font-size: 1.05em;"><span style="font-family: Arial,sans-serif; font-size: 10pt;"></span><span style="font-family: Arial,sans-serif; font-size: 10pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">These workflow shows the High-level overview of the delivery and Trip process and can be accessible from the</span></span></p><ul style="margin-left: 0px; padding: 0px 0px 0px 10px; list-style-type: none; text-indent: -10px; margin-top: 0in;" type="disc"><li class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Shipping Transaction Form</span></li><li class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Quick ship user Interface.</span></li></ul><p style="font-size: 1.05em;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Other advantages of the workflow are that we can access the History of the workflow events and all the workflow events /activities got captured in the History table and thus Audit – Trail will ne easy.</span><span style="font-family: Arial,sans-serif; font-size: 10pt;"> </span><span style="font-family: Arial,sans-serif; font-size: 10pt;"><span class="Apple-converted-space"> </span></span><span style="font-family: Arial,sans-serif; font-size: 10pt;">Another Advantage that we always expect from the Oracle Corp. is this workflow is optional, if our business need them enable them other wise keep them disable. With out Workflow your application behaves just like the previous releases.</span><span style="font-family: Arial,sans-serif; font-size: 10pt;">This make it Pick and User process, Pick the process /events that we want to use in our business and enable them</span><span style="font-family: Arial,sans-serif; font-size: 10pt;"> </span><span style="font-family: Arial,sans-serif; font-size: 10pt;"><strong><span style="font-family: Arial,sans-serif; font-size: 10pt;">Limitations<span> <span class="Apple-converted-space"> </span></span>-<span class="Apple-converted-space"> </span></span></strong><span style="font-family: Arial,sans-serif; font-size: 10pt;">Some of the limitation of shipping workflow as of now are –<span class="Apple-converted-space"> </span></span><span style="font-family: Arial,sans-serif; font-size: 10pt;">As of now this workflow is subject to limited extensions</span></span></p><ul style="margin-left: 0px; padding: 0px 0px 0px 10px; list-style-type: none; text-indent: -10px; margin-top: 0in;" type="disc"><li class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">You can’t add an activity in this workflow that required response from user. For example, you can inform your manager /user about the status etc of delivery /trip by notification, but response for the notification as of now not supported.</span></li><li class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Also extension of a workflow Defer activity not supported in this workflow.</span></li><li class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">These workflows are available for Individual delivery and not for the consolidated delivery.</span></li></ul><p style="font-size: 1.05em;"><span style="font-family: Arial,sans-serif; font-size: 10pt;"></span><span style="font-family: Arial,sans-serif; font-size: 10pt;"><strong><span style="font-family: Arial,sans-serif; font-size: 10pt;">Purging<span> <span class="Apple-converted-space"> </span></span>-<span class="Apple-converted-space"> </span></span></strong><span style="font-family: Arial,sans-serif; font-size: 10pt;">Oracle has provide program to purge the Obsolete workflows, also Shipping has it’s own program to purge workflow that are obsolete or delivery is already closed.</span><span style="font-family: Arial,sans-serif; font-size: 10pt;"> </span></span></p><h1 style="font-family: 'Trebuchet MS','Lucida Grande',Verdana,Arial,sans-serif; font-weight: bold; font-size: 4em; text-align: center; text-decoration: none; padding-top: 70px; margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Delivery Workflow</span></h1><p style="font-size: 1.05em;"><strong><span style="font-family: Arial,sans-serif; font-size: 10pt;"></span></strong><strong><span style="font-family: Arial,sans-serif; font-size: 10pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Delivery Workflow has following Activities –<span class="Apple-converted-space"> </span></span><span style="font-family: Arial,sans-serif; font-size: 10pt;">Start<span class="Apple-converted-space"> </span></span><span style="font-family: Arial,sans-serif; font-size: 10pt;">Pick Initiated</span><span style="font-family: Arial,sans-serif; font-size: 10pt;">Ship-To-Delivery (Sub process for Ship Conform).</span></span></strong></p><p class="MsoNormal" style="font-size: 1.05em; margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">End.</span></p><p style="font-size: 1.05em;"><span style="font-family: Arial,sans-serif; font-size: 10pt;"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/03/wf-wsh1.GIF" title="wf-wsh1.GIF" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/03/wf-wsh1.thumbnail.GIF" alt="wf-wsh1.GIF" style="padding: 0px; max-width: 100%; border-style: none;" /></a></span><span style="font-family: Arial,sans-serif; font-size: 10pt;"></span><span style="font-family: Arial,sans-serif; font-size: 10pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Please Note that Shipping workflow as of now available for outbound activities<span class="Apple-converted-space"> </span></span><span style="font-family: Arial,sans-serif; font-size: 10pt;"> </span></span><span style="font-family: Arial,sans-serif; font-size: 10pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;"></span></span></span><span style="font-family: Arial,sans-serif; font-size: 10pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;"></span></span></p><h1 style="font-family: 'Trebuchet MS','Lucida Grande',Verdana,Arial,sans-serif; font-weight: bold; font-size: 4em; text-align: center; text-decoration: none; padding-top: 70px; margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Delivery Workflow Triggering Events</span></h1><ol style="padding: 0px 0px 0px 35px; margin: 0in 0px 0px;" type="1"><li class="MsoNormal" style="list-style-type: decimal; list-style-position: outside; margin: 0in 0in 0pt; padding: 0px;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">This workflow will triggered as soon as an order line required picking is assign to a delivery.</span></li><li class="MsoNormal" style="list-style-type: decimal; list-style-position: outside; margin: 0in 0in 0pt; padding: 0px;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">When we initiated the pick release process with Auto Created Delivery = Y.</span></li></ol><p style="font-size: 1.05em;"><span style="font-family: Arial,sans-serif; font-size: 10pt;"></span></p><h1 style="font-family: 'Trebuchet MS','Lucida Grande',Verdana,Arial,sans-serif; font-weight: bold; font-size: 4em; text-align: center; text-decoration: none; padding-top: 70px; margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Trip Workflow</span></h1><p style="font-size: 1.05em;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">It has following activities</span><span style="font-family: Arial,sans-serif; font-size: 10pt;">Open</span><span style="font-family: Arial,sans-serif; font-size: 10pt;">Set in Transit<span class="Apple-converted-space"> </span></span><span style="font-family: Arial,sans-serif; font-size: 10pt;">Close</span></p><p class="MsoNormal" style="font-size: 1.05em; margin: 0in 0in 0pt;" align="center"> <a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/03/wf-wsh2.GIF" title="wf-wsh2.GIF" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/03/wf-wsh2.thumbnail.GIF" alt="wf-wsh2.GIF" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">If a Trip has multiple stops, then Initial and finial stop will taken into consideration.</span><span style="font-family: Arial,sans-serif; font-size: 10pt;"> </span><span style="font-family: Arial,sans-serif; font-size: 10pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Please Note that Order line and Shipping workflow are 2 different things and not related to each other and it is not possible to drill down one flow from another.</span><span style="font-family: Arial,sans-serif; font-size: 10pt;"> </span></span></p><h1 style="font-family: 'Trebuchet MS','Lucida Grande',Verdana,Arial,sans-serif; font-weight: bold; font-size: 4em; text-align: center; text-decoration: none; padding-top: 70px; margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Line Flow –</span></h1><p style="font-size: 1.05em;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">It started as soon as you save the line, and it then go throw</span><span style="font-family: Arial,sans-serif; font-size: 10pt;">Booking</span><span style="font-family: Arial,sans-serif; font-size: 10pt;">Scheduling</span><span style="font-family: Arial,sans-serif; font-size: 10pt;">Ship Line Manual Process<span class="Apple-converted-space"> </span></span><span style="font-family: Arial,sans-serif; font-size: 10pt;">After then data from OM got interfaced to Shipping, Order line mark as status ‘Awaiting Shipping’ and workflow for line will be at SHIP_LINE Notified status, and remain here till the Ship Confirms activity executed.</span><span style="font-family: Arial,sans-serif; font-size: 10pt;"> </span></p><h1 style="font-family: 'Trebuchet MS','Lucida Grande',Verdana,Arial,sans-serif; font-weight: bold; font-size: 4em; text-align: center; text-decoration: none; padding-top: 70px; margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Shipping Workflow –</span></h1><p style="font-size: 1.05em;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">It got triggered when a Delivery got created and First delivery assigned to it. Shipping workflow then triggered the Ship Confirm Sub process and executes the OM Interfaced and Inventory Interface. Once Delivery closed shipping workflow comes to end (Line flow then progress further from SHIP_LINE activity).</span><span style="font-family: Arial,sans-serif; font-size: 10pt;"> </span></p><h1 style="font-family: 'Trebuchet MS','Lucida Grande',Verdana,Arial,sans-serif; font-weight: bold; font-size: 4em; text-align: center; text-decoration: none; padding-top: 70px; margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Ship To Delivery Workflow<span> <span class="Apple-converted-space"> </span></span>-</span></h1><p style="font-size: 1.05em;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">This workflow models the Ship Confirm Process, one of advantages of Ship Confirm workflow Process is, it supports extensions that included</span></p><ul style="margin-left: 0px; padding: 0px 0px 0px 10px; list-style-type: none; text-indent: -10px; margin-top: 0in;" type="disc"><li class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">You can add an activity where you are expecting the response, e.g Response base notification. Let’s say as per business Rule if shipment exceed some volume or dollar amount then shipper need an approval from Manager , to handle that, you can add Approval Notification in the Ship Confirm workflow and manager can approve or reject that. Another example is if you want to add some 3<sup>rd</sup><span class="Apple-converted-space"> </span>Party APIs in your ship confirm process.</span></li></ul><p style="font-size: 1.05em;"><span style="font-family: Arial,sans-serif; font-size: 10pt;"></span></p><ul style="margin-left: 0px; padding: 0px 0px 0px 10px; list-style-type: none; text-indent: -10px; margin-top: 0in;" type="disc"><li class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">This Sub Process is again Optional, If you want to enable it or Disable it, you can do that from the Global /Shipping Parameter window. Please Note that you can still use Delivery Workflow even if you don’t want to use Ship confirm flow.</span></li></ul><p style="font-size: 1.05em;"><span style="font-family: Arial,sans-serif; font-size: 10pt;"></span></p><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/03/wf-wsh3.GIF" title="wf-wsh3.GIF" style="text-decoration: none;"><p style="font-size: 1.05em; text-align: center;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/03/wf-wsh3.thumbnail.GIF" alt="wf-wsh3.GIF" style="padding: 0px; max-width: 100%; border-style: none;" /></p></a><p style="font-size: 1.05em;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">As stated earlier advantages of the Oracle is everything is pick and choose , you can enable /disable this workflow as per your requirement , If you don’t want this workflow , just disable It.</span><span style="font-family: Arial,sans-serif; font-size: 10pt;"><span> </span></span><span style="font-family: Arial,sans-serif; font-size: 10pt;">That means if you are interested in the Delivery and Trip workflow and you don’t want Ship Confirm (Ship To Delivery) flow you can just disable the Ship Confirm flow and keep other flow.</span><span style="font-family: Arial,sans-serif; font-size: 10pt;"> </span><span style="font-family: Arial,sans-serif; font-size: 10pt;"></span><span style="font-family: Arial,sans-serif; font-size: 10pt;"></span></p><h2 style="font-family: 'Trebuchet MS','Lucida Grande',Verdana,Arial,sans-serif; font-weight: bold; font-size: 1.3em; text-decoration: none; margin: 0in 0in 0pt;"><span style="font-size:85%;">Business Events</span></h2><p class="MsoBodyText" style="font-size: 1.05em; margin: 0in 0in 0pt;">Shipping workflow has introduced lots of the business events, which when raised/received take the required actions (like calling of other workflows etc). These too again are optional and can be enable / disabled. If we look closely all these workflow , we can notice that we have lots of business events in all the flows.</p><p style="font-size: 1.05em;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Please note that once we select any type of the workflow</span></p><ol style="padding: 0px 0px 0px 35px; margin: 0in 0px 0px;" type="1"><li class="MsoNormal" style="list-style-type: decimal; list-style-position: outside; margin: 0in 0in 0pt; padding: 0px;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Delivery</span></li><li class="MsoNormal" style="list-style-type: decimal; list-style-position: outside; margin: 0in 0in 0pt; padding: 0px;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Trip</span></li><li class="MsoNormal" style="list-style-type: decimal; list-style-position: outside; margin: 0in 0in 0pt; padding: 0px;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Ship –To-Delivery</span></li></ol><p style="font-size: 1.05em;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Some of events become core and system will not allow us to disable them. It is the business events that made the shipping flow flexible and we pick and choose what ever we like.</span></p><p style="font-size: 1.05em;"><span style="font-size:85%;"><strong>Shipping workflow Setup</strong></span></p><p style="font-size: 1.05em;"><span style="font-family: Arial,sans-serif; font-size: 10pt;"></span><span style="font-family: Arial,sans-serif; font-size: 10pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Shipping flow can be setup by means of Selecting the workflow from the<span class="Apple-converted-space"> </span></span><span style="font-family: Arial,sans-serif; font-size: 10pt;">Global Parameters</span><span style="font-family: Arial,sans-serif; font-size: 10pt;">Shipping parameters</span><span style="font-family: Arial,sans-serif; font-size: 10pt;"> </span></span></p><h2 style="font-family: 'Trebuchet MS','Lucida Grande',Verdana,Arial,sans-serif; font-weight: bold; font-size: 1.3em; text-decoration: none; margin: 0in 0in 0pt;"><span style="font-size:85%;">Global Parameters</span></h2><p style="font-size: 1.05em; margin: 0in 0in 0pt;" align="center"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/03/wf-wsh4.GIF" title="wf-wsh4.GIF" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/03/wf-wsh4.thumbnail.GIF" alt="wf-wsh4.GIF" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em; margin: 0in 0in 0pt;" align="center"> </p><p style="font-size: 1.05em; margin: 0in 0in 0pt;" align="center"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/03/wf-wsh5.GIF" title="wf-wsh5.GIF" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/03/wf-wsh5.thumbnail.GIF" alt="wf-wsh5.GIF" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><h2 style="font-family: 'Trebuchet MS','Lucida Grande',Verdana,Arial,sans-serif; font-weight: bold; font-size: 1.3em; text-decoration: none; margin: 0in 0in 0pt;"><span style="font-size:85%;">Shipping Parameters</span></h2><p style="font-size: 1.05em;" align="center"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/03/wf-wsh6.GIF" title="wf-wsh6.GIF" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/03/wf-wsh6.thumbnail.GIF" alt="wf-wsh6.GIF" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;" align="center"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/03/wf-wsh7.GIF" title="wf-wsh7.GIF" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/03/wf-wsh7.thumbnail.GIF" alt="wf-wsh7.GIF" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Shipping Parameters will do the setup only for the Organization level, where as Global Parameter will do the setup at the Application level. Auto Sync between Global and Shipping parameters has been provided.</span><span style="font-family: Arial,sans-serif; font-size: 10pt;"> </span><span style="font-family: Arial,sans-serif; font-size: 10pt;"><span style="font-family: Arial,sans-serif; font-size: 10pt;">Customer can customized any shipping workflow. Please do not customize/extend the Seeded workflow, rather take a copy of seed workflow as extend as per your requirement. Shipping has provided Lookup setup to assign your custom workflow. We have flexibility to assign custom workflow to all or few of the organizations.<span class="Apple-converted-space"> </span></span><span style="font-family: Arial,sans-serif; font-size: 10pt;"> </span></span></p><h2 style="font-family: 'Trebuchet MS','Lucida Grande',Verdana,Arial,sans-serif; font-weight: bold; font-size: 1.3em; text-decoration: none; margin: 0in 0in 0pt;"><span style="font-size:85%;">Profile options</span></h2><p style="font-size: 1.05em;"><strong><span style="font-family: Arial,sans-serif; font-size: 10pt;">Override Ship To Deliver Workflow –<span class="Apple-converted-space"> </span></span></strong><span style="font-family: Arial,sans-serif; font-size: 10pt;">Oracle is Provide this profile option and if mark Yes this will Process the Ship Confirm workflow , In case it got stuck because of some Technical reason.</span></p></span></span>iBizSofthttp://www.blogger.com/profile/11168350594962689642noreply@blogger.com0tag:blogger.com,1999:blog-3538220923456946440.post-12466660054108293842010-12-19T22:17:00.000-08:002010-12-19T22:18:28.886-08:00Parallel Pick Release R12<span class="Apple-style-span" style="border-collapse: separate; color: rgb(255, 255, 255); font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;font-family:'Times New Roman';font-size:medium;" ><span class="Apple-style-span" style="line-height: 16px; text-align: justify;font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:12px;" ><p class="MsoNormal" style="font-size:1.05em;"><span class="Apple-style-span" style="font-family:Arial,sans-serif;">Oracle has introduced lots of interesting features in R12.In this post I will talk about the one such feature.</span></p><p class="MsoNormal" style="font-size:1.05em;"><span class="Apple-style-span" style="font-family:Arial,sans-serif;"><strong>Parallel Pick Release</strong></span></p><span class="Apple-style-span" style="font-family:Arial,sans-serif;"><p class="MsoNormal" style="font-size:1.05em;">With this feature user can now run the Pick Release processes in parallel and improve the over all performance.</p><p class="MsoNormal" style="font-size:1.05em;"><strong>Advantages</strong></p><p class="MsoNormal" size="1.05em">One of Key Advantage of with Parallel Processing of the Pick release process is user can apply /engage additional (if available) resources to process the Pick release data that was previously process by 1 process only and hence save lot of time by submitting this process in Parallel.</p><p style="font-size:1.05em;"><span id="more-655"></span></p><p class="MsoNormal" size="1.05em"><strong>Following are the changes made for this feature –</strong></p><p class="MsoNormal" size="1.05em">1.<span class="Apple-tab-span" style="white-space: pre;"> </span>A new Parameter has introduced in Pick release Concurrent Program.</p><p class="MsoNormal" size="1.05em">2.<span class="Apple-tab-span" style="white-space: pre;"> </span>A new profile option has introduced.</p><p class="MsoNormal" size="1.05em"><strong>Parameter –</strong></p><p class="MsoNormal" size="1.05em">No. Of Child Processes – This parameter indicates how many child processes you want to spawn.</p><p class="MsoNormal" style="font-size: 1.05em;"><strong>Profile Option -</strong></p><p class="MsoNormal" style="font-size: 1.05em;">WSH: No. Of pick release child processes. – Indicate how many child processes you want to spawn.</p><p class="MsoNormal" style="font-size: 1.05em;">If we run the Pick release from SRS or Public API then profile option determine the # of child processes to be spawned.</p><p class="MsoNormal" style="font-size: 1.05em;">If we run the Pick release from in Online Mode or Public API (online mode) then only 1 child processes to be spawned ( as good as existing behavior).</p><p class="MsoNormal" style="font-size: 1.05em;"><strong>Some Constraints -</strong></p><p class="MsoNormal" style="font-size: 1.05em;">Irrespective of the parameter value and the profile option only 1 child process will be spawned if</p><p class="MsoNormal" style="font-size: 1.05em;">1.<span class="Apple-tab-span" style="white-space: pre;"> </span>Auto Create Delivery = Y and print Pick Slip is set as Immediate</p><p class="MsoNormal" style="font-size: 1.05em;">2.<span class="Apple-tab-span" style="white-space: pre;"> </span>Auto Create Delivery = Y and Delivery is enabled as Pick slip Grouping rule.</p><p class="MsoNormal" style="font-size: 1.05em;"><strong>Setup</strong></p><p class="MsoNormal" style="font-size: 1.05em;">WSH: No. of pick release child processes.</p><p class="MsoNormal" style="font-size: 1.05em;">If value of this profile option is Null or 1 then only 1 Child Process will be submitted.</p><p class="MsoNormal" style="font-size: 1.05em;">If value of this profile option is > = 2 ( 2 to n) then N no. of Child Process will be submitted for Pick release ( some restriction applied , as discussed below).</p><p class="MsoNormal" style="font-size: 1.05em;">By setting this profile option to any value doesn’t mean system will spawned that many child process. The # of child process spawned depend upon this profile option as well as the Unique item in the data SELECTED for the pick release.</p><p class="MsoNormal" style="font-size: 1.05em;">Or more precisely we say No. of child process available for Pick release depend on the # of unique “Item and Organization “ combination.</p><p class="MsoNormal" style="font-size: 1.05em;">e.g –</p><p class="MsoNormal" style="font-size: 1.05em;">1.<span class="Apple-tab-span" style="white-space: pre;"> </span>If Organization V1 has 100 unique item</p><p class="MsoNormal" style="font-size: 1.05em;">2.<span class="Apple-tab-span" style="white-space: pre;"> </span>Profile option is set to value of 10</p><p class="MsoNormal" style="font-size: 1.05em;">Case #1</p><p class="MsoNormal" style="font-size: 1.05em;">If in the data selected for pick release has 20 Unique items, the # of child process submitted for Parallel Pick release will be 10.</p><p class="MsoNormal" style="font-size: 1.05em;">Case #2</p><p class="MsoNormal" style="font-size: 1.05em;">If in the data selected for pick release has 4 Unique items, the # of child process submitted for Parallel Pick release will be 4 , irrespective of Profile option is set to value of 10.</p><p class="MsoNormal" style="font-size: 1.05em;"><strong>Concurrent Program</strong></p><p class="MsoNormal" style="font-size: 1.05em;">As explained earlier a new Parameter (No. of Child Processes) has been introduced in concurrent Program “ Pick Selection List Generation – SRS”.</p><p class="MsoNormal" style="font-size: 1.05em;">No. of child processes spawned are depend on the value you enter in this parameter , and by default value from the Profile option “WSH: No. of pick release child processes” defaulted for this parameter , but here we have advantage to overwrite the value of profile.</p><p class="MsoNormal" style="font-size: 1.05em;">Note – both the case#1 and case#2 will valid here too.</p><p class="MsoNormal" style="font-size: 1.05em;">Note - # of pick slip reports not depend on this profile options, they still depend on the pick slip Grouping rules.</p><p class="MsoNormal" style="font-size: 1.05em;"><strong>Other Considerations</strong></p><p class="MsoNormal" style="font-size: 1.05em;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>If we submit the pick release process from the Shipping Transaction UI, then only 1 process will be launch, parallel Pick release will not applicable, but if we launch the Pick Release process from Shipping transaction UI , Tools > then the Parallel Pick release Process will work fine.</p><p class="MsoNormal" style="font-size: 1.05em;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>In SRS window, all the child process will carry the Parent Request ID of the parent.</p></span></span></span>iBizSofthttp://www.blogger.com/profile/11168350594962689642noreply@blogger.com0tag:blogger.com,1999:blog-3538220923456946440.post-14563436398741329102010-12-19T22:13:00.000-08:002010-12-19T22:14:34.308-08:00How to Setup Tax on Freight in R12 E-Business Tax (EBTax) Order to Cash<span class="Apple-style-span" style="border-collapse: separate; color: rgb(255, 255, 255); font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;font-family:'Times New Roman';font-size:medium;" ><span class="Apple-style-span" style="line-height: 16px; text-align: justify;font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:12px;" ><p style="font-size:1.05em;"><strong>How to Setup Tax on Freight in R12 E-Business Tax (EBTax) Order to Cash<br /></strong><br /><strong><u>Problem Scenario :</u></strong></p><p style="font-size:1.05em;">How to tax freight in R12?<span class="Apple-converted-space"> </span><br />How to tax freight only in certain states?</p><p size="1.05em"><strong><u>Solution</u></strong></p><p size="1.05em">In R12, there is not a way to tax freight lines unless they are setup as inventory items.</p><p size="1.05em"><span id="more-924"></span><br /></p><h3 class="style1" style="font-family: 'Trebuchet MS','Lucida Grande',Verdana,Arial,sans-serif; font-weight: bold; font-size: 1.3em; text-decoration: none; padding: 0px; margin: 30px 0px 0px;">Setting up Freight</h3><p style="font-size: 1.05em;">In order to tax freight, the following steps must be performed<br />1. Create Freight as an Inventory Item.</p><p style="font-size: 1.05em;"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image002_0002.jpg" title="clip_image002_0002.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image002_0002.thumbnail.jpg" alt="clip_image002_0002.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;">2. Setup the following profiles as described under Order Management Responsibility:</p><p style="font-size: 1.05em;"><strong>eBTax: Inventory Item for Freight as ‘Yes’.</strong></p><p style="font-size: 1.05em;"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image005_0000.jpg" title="clip_image005_0000.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image005_0000.thumbnail.jpg" alt="clip_image005_0000.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;"><strong>eBTax: Invoice Freight as Revenue as ‘Yes’.</strong></p><p style="font-size: 1.05em;"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image008_0002.jpg" title="clip_image008_0002.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image008_0002.thumbnail.jpg" alt="clip_image008_0002.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><h3 style="font-family: 'Trebuchet MS','Lucida Grande',Verdana,Arial,sans-serif; font-weight: bold; font-size: 1.3em; text-decoration: none; padding: 0px; margin: 30px 0px 0px;">Conditionally Taxing Freight</h3><p style="font-size: 1.05em;">In the United States, not all jurisdictions charge taxes on Freight. If you do not want to tax freight for all states then there are two options:<br />Option 1: Setup Product Rate Exceptions for those jurisdictions that you do not want to tax freight on.<br />Option 2: Setup a tax rule to disable taxes.</p><p style="font-size: 1.05em;"> </p><p style="font-size: 1.05em;"><strong><u>Setup Product Rate Exceptions for those jurisdictions that you do not want to tax freight on.</u></strong><br />Products> Tax Exceptions<span class="Apple-converted-space"> </span><br />1. Navigate to the Create Tax Exception page.<span class="Apple-converted-space"> </span><br />2. Enter the tax regime, configuration owner, and tax to which this tax exception<span class="Apple-converted-space"> </span><br />belongs.<span class="Apple-converted-space"> </span><br />3. If applicable, enter the tax status, tax rate, and tax jurisdiction for this tax exception.<span class="Apple-converted-space"> </span><br />4. Select the exception type to use:<span class="Apple-converted-space"> </span><br />If this is an Item exception, enter the inventory organization and inventory item.</p><p style="font-size: 1.05em;"><strong>1. Click on create</strong></p><p style="font-size: 1.05em;"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image012_0001.jpg" title="clip_image012_0001.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image012_0001.thumbnail.jpg" alt="clip_image012_0001.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;"><strong>2. Enter the Mandatory fields in the Tax exception Creation Form. Click on apply.</strong></p><p style="font-size: 1.05em;"><strong><br /><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image014_0000.jpg" title="clip_image014_0000.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image014_0000.thumbnail.jpg" alt="clip_image014_0000.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></strong></p><p style="font-size: 1.05em;"><strong>3. A Confirmation message stating the Tax Exception has been created appears.</strong></p><p style="font-size: 1.05em;"><strong><br /><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image017.jpg" title="clip_image017.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image017.thumbnail.jpg" alt="clip_image017.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></strong><strong></strong></p><p style="font-size: 1.05em;"><strong><u>Setup a tax rule to disable taxes.</u></strong></p><p style="font-size: 1.05em;">This is done as follows:<br />Create a new Category Set (Ex: Tax Category)<br />Inventory Responsibility > Setup : Items : Categories : Category Sets<strong></strong></p><p style="font-size: 1.05em;"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image019.jpg" title="clip_image019.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image019.thumbnail.jpg" alt="clip_image019.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;">Query the Freight Inventory Item and associate it to an item category (Ex: Tax Category)<br />Inventory Responsibility > Inventory > Items > Master Items</p><p style="font-size: 1.05em;"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image022_0000.jpg" title="clip_image022_0000.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image022_0000.thumbnail.jpg" alt="clip_image022_0000.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;">Define a Product Fiscal Classification in Tax Managers<br />Responsibility Tax Manager > Products > Product Classifications > Create<span class="Apple-converted-space"> </span><br />Click on ‘<strong>Create’<span class="Apple-converted-space"> </span></strong>to create a new product classification</p><p style="font-size: 1.05em;"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image024_0000.jpg" title="clip_image024_0000.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image024_0000.thumbnail.jpg" alt="clip_image024_0000.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;">Create Product Classification Page: Fill the Mandatory Details. Click on Apply</p><p style="font-size: 1.05em;"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image026_0000.jpg" title="clip_image026_0000.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image026_0000.thumbnail.jpg" alt="clip_image026_0000.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;">A confirmation message of Product classification being created appears.</p><p style="font-size: 1.05em;"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image028_0000.jpg" title="clip_image028_0000.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image028_0000.thumbnail.jpg" alt="clip_image028_0000.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;">Create a tax applicability rule to conditionally disable tax calculation (assumes that default for tax is applicable).<br />Tax Manager > Tax Configuration > Tax Rules<br />With the default set to "Applicable", select the "Guided Rule Entry" option for the Tax Applicability rule.</p><p style="font-size: 1.05em;"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image030_0000.jpg" title="clip_image030_0000.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image030_0000.thumbnail.jpg" alt="clip_image030_0000.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;"><strong>Guided rule Entry</strong><span class="Apple-converted-space"> </span>to define the<span class="Apple-converted-space"> </span><strong>Tax Rules</strong></p><p style="font-size: 1.05em;"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image035.jpg" title="clip_image035.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image035.thumbnail.jpg" alt="clip_image035.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;">Enter the<span class="Apple-converted-space"> </span><strong>general information</strong></p><p style="font-size: 1.05em;"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image037.jpg" title="clip_image037.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image037.thumbnail.jpg" alt="clip_image037.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;"><strong>Enter the Tax Rule Conditions:</strong></p><p style="font-size: 1.05em;"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image039.jpg" title="clip_image039.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image039.thumbnail.jpg" alt="clip_image039.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;"><strong>Click on Product: Enter the Product Classification. Click on Next.</strong></p><p style="font-size: 1.05em;"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image041.jpg" title="clip_image041.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image041.thumbnail.jpg" alt="clip_image041.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;"><strong>Enter the applicable Tax :’Not Applicable’</strong></p><p style="font-size: 1.05em;"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image043.jpg" title="clip_image043.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/clip_image043.thumbnail.jpg" alt="clip_image043.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;">Click on Next and the Rule gets applied. The <span class="Apple-converted-space"> </span><strong>Disable Tax</strong><span class="Apple-converted-space"> </span>Rule gets applied</p></span></span>iBizSofthttp://www.blogger.com/profile/11168350594962689642noreply@blogger.com3tag:blogger.com,1999:blog-3538220923456946440.post-58113055471642084832010-12-19T22:10:00.000-08:002010-12-19T22:11:49.300-08:00XLE Error Document<span class="Apple-style-span" style="border-collapse: separate; color: rgb(255, 255, 255); font-family: 'Times New Roman'; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; font-size: medium;"><span class="Apple-style-span" style="font-family: 'Lucida Grande',Verdana,Arial,sans-serif; font-size: 12px; line-height: 16px; text-align: justify;"><p style="font-size: 1.05em;">While Processing the Sales Order (Booking the Sales Order )the following error occurs :<br />ERROR<br />———————–<br />XLE call raised error<br />User-Defined Exception in Package OM_TAX_UTIL Procedure Tax_line.<br />Following are the screenshots of the error.</p><p style="font-size: 1.05em;"><span id="more-938"></span></p><p style="font-size: 1.05em;"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/xle-error-document_clip_image002.jpg" title="xle-error-document_clip_image002.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/xle-error-document_clip_image002.thumbnail.jpg" alt="xle-error-document_clip_image002.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a><br /><br /><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/xle-error-document_clip_image004.jpg" title="xle-error-document_clip_image004.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/xle-error-document_clip_image004.thumbnail.jpg" alt="xle-error-document_clip_image004.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;"><strong><u>Solution :</u></strong></p><p style="font-size: 1.05em;"><u>Run the “Replicate Seed Concurrent “Program </u></p><p style="font-size: 1.05em;">Log in to application with System Administrator responsibility<br />The navigation path is: Concurrent > Requests.</p><p style="font-size: 1.05em;"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/xle-error-document_clip_image006.jpg" title="xle-error-document_clip_image006.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/xle-error-document_clip_image006.thumbnail.jpg" alt="xle-error-document_clip_image006.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;">Submit the Request :</p><p style="font-size: 1.05em;"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/xle-error-document_clip_image010.jpg" title="xle-error-document_clip_image010.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/xle-error-document_clip_image010.thumbnail.jpg" alt="xle-error-document_clip_image010.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;">Request ID gets generated:</p><p style="font-size: 1.05em;"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/xle-error-document_clip_image012.jpg" title="xle-error-document_clip_image012.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/xle-error-document_clip_image012.thumbnail.jpg" alt="xle-error-document_clip_image012.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;">View the Request:</p><p style="font-size: 1.05em;"><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/xle-error-document_clip_image015.jpg" title="xle-error-document_clip_image015.jpg" style="text-decoration: none;"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/xle-error-document_clip_image015.thumbnail.jpg" alt="xle-error-document_clip_image015.jpg" style="padding: 0px; max-width: 100%; border-style: none;" /></a></p><p style="font-size: 1.05em;">Navigate back to the Sales Order Form under Order Management Super user. Retest the issue.<br />Order gets placed successfully.</p><p style="font-size: 1.05em;"> </p></span></span>iBizSofthttp://www.blogger.com/profile/11168350594962689642noreply@blogger.com1tag:blogger.com,1999:blog-3538220923456946440.post-13694415816983972732010-10-18T23:13:00.000-07:002010-10-18T23:34:23.430-07:00Customer Standard Profile ClassWhile creating a new customer through the Customer Standard form of Order Management Super User Responsibility, the system threw up an error message "Error: Provide a positive integer for minimum customer balance amount or percent when balance amount overdue type is amount or percent respectively". Below steps can be followed to resolve the error.<ol> <li>Login to the application with ‘<strong><em>Oracle Order Management Super User’</em></strong> Responsibility</li> <li>The Navigation Path is Customers>Profile Class.</li> <li>Query for the Profile Class “DEFAULT”</li> <li>For each currency, make sure that the Minimum Customer Balance is not null and there exists a corresponding value.</li> <li>Save the Changes.</li></ol>Following screenshots depicts the above steps<br /><br /><br /><br />Navigation: Customer >Profile Class.<br /><br /><br /><br />Query the Profile Class “DEFAULT”<br /><br /><br /><br /><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/cspclass_1.jpg" title="cspclass_1.jpg"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/cspclass_1.thumbnail.jpg" alt="cspclass_1.jpg" /></a>iBizSofthttp://www.blogger.com/profile/11168350594962689642noreply@blogger.com1tag:blogger.com,1999:blog-3538220923456946440.post-38742035496442482992010-10-13T22:01:00.000-07:002010-10-13T22:03:40.065-07:00Sales Order ErrorWhen the user navigates to Order Management responsibility on setting up BG, OU, Inv Org and responsibilities MO- default Operating Unit, MO-Operating Unit, HR: Cross Business Group = yes, Security Profile = Business Group ID and tries to access the Order Management Form then two consecutive note pops up:<br /> <ol><li>Validation failed for the field- Sales person</li><br /> <li>User defined exception in Package OE_Default_Header procedure attributes.<br /></li></ol><strong><u>Note 1 : Validation failed for the field- Salesperson</u></strong><br /><p><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_1.jpg" title="salesorder_error_1.jpg"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_1.thumbnail.jpg" alt="salesorder_error_1.jpg" /></a></p><strong><u>Note2: OE_Default_Header procedure attributes</u></strong><br /><p><strong><u> </u></strong><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_2.jpg" title="salesorder_error_2.jpg"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_2.thumbnail.jpg" alt="salesorder_error_2.jpg" /></a></p><strong><u>Solution:</u></strong><br /><p><strong>Set the Profile option MO: Operating Unit to the desired operating unit under all the responsibilities.</strong></p>Login to the application with ‘<strong><em>System Administrator’ </em></strong>Responsibility.<br /><p> The Navigation Path is Profile >System</p><strong><br />Set the Profile option OM : Default Sales Rep at the Site Level.</strong><br /><p>Login to the application with ‘<strong><em>System Administrator’ </em></strong>Responsibility.</p>The Navigation Path is Profile >System<br /><p><strong><br /></strong></p><p><strong>Map the Responsibility with the desired Organization</strong></p>Login to the application with ‘<strong><em>Oracle Order Management Super User’</em></strong> Responsibility.<br /><p>1. The Navigation Path is Inventory > Setup >Organizations.</p><p><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_3.jpg" title="salesorder_error_3.jpg"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_3.thumbnail.jpg" alt="salesorder_error_3.jpg" /></a></p><br /><p><strong>Define the System option under Oracle Receivables.</strong></p><ol><li>Login to the application with ‘Receivables Manager’ responsibility.</li><br /> <li>The Navigation Path is Setup > System>System Option.</li><br /></ol><p><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_4.jpg" title="salesorder_error_4.jpg"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_4.thumbnail.jpg" alt="salesorder_error_4.jpg" /></a></p><p><strong>Define the Transaction Type under Oracle Receivables.</strong></p><ol><br /> <li>Login to the application with ‘Receivables Manager’ responsibility.</li><br /> <li>The Navigation Path is Setup > System>System Option.</li><br /> <p><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_5.jpg" title="salesorder_error_5.jpg"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_5.thumbnail.jpg" alt="salesorder_error_5.jpg" /></a></p><br /> <li>Save the information.</li></ol><p> </p><p><strong>Define Defaulting Rule under Order Management Super User Responsibility.</strong></p><ol><li>Login to the application with ‘<strong>Order Management Super User</strong>’ responsibility</li><br /> <li> The Navigation Path is <strong>Setup>Rules>Defaulting</strong></li><br /> <li>Query entity = <strong>Order Header</strong> and attribute = <strong>Salesperson</strong>.</li><br /> <li>Modify the defaulting rule so that validation is correct.</li><br /></ol><p><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_3.jpg" title="salesorder_error_3.jpg"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_3.thumbnail.jpg" alt="salesorder_error_3.jpg" /></a></p><p>Modify the defaulting rule according to the Business Requirement</p><p> <a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_7.jpg" title="salesorder_error_7.jpg"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_7.thumbnail.jpg" alt="salesorder_error_7.jpg" /></a></p><p><strong>Define the Transaction type under Order Management Super user Responsibility.</strong></p><p><strong>Two types of Transactions are defined : Order Type and Line Type.</strong></p><ol><li>Login to the application with ‘<strong>Order Management Super User</strong>’ responsibility.</li><br /> <li> The Navigation Path is Setup>Transaction Type> Define</li><br /> <li>Define the Transaction type for Sales Order.</li><br /> <li>Navigate to the Shipping Tab and Assign the Warehouse Organization in the Warehouse Field.</li><br /> <li>Navigate to the Finance Tab and Enter the <strong>Invoicing Rule</strong> and the <strong>Accounting Rule</strong></li><br /> <li>Save the Information</li><br /> <li>Define the Line Type Transaction</li><br /> <li>Navigate to the Shipping Tab and Assign the Warehouse Organization in the Warehouse Field.</li><br /> <li>Navigate to the Finance Tab and Enter the <strong>Invoicing Rule</strong> and the <strong>Accounting Rule</strong></li><br /> <li><strong>Query the<strong> ‘Order Type’ </strong>Transaction Typeand click on<strong> Assign Line flows </strong>to assign the Line type to the Order Type Transaction.</strong></li><br /></ol><p><strong><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_8.jpg" title="salesorder_error_8.jpg"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_8.thumbnail.jpg" alt="salesorder_error_8.jpg" /></a></strong></p><p><strong><u>Shipping Tab</u></strong></p><p><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_12.jpg" title="salesorder_error_12.jpg"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_12.thumbnail.jpg" alt="salesorder_error_12.jpg" /></a></p><p><strong><u>Finance Tab</u></strong></p><p><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_13.jpg" title="salesorder_error_13.jpg"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_13.thumbnail.jpg" alt="salesorder_error_13.jpg" /></a></p><p><strong><u>Line type : Transaction Type</u></strong></p><p><strong><u>Similar to Order Type define the Warehouse Organization under shipping Tab and Invoicing Rules under</u></strong></p><p><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_14.jpg" title="salesorder_error_14.jpg"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_14.thumbnail.jpg" alt="salesorder_error_14.jpg" /></a></p><p><strong><u>Assign the Line Type Transaction to Order Type.</u></strong></p><p> Query on Order type Transaction and click on Assign Line Flows</p><p><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_15.jpg" title="salesorder_error_15.jpg"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_15.thumbnail.jpg" alt="salesorder_error_15.jpg" /></a></p><p><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_16.jpg" title="salesorder_error_16.jpg"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/salesorder_error_16.thumbnail.jpg" alt="salesorder_error_16.jpg" /></a></p>iBizSofthttp://www.blogger.com/profile/11168350594962689642noreply@blogger.com0tag:blogger.com,1999:blog-3538220923456946440.post-50036514519924903282010-10-13T21:19:00.000-07:002010-10-13T21:59:13.316-07:00Customer Standard Profile ClassWhile creating a new customer through the Customer Standard form of Order Management Super User Responsibility, the system threw up an error message "Error: Provide a positive integer for minimum customer balance amount or percent when balance amount overdue type is amount or percent respectively". Below steps can be followed to resolve the error.<br /><ol> <li>Login to the application with ‘<strong><em>Oracle Order Management Super User’</em></strong> Responsibility</li> <li>The Navigation Path is Customers>Profile Class.</li> <li>Query for the Profile Class “DEFAULT”</li> <li>For each currency, make sure that the Minimum Customer Balance is not null and there exists a corresponding value.</li> <li>Save the Changes.</li><br /></ol>Following screenshots depicts the above steps<br /><br />Navigation: Customer >Profile Class.<br /><br />Query the Profile Class “DEFAULT”<br /><br /><a href="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/cspclass_1.jpg" title="cspclass_1.jpg"><img src="http://ibizsoftinc.com/blogs/wp-content/uploads/2010/10/cspclass_1.thumbnail.jpg" alt="cspclass_1.jpg" /></a>iBizSofthttp://www.blogger.com/profile/11168350594962689642noreply@blogger.com0tag:blogger.com,1999:blog-3538220923456946440.post-32233184116311234692010-02-19T05:25:00.000-08:002010-02-19T05:26:39.630-08:00Sales Order line stuck at “Create Supply Order - Eligible”.<p><span style="color:#333333;"><span style="font-family:Arial, sans-serif;">In this blog I will explain why some time Sales Order line stuck at “Create Supply Order - Eligible” , and every attemept to progress it push the workflow to SHIP activity but then again back to Create Supply activity with result = Unreserve. </span>I have notice that this is very common issue that customer encounter , Workflow for order line looks good and at SHIP_LINE - Notified , but then it go backs ro “Create Supply ” workflow activity with Result code = Unreserve.<br />In Order management we have different kinds of flows and their is possibility that this issue MAY appears in any type of flow (ONE and ONLY reason for this type of issues is DATA CORRUPTION).In this blog I will explain only why that has happend in Back to Back Orders.</span></p> <p><span id="more-621"></span></p> <p><span style="color:#333333;"><span style="color:#333333;"><span style="font-family:Arial, sans-serif;"><strong><span style="color:#333333;"><span style="font-family:Arial, sans-serif;">Reason is very Simple -</span></span></strong><span style="color:#333333;"><span style="font-family:Arial, sans-serif;"> When a requisition gets created for a Sales Order line, order line gets reserved to this requisition. When sub inventory information is changed for this line, this reservation gets deleted and line moves back to Supply Eligible state.Point I want to explain here is if any changes made to back to back order line that impact the values like<br />Schedule ship date,<br />Subinventory,<br />Quanity etc.<br />Sales Order line moves back to Supply Eligible state. </span></span></span></span></span></p>iBizSofthttp://www.blogger.com/profile/11168350594962689642noreply@blogger.com0