tag:blogger.com,1999:blog-52342591745433672472024-03-08T16:14:51.057-08:00Oracle Order ManagementJust Shared !S.Grace Paul Reganhttp://www.blogger.com/profile/08467360023113459306noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-5234259174543367247.post-92214261919817741482013-11-24T00:10:00.002-08:002013-11-24T00:10:30.495-08:00FAQ - Internal Requisition (IR) Internal Sales Order (ISO) - Internal Requisition Change Request <div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Verdana, sans-serif;">1. When the change from the internal requisition is accepted, who receives the </span><br />
<span style="font-family: Verdana, sans-serif;"> notification?</span><br />
<span style="font-family: Verdana, sans-serif;">A: The notification is sent to the planner when using Available to Promised (ATP) in the IR-ISO process.</span><br />
<span style="font-family: Verdana;"></span><br />
<span style="font-family: Verdana, sans-serif;">2. Which Workflow process is involved on the IR change?<br />A: The workflow processes are the same as from the supplier/external requisitions change process: POREQCHA and REQAPPRV.</span><br />
<br />
<span style="font-family: Verdana, sans-serif;">3. How to get the Internal Requisition Workflow Process statuses.<br />A: To get the IR workflow statuses execute:</span><br />
<span style="font-family: Verdana, sans-serif;">SQL> select wf_item_type, wf_item_key from po_change_requests where document_type = 'REQ' and document_header_id = in (select requisition_header_id from po_requisition_headers_all<br />where segment1 = '&requisition_number');</span><br />
<span style="font-family: Verdana, sans-serif;"><br />Replace by the requisition number. G</span><span style="font-family: Verdana, sans-serif;">o to $FND_TOP/sql</span><br />
<span style="font-family: Verdana, sans-serif;"><br />SQL> @wfstat.sql <wf_item_type> <wf_item_key> Replace from previous query. </wf_item_key></wf_item_type></span><span style="font-family: Verdana, sans-serif;">Output shows the activity statuses from the workflow process POREQCHA - PO Requisition Change Request.</span><br />
<span style="font-family: Verdana;"></span><br />
<span style="font-family: Verdana, sans-serif;">4. Where in the Workflow the notification is sent to the planner.<br />A: The activity sending the notification is: Main Requisition Change Approval/Send internal change notifications.</span><br />
<span style="font-family: Verdana;"></span><br />
<span style="font-family: Verdana, sans-serif;">5. Sometimes the change in the requisition is not allowed.<br />A: See Note 1357959.1 - IR - ISO: In Which Conditions Internal Requisition With Internal Sales Order Changes Are Not Allowed. The note lists the conditions where the IR-ISO Change Management is not allowed.</span><br />
<span style="font-family: Verdana;"></span><br />
<span style="font-family: Verdana, sans-serif;">6. Can I start the change request from core form requisition?<br />A: The change request can be started from core requisiton form. Query the internal requisition which is with a Sales Order. Click Tools in the top menu. Then, choose Change. The iProcurement change order page will show to enter the changes. </span><span style="font-family: Verdana, sans-serif;">iProcurement needs to be installed in order to execute the change request process from core requisition.</span><br />
<span style="font-family: Verdana;"></span><br />
<span style="font-family: Verdana, sans-serif;">8. Can I execute the change request in an internal requisition without iProcurement license?<br />A: The internal requisition change request is a feature available from iProcurement. Thus, iProcurement needs to be licensed and configured in the instance in order to execute a change request with IR-ISO. </span><br />
<span style="font-family: Verdana;">Thanks & Regards,</span><br />
<span style="font-family: Verdana;">S.Grace Paul Regan</span><br />
<span style="font-family: Verdana;"></span> </div>
S.Grace Paul Reganhttp://www.blogger.com/profile/08467360023113459306noreply@blogger.com17tag:blogger.com,1999:blog-5234259174543367247.post-60600497106569675372013-11-22T23:55:00.003-08:002013-11-22T23:55:51.247-08:00FAQ: Oracle Order Management Drop Ship Purchase Orders<div dir="ltr" style="text-align: left;" trbidi="on">
<strong style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Q1. What is a Drop Ship PO?</strong><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">A: Oracle Order Management and Oracle Purchasing integrate to provide Drop Shipments. Drop Shipments are orders for items that your supplier ships directly to the customer either because you don't stock or currently don't have the items in inventory, or because it's more cost effective for the supplier to ship the item to the customer directly. Drop Shipment was introduced in R11.</span><br />
<span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;"><br /></span>
<strong style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Q2. How is a Drop Ship PO created?<br /><br />A:</strong><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;"> Drop Shipments are created as Sales Orders in Order Management. The Purchase Release concurrent program or workflow in Order Management creates rows in the Requisition Import tables in Purchasing. Then Purchasing's Requisition Import process creates the requisitions. Drop Shipments are marked with the Source Type of External in Order Management and Supplier in Purchasing.</span><br />
<span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;"><br /></span>
<strong style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Q3. What is the setup required for Drop Ship PO?<br /><br />A: ITEM ATTRIBUTES:</strong><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;"> </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Navigate: Inventory -> Items - > Organization items </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Purchased (PO) Enabled </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Purchasable (PO) Enabled </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Transactable (INV) Enabled </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Stockable (INV) Optional </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Reservable (INV) Optional </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Inventory Item (INV) Optional </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Customer Ordered (OM) Enabled </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Customer Orders Enabled (OM) Enabled </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Internal Ordered (OM) Disabled </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Internal Orders Enabled (OM) Disabled </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Shippable (OM) Optional </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">OE Transactable (OM) Enabled </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">All Drop Ship items must be defined in the organization entered in the profile option OE: Item Validation Organization and in the Receiving Organization. </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">All Drop Ship sub-inventory must have Reservable box checked. If the sub-inventory is not Reservable the Sales Order issue transaction will not be created in MTL_TRANSACTIONS_INTERFACE. After Drop Ship inventory organization is created, subinventories should be defined. To create the subinventory, go to an inventory responsibility and navigate to Setup -> Organizations -> Subinventories. Asset subinventories must have the reservable and Asset boxes checked. Expense subinventories must have the Reservable box checked and the Asset box unchecked. </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Subinventory Attributes for Asset Subinventory </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Reservable/Allow Reservations </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Asset Subinventory </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Subinventory Attributes for Expense Subinventory </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Reservable </span><br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Asset-must NOT be enabled. </span><br />
<span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;"><br /></span>
<strong style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Q4. How can we avoid the miscounting of supply as logical organization is involved?<br /><br />A: </strong><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">You must receive drop-ship items in a logical organization. If you use Oracle master Scheduling/MRP and Oracle Supply Chain Planning, to avoid miscounting supply you may not want to include logical organizations in your planning. If you choose to include logical organizations, ensure that doing so does not cause planning and forecasting complications.</span><br />
<span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;"><br /></span>
<strong style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Q5. If you make changes to a Sales Order after the Purchase Order (PO) has been generated, will the order changes automatically be updated on the PO?<br /><br />A: </strong><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Order changes will not be automatically updated on the PO. Pulling up the Discrepancy report will allow you to view the differences between the Sales Order and PO. However, you will have to manually update the POs in the Purchasing application. Please note: Sales Order changes will be automatically updated on the PO if the PO Status is Incomplete or Require Re-approval. If the PO is already approved, you cannot make changes to the Sales Order line (without un-approving the PO).</span><br />
<span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;"><br /></span>
<strong style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Q6. If items on a Drop Ship order are cancelled, does the system automatically generate a PO Change to the PO originally sent to the supplier?<br /><br />A: </strong><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">No, Drop Ship functionality in this regard remains the same as in R11. There is a discrepancy report available that will report differences between the PO and the Sales Order.</span><br />
<span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;"><br /></span>
<strong style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Q7. Does Order Management 11i have functionality to do serial number management with Drop Shipments?<br /><br />A: </strong><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">You are able to receive serial numbered Drop Ship stock. Order Management will receive the serial number noted on the PO.</span><br />
<span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;"><br /></span>
<strong style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Q8. Can Configurable Items be Drop Shipped?<br /><br />A: </strong><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Currently only Standard Items can be Drop Shipped. Functionality for Configurable Items will be added in future releases.</span><br />
<span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;"><br /></span>
<strong style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Q9. How do I Drop Ship across operating units?<br /><br />A: </strong><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Release 11i does not currently support this functionality.</span><br />
<span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;"><br /></span>
<strong style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Q10. How are over/under shipments handled in Drop Shipment?<br /><br />A: </strong><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">If part of a drop-ship line ships, and you do not wish to fulfill the remaining quantity, cancel the line. Over shipments must also be handled manually. If the supplier ships more than the ordered quantity, you can bill your customer for the additional quantity or request that they return the item. Use the Drop Ship Order Discrepancy Report to view differences between your drop-ship Sales Orders and their associated purchase requisitions and orders.</span><br />
<span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;"><br /></span>
<strong style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Q11. Will Blanket PO's work with Drop Shipment?<br /><br />A: </strong><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">Blanket PO's will not work with Drop Shipment because the PO must be created when OM notifies PO that a Drop Ship order has been created. This PO is linked to the Drop Ship order so that when the receipt is done (partial or complete) .OM is updated to receiving interface eligible. Drop Ship lines do not use the pick release, ship confirm or inv interface order cycles.</span><br />
<span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;"><br /></span>
<div align="left" style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">
<strong>Q12. Is it possible to create releases based on drop shipment orders for the items in the blanket agreement when a valid Blanket PO is created ?<br /><br />A: </strong>Yes, it is possible to create releases from drop ship orders automatically or via Autocreate window, if the drop ship Requisition has the correct Blanket Information (Source)<br /><br />1.Set up the ASL entry for the supplier site desired.<br />2.Depending on the hierachy determine which assignment better suits and define sourcing rule according to the required level with the required supplier,site. </div>
<div align="left" style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">
Also ensure that ASL entry exists for the above supplier/site.</div>
<div align="left" style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">
For automatic sourcing to be done also set profile 'PO:Allow Automatic Sourcing' to Yes so that the source document will be determined automatically depending on the creation dates and the type of the document.</div>
<div align="left" style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">
<br /></div>
<div align="left" style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">
<strong>Q13. Can we cancel Drop Shipment after it is received?<br /><br />A: </strong>Drop Shipments cannot be cancelled once Oracle Purchasing obtains the receipt. A user who wants to cancel a Drop Ship Sales Order line must ensure no receipts have been created against the line and that the requisition and/or Purchase Order associated with the line is cancelled. Cancellation of a Partial Drop Ship receipt is allowable. But only the portion that has not been received can be cancelled. If you cancel a Drop Shipment line for which you have not shipped the entire quantity, the order processing splits the line. The first line contains the quantity shipped and the second line contains the non-shipped quantity in backorder. You can cancel the second line the backorder on the Sales Order. The PO line quantity should be changed to reflect the new quantity.</div>
<div align="left" style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">
<br /></div>
<div align="left" style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">
<strong>Q14. What debugging tools are available for Drop Shipments?<br /><br />A: </strong>1. Note 133464.1 contains a diagnostic script that can be used for troubleshooting problems with Sales Orders.<br />2. Debugging receipt transaction or the Sales Order issue transaction, Set the following profile options:<br />RCV: Processing Mode to Immediate or Batch<br />RCV: Debug Mode to Yes<br />OM: Debug Level to 5<br />INV: Debug Trace to Yes<br />INV: Debug level to 10<br />TP: INV Transaction processing mode to Background<br />-Then go to Sys Admin: Concurrent: Program: Define; query up the Receiving Transaction Processor and check the Enable Trace box.<br />-Save the receipt for the deliver transaction (destination type will say Inventory for the deliver transaction).<br />-View the Receiving Transaction Processor log file, the Inventory Transaction Worker log file, as well as, the trace for the errors.</div>
<div align="left" style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">
<br /></div>
<div align="left" style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">
<strong>Q15. What is the Import source and status of PO generated from Drop Shipment?<br /><br />A: </strong>Import source is Order Entry.<br />Status of PO will always be Approved.</div>
<div align="left" style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">
<br /></div>
<div align="left" style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">
<strong>Q16. Can we receive a PO Shipment for which the related Sales Order Line is Cancelled / Closed?<br /><br />A: </strong>PO Shipments for which the relates Sales Order line has been cancelled or closed cannot be received. The PO shipment should be cancelled. A new Sales Order Line should be created, if needed. </div>
<div align="left" style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">
<br /></div>
<div align="left" style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">
Thanks & Regards,</div>
<div align="left" style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif;">
S.Grace Paul Regan</div>
</div>
S.Grace Paul Reganhttp://www.blogger.com/profile/08467360023113459306noreply@blogger.com3tag:blogger.com,1999:blog-5234259174543367247.post-41690281851325072102013-11-22T23:39:00.001-08:002013-11-22T23:41:33.941-08:00COGS/ Deferred COGS common problems<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<table border="0" cellpadding="0" cellspacing="0" style="background-color: white; color: #333333; font-family: Tahoma, Verdana, Helvetica, sans-serif; table-layout: fixed;" summary=""><tbody>
<tr><td valign="top"><div id="pt1:psl1::c" style="overflow: hidden;">
<div class="xpg" id="pt1:r1">
<div class="x1a" id="pt1:r1:0:docMainPanel">
<div class="p_AFHoverTarget xpj xpf" id="pt1:r1:0:psl1" style="box-sizing: border-box; height: auto; margin-left: 0px; margin-right: 0px; overflow: visible; position: static; width: auto;">
<div id="pt1:r1:0:psl1::t" style="overflow: hidden; position: relative; width: 1401px;">
<div class="x1a" id="pt1:r1:0:pgl14">
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><b>No Accounting for COGS Recognition Transaction</b></span></div>
</div>
</div>
<div style="overflow: hidden;">
<div id="pt1:r1:0:psl1::c" style="overflow: hidden;">
<div class="xpj x1a" id="pt1:r1:0:kmDocPanel" style="box-sizing: border-box; height: 5944.046875px; margin-left: 0px; margin-right: 0px; overflow: auto; width: 1401px;">
<span id="pt1:r1:ot71" style="color: black;"><br />Symptom:-<br />COGS Recognition Transaction does not have accounting in MTA table. (costed_flag is NULL)<br /><br />Explanation:-<br /><br />If quantity or cost of the item is zero, then COGS Recognition transaction does not have any accounting.<br /><br />According to the standard functionality,<br />When the transaction value is zero no accounting will be created.<br />COGS recognition is like redistributing expense across DCOGS and COGS. If there is no expense to be distributed at all (zero cost), creating zero dummy accounting entries among two expense accounts would be a waste and hurting performance unnecessarily as well.<br />So if the item is having zero cost then COGS journals will not be populated.<br />
Use below queries for verification:<br /><br />1.<br />
</span><br />
<div class="kmcodeblock" style="background-color: #e0eaf1; border: 1px solid rgb(196, 209, 230); font-family: 'Courier New', Courier, monospace; font-size: 12px; margin: 5px 0px 0px; overflow: auto; padding: 0.5em; width: 1330.9375px;">
<span id="pt1:r1:ot71" style="color: black; font-size: small;">Select *</span><br />
<span id="pt1:r1:ot71" style="color: black; font-size: small;">from cst_revenue_cogs_match_lines</span><br />
<span id="pt1:r1:ot71" style="color: black; font-size: small;">Where cogs_om_line_id=&om_line_id;</span><br />
<span id="pt1:r1:ot71" style="color: black; font-size: small;">check: Column = Unit_cost</span></div>
<span id="pt1:r1:ot71" style="color: black;">
<br /><br />2.<br />
<div class="kmcodeblock" style="background-color: #e0eaf1; border: 1px solid rgb(196, 209, 230); font-family: 'Courier New', Courier, monospace; margin: 5px 0px 0px; overflow: auto; padding: 0.5em; width: 1330.9375px;">
Select *<br />
from cst_cogs_events<br />
Where cogs_om_line_id=&om_line_id;</div>
<br /><br />Here refer cogs lines (i.e., event_type = 3 ) quantity i.e., event_quantity.<br />To get sales order line id use below query<br />
<div class="kmcodeblock" style="background-color: #e0eaf1; border: 1px solid rgb(196, 209, 230); font-family: 'Courier New', Courier, monospace; margin: 5px 0px 0px; overflow: auto; padding: 0.5em; width: 1330.9375px;">
Select trx_source_line_id "om_line_id"<br />
from mtl_material_transactions<br />
Where transaction_id=&transaction_id;</div>
/* Use COGS Recognition or SO Issue transaction */<br />
<br />
<h3 class="km" style="color: #333333; font-family: Arial, Helvetica, sans-serif; padding-top: 0.5em;">
Subledger Period close Exception report</h3>
<br />Symptom:-<br />Subledger Period close exception report shows unprocessed COGS recognition events.<br /><br />Explanation:-<br />If COGS Recognition transaction has zero quantity or zero cost, MTA does not exists but XLA_events data exists.<br /><br />This issue is fixed in COGs code, but if ct. has older version then ct. has to apply datafix.<br />Review Note 738529.1 for more detail<br /><br />For root cause fix, apply latest patch on CSTRCMVB.pls file.<br />
<h3 class="km" style="color: #333333; font-family: Arial, Helvetica, sans-serif; padding-top: 0.5em;">
COGS Recognition Transaction with 0 quantity</h3>
<br />Symptom:-<br />Sales Order Line has non-zero quantity but COGS is showing zero quantity.<br /><br />Explanation:-<br />If RMA exists before COGS Recognition then<br />COGS Recognition transaction quantity = Sales Order issue quantity - RMA quantity.<br /><br />Verify the data in CST_COGS_EVENTS table<br />
<div class="kmcodeblock" style="background-color: #e0eaf1; border: 1px solid rgb(196, 209, 230); font-family: 'Courier New', Courier, monospace; margin: 5px 0px 0px; overflow: auto; padding: 0.5em; width: 1330.9375px;">
Select *<br />
from cst_cogs_events<br />
Where cogs_om_line_id= &om_line_id;</div>
<br /><br />Note:-<br />Event_type = 1 (Sales Order Issue)<br />= 3 (COGs Recognition)<br />= 2 & 6 (RMA)<br />
<h3 class="km" style="color: #333333; font-family: Arial, Helvetica, sans-serif; padding-top: 0.5em;">
RMA Accounting</h3>
<br />Symptom:-<br />RMA accounting hits COGS some times and hits DCOGS sometimes.<br /><br />Explanation:-<br />This depends on when RMA is created i.e., before COGS Recognition or<br />after COGS Recognition.<br /><br />If RMA is created before COGS Recognition then RMA hits DCOGS account.<br /><br />If RMA is created after complete COGS Recognition then RMA hits COGS account.<br />Partial COGS Recognition then RMA hits both COGS & DCOGs accounts based on COGs recognition percentage.<br /><br />Refer to<br />Oracle Cost Manager User Guide - Revenue and COGS Matching chapter - Supported Business Scenarios<br /><br /><br /><span id="form1:panelPage1">Scenarios of DCOGS account:<br /><br />Case 1:<br />Transaction Type Debit Credit<br />================= ===== <br />Sales Order Issue DCOGS INV<br />COGS Recognition COGS DCOGS<br />DCOGS balance will be cleared after COGS Recognition.<br /><br />Case 2:<br />Transaction Type Debit Credit<br />================= ===== <br />Sales Order Issue DCOGS INV<br />RMA(Before COGS Rec.) INV DCOGS<br />DCOGS balance will be cleared after RMA.<br /><br />Case 3:<br />Transaction Type Debit Credit<br />================= ===== <br />Sales Order Issue DCOGS INV<br />COGS Recognition COGS DCOGS<br />RMA(After COGS Rec.) INV COGS<br />DCOGS balance will be cleared after COGS Recognition.</span><br /><br /><br /><br />Queries<br />
<div class="kmcodeblock" style="background-color: #e0eaf1; border: 1px solid rgb(196, 209, 230); font-family: 'Courier New', Courier, monospace; margin: 5px 0px 0px; overflow: auto; padding: 0.5em; width: 1330.9375px;">
select trx_source_line_id "rma_line_id"<br />
from mtl_material_transactions<br />
where transaction_id=&transaction_id;</div>
/* Use RMA Receipt */<br />
<div class="kmcodeblock" style="background-color: #e0eaf1; border: 1px solid rgb(196, 209, 230); font-family: 'Courier New', Courier, monospace; margin: 5px 0px 0px; overflow: auto; padding: 0.5em; width: 1330.9375px;">
select reference_line_id "om_line_id"<br />
from oe_order_lines_all<br />
where line_id=&rma_line_id;</div>
<br />
<div class="kmcodeblock" style="background-color: #e0eaf1; border: 1px solid rgb(196, 209, 230); font-family: 'Courier New', Courier, monospace; margin: 5px 0px 0px; overflow: auto; padding: 0.5em; width: 1330.9375px;">
select * from cst_cogs_events<br />
where cogs_om_line_id=&om_line_id;</div>
<br /><br />Note:-<br />If RMA is not referring to any Sales Order, then RMA accounting hits only COGS account.<br />
<h3 class="km" style="color: #333333; font-family: Arial, Helvetica, sans-serif; padding-top: 0.5em;">
Duplicate accounting</h3>
<br />Symptom:-<br />Duplicate accounting for COGS Recognition transactions.<br /><br />Explanation:-<br />This happens when Cost manager and Generate COGS Recognition events programs run in parallel.<br />Issue has been fixed and latest patch is recommended for root cause fix.<br />For old data, ct. has to do manual GL adjustments.<br /><br />Queries-<br />
<div class="kmcodeblock" style="background-color: #e0eaf1; border: 1px solid rgb(196, 209, 230); font-family: 'Courier New', Courier, monospace; margin: 5px 0px 0px; overflow: auto; padding: 0.5em; width: 1330.9375px;">
SELECT 3/4*SUM(NVL(ln.accounted_dr,0)-NVL(ln.accounted_cr,0)) ,<br />
ln.accounting_class_code ,<br />
ln.code_Combination_id<br />
FROM<br />
(SELECT mmt.transaction_id ,<br />
COUNT(mta.inv_sub_ledger_id) ,<br />
SUM(mta.base_transaction_value)<br />
FROM apps.mtl_material_transactions mmt ,<br />
apps.mtl_transaction_accounts mta<br />
WHERE mmt.organization_id = &org_id<br />
AND mmt.transaction_type_id = 10008<br />
AND mmt.transaction_date BETWEEN to_date('&from_date','DD-MM-YYYY') AND to_date('&to_date','DD-MM-YYYY') + .99999<br />
AND mmt.transaction_id = mta.transaction_id<br />
AND mta.accounting_line_type = 36<br />
AND mta.cost_element_id =1<br />
GROUP BY mmt.transaction_id<br />
HAVING COUNT(mta.inv_sub_ledger_id) > 1<br />
) list ,<br />
xla_transaction_entities_upg xte ,<br />
xla_events xe ,<br />
xla_ae_headers hr ,<br />
xla_ae_lines ln<br />
WHERE xte.ledger_id = &ledger_id<br />
AND xte.application_id = 707<br />
AND xte.entity_code = 'MTL_ACCOUNTING_EVENTS'<br />
AND NVL(xte.source_id_int_1, -9999) = list.transaction_id<br />
AND xe.application_id = 707<br />
AND xte.entity_id = xe.entity_id<br />
AND hr.application_id = 707<br />
AND ln.application_id = 707<br />
AND hr.event_id = xe.event_id<br />
AND hr.ledger_id = xte.ledger_id<br />
AND hr.ae_header_id = ln.ae_header_id<br />
GROUP BY ln.accounting_class_code ,<br />
ln.code_Combination_id;</div>
<br /><br />Note:-<br />Accounting is duplicated 2 times in MTA and 4 times in XLA tables.<br /><br />Also review <doc 1103513.1="" id=""> DUPLICATE COGS RECOGNITIONS TRANSACTIONS</doc><br />
<h3 class="km" style="color: #333333; font-family: Arial, Helvetica, sans-serif; padding-top: 0.5em;">
DCOGS account is not zero</h3>
<br />Symptom:-<br />Amount exists in DCOGS.<br /><br />Explanation:-<br />Get the output of COGS queries and also output of COGS Revenue Matching Report.<br /><br />Take sample Sales Order/Sales Order Line.<br />Check whether COGS is not recognized. If COGS event/transaction is not created, please check whether revenue information exists in CRRL table or not.<br />If CRRL data does not exist, verify revenue recognition. If not done, do revenue recognition and then run Collect Revenue Recognition Information & Generate COGS Recognition Events programs.<br />If COGS event/transaction exists but still having balance then check whether COGS is recognized fully or not. Also verify whether cogs event/transaction is costed or not<br /><br /><img height="435" src="https://support.oracle.com/epmos/main/downloadattachmentprocessor?attachid=1314335.1:DCOGSFlowchart&clickstream=no" width="640" /><br />
<h3 class="km" style="color: #333333; font-family: Arial, Helvetica, sans-serif; padding-top: 0.5em;">
7] COGS Revenue Matching Report</h3>
<br />Symptom:-<br />a. COGS Revenue Matching Report Performance issue.<br />b. Displaying rows even though cogs & revenue are matching.<br />c. Not displaying quantity correctly.<br />d. RMA accounting does not have credit lines.<br /><br /><br />Explanation:-<br />
<br />
<span style="background-color: #fff9d7;">Apply latest patch.</span><br /><br /><span style="background-color: #fff9d7;">R12 =</span><span style="background-color: #fff9d7;"> </span><a href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=13437574" target="_blank">Patch 13437574</a><span style="background-color: #fff9d7;">:R12.BOM.A to update file to latest version CSTRCMVB.pls 120.37.12000000.51 or higher</span><br /><br /><span style="background-color: #fff9d7;">12.1 =</span><span style="background-color: #fff9d7;"> </span><a href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=13948107" target="_blank">Patch 13948107</a><span style="background-color: #fff9d7;">:R12.BOM.C file version CSTRCMVB.pls 120.45.12010000.63 or higher</span><br />
<br />8. <span id="form1:panelPage1">In order to recognize revenue for the Cost of Goods Sold and Deferred Cost of Goods Sold, the following steps need to be performed:<br /><br />Run these AR steps:<br />Run autoinvoice and generate the invoice transaction.<br />Run Revenue Recognition Master Program and generate the AR revenue recognition<br /><br />Then the remaining steps:<br /><br />Record Order Management Transactions<br />Collect Revenue Recognition Information<br />Generate COGS Recognition Events<br /><br />----------------------<br />A) Once Invoice is created,<br /> Recognize the revenue in AR ><br /> Navigate to : Accounts Receivables>Control>Run Revenue Recognition request<br /><br />B) After recognizing the revenue, accept it.<br /> Navigate to : Accounts Receivables>Control>Revenue Accounting>Enter reference number: SO (ie.SO Number)Manage Revenue>Schedule Revenue<br /><br />C) Run a set of concurrent processes to record sales order and revenue recognition transactions and to create and cost COGS recognition transactions.<br /> These COGS recognition transactions adjust deferred and earned COGS in an amount that synchronizes the % of earned COGS to earned revenue on sales<br /> order shipment lines.<br /><br /> 1. Record Order Management Transactions: records new sales order transaction<br /> activity such as shipments and RMA returns in Oracle Order Management.<br /><br /> 2. Collect Revenue Recognition Information: determines the percentage of recognized or earned revenue related to invoiced sales order shipment lines<br /> in Oracle Receivables.<br /><br /> 3. Generate COGS Recognition Events: creates and costs COGS recognition events for new sales order shipments/returns and changes in revenue<br /> recognition and credits for invoiced sales order shipment lines.<br /><br /> 4. When querying for COGS Recognition Transactions :<br /> a. Navigate to Inventory > Transactions > Material Transactions<br /> b. Select the 'Include Logical Transactions' checkbox in the Find Material Transactions Form when running your query and the query will return 3 transaction types:<br /> 1) Sales Order Pick<br /> 2) Sales Order Issue<br /> 3) COGS Recognition<br /> c. While on the Sales Order Issue transaction line, select the Distributions button. Distributions are shown for Inventory Valuation and Deferred Cost of Goods Sold.<br /> d. While on the COGS Recognition transaction line, select the Distributions button. Distributions are shown for Deferred COGS and COGS. - Cost > View Transactions > Material Transactions<br /><br /> -- Please ensure all the steps are performed and check to see whether COGS Recognition transactions are generated. </span><span id="form1:panelPage1">If you forgot to run COGS Recognition processes and INV and GL periods are closed, the COGS Recognition would go to the next open period .</span><br />
<br />
The above details are posted from the Oracle Support Document (<span style="text-align: right;">Doc ID 1314335.1)</span>, People having access to Oracle Support can refer the Original document from metalink.<br />
<br />
Thanks & Regards,<br />
S.Grace Paul Regan<br />
+965-97100377</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</td></tr>
</tbody></table>
</div>
S.Grace Paul Reganhttp://www.blogger.com/profile/08467360023113459306noreply@blogger.com1tag:blogger.com,1999:blog-5234259174543367247.post-89676688564352300552013-11-22T23:31:00.000-08:002013-11-22T23:42:37.299-08:00Deferred COGS Accounting in R12<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white; color: #333333; line-height: 18px; text-align: justify;">The deferred COGS of goods account is the new feature introduced in Release 12. The basic fundamental behind the enhancement is that the COGS is now directly matched to the Revenue. The same was not possible till now.</span><br style="color: #333333; line-height: 18px; text-align: justify;" /><br style="color: #333333; line-height: 18px; text-align: justify;" /><span style="background-color: white; color: #333333; line-height: 18px; text-align: justify;">Prior to this enhancement, the value of goods shipped from inventory were expensed to COGS upon ship confirm, despite the fact that revenue may not yet have been earned on that shipment. With this enhancement, the value of goods shipped from inventory will be put in a Deferred COGS account.</span><span style="background-color: white; color: #333333; line-height: 18px; text-align: justify;"> As percentages of Revenue are recognized, a matching percentage of the value of goods shipped from inventory will be moved from the Deferred COGS account to the COGS account, thus synchronizing</span><br style="color: #333333; line-height: 18px; text-align: justify;" /><span style="background-color: white; color: #333333; line-height: 18px; text-align: justify;">the recognition of revenue and COGS in accordance with the recommendations of generally accepted accounting principles.</span><br style="color: #333333; line-height: 18px; text-align: justify;" /><br style="color: #333333; line-height: 18px; text-align: justify;" /><span style="background-color: white; color: #333333; line-height: 18px; text-align: justify;">The Matching Principle is a fundamental accounting directive that mandates that revenue and its associated cost of goods sold must be recognized in the same accounting period. This enhancement will automate the matching of Cost of Goods Sold (COGS) for a sales order line to the revenue that is billed for that sales order line.</span><br style="color: #333333; line-height: 18px; text-align: justify;" /><br style="color: #333333; line-height: 18px; text-align: justify;" /><span style="background-color: white; color: #333333; line-height: 18px; text-align: justify;">The deferral of COGS applies to sales orders of both non-configurable and configurable items (Pick-To-Order and Assemble-To-Order). It applies to sales orders from the customer facing operating units in the case of drop shipments when the new accounting flow introduced in 11.5.10 is used. And finally, it also applies to RMAs that references a sales order whose COGS was deferred. Such RMAs will be accounted using the original sales order cost in such a way that it will maintain the latest known COGS recognition percentage. If RMAs are tied to a sales order, RMAs will be accounted for such that the distribution of credits between deferred COGS and actual COGS will maintain the existing proportion that Costing is aware of. If RMAs are not tied to a sales order, there is no deferred COGS.</span></span><br />
<span style="background-color: white; color: #333333; line-height: 18px; text-align: justify;"><span style="font-family: Verdana, sans-serif;"><br /></span></span>
<span style="font-family: Verdana, sans-serif;"><b>Set Up Accounting: </b></span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<br />
<div style="background-color: white; color: #333333; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: Verdana, sans-serif;">To set the deferred COGS account.<br /><br />Inventory -- Setup -- Organization -- Parameters -- Other Accounts<br />A new account is added which is referred as the Deferred COGS accounts. </span></div>
<div style="background-color: white; color: #333333; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: Verdana, sans-serif;">Please note that when upgrading from a pre R12 version the DEFERRED_COGS_ACCOUNT will be populated if it is null with the cost_of_goods_sold_account on the organization parameter. This can then be changed accordingly if a different account is required.<br /><br /><span style="text-decoration: underline;"><strong>NEW ACCOUNTING :</strong></span><br /><br /><strong>Release 12 : </strong><br />When a Sales order is shipped the following accounting takes place:<br /><br />Inventory Valuation Account : Credit.<br /> Deferred COGS account : Debit<br /><br />Once the revenue is recognised, you would need to decide the percentage you wish to recognize the Revenue. A COGS recognition transaction will be created to reflect a change in the revenue recognition percentage for a sales order line.<br /><br />The steps to generate such transactions are as follows:<br />1. Run the Collect Revenue Recognition Information program. This program will collect the change in revenue recognition percentage based on AR events within the user specified date range.<br />2. Run the Generate COGS Recognition Events. This program will create the COGS recognition transaction for each sales order line where there is a mismatch between the latest revenue recognition percentage and the current COGS recognition percentage.<br /><br />Note that users can choose how often they want to create the COGS Recognition Events.<br /><br />Navigation to run the COGS recognition request :<br />- Cost > COGS Recognition > Collect Revenue Recognition Information<br />- Cost > COGS Recognition > Generate COGS Recognition Events<br />- Cost > View Transactions > Material Transactions<br /><br /><br />The distribution for the COGS Recognition transaction associated with the Sales Order transaction now would be as follows:<br /><br /> Deferred COGS : Debit revenue percentage<br /> COGS : Credit (Actual revenue percentage )<br /><br />Thus, essentially the recognized COGS balance is to move the value from Deferred COGS to COGS.<br /><br />This particular COGS recognition transaction actually correspond to a revenue recognition percentage change.<br /><br />You can view the transactions as :<br />Navigation:<br />- Cost > View Transactions > Material Transactions > Distributions<br /><br />A new COGS Revenue Matching Report shows the revenue and COGS information of sales order that fall within the user specified date range by sales order line<br /><br /><br /><span style="text-decoration: underline;"><strong>SIMPLER TERMS ( Table level details ) : </strong></span><br />Once the whole cycle is complete we will have 2 transactions lines in mtl_material_transactions.<br /><br />1. Sales Order<br />2. COGS Recognition transaction<br /><br />Accounting will be in mtl_transaction_accounts and the Subledger accounting tables as follows:<br /><br />Transaction 1:<br />Inventory Valuation Account : Credit. (item_cost)<br /> Deferred COGS account : Debit (item_cost) </span></div>
<div style="background-color: white; color: #333333; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: Verdana, sans-serif;">Transaction 2:<br />Deferred COGS : Credit (Actual revenue percentage)<br /> COGS : Debit (Actual revenue percentage ) </span></div>
<div style="background-color: white; color: #333333; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div style="background-color: white; color: #333333; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: Verdana, sans-serif;">Thanks & Regards,</span></div>
<div style="background-color: white; color: #333333; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: Verdana, sans-serif;">S.Grace Paul Regan</span></div>
<div style="background-color: white; color: #333333; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<br /></div>
</div>
S.Grace Paul Reganhttp://www.blogger.com/profile/08467360023113459306noreply@blogger.com7tag:blogger.com,1999:blog-5234259174543367247.post-47724191432011686652011-03-24T04:46:00.000-07:002011-03-24T04:49:47.693-07:00OM White Papers<div dir="ltr" style="text-align: left;" trbidi="on"><strong><a href="https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=WHITE%20PAPER&id=113492.1"><span style="background-color: #f3f3f3; color: #e06666;">Oracle Order Management Suite White Papers</span></a> - Set of white paper's which will address most of the Order Management Process. You should be having metalink access in order to download these docs.</strong><br />
<br />
Thanks & Regards,<br />
S.Grace Paul Regan<br />
<br />
<br />
</div>S.Grace Paul Reganhttp://www.blogger.com/profile/08467360023113459306noreply@blogger.com3tag:blogger.com,1999:blog-5234259174543367247.post-19389286086174819712008-04-07T22:33:00.000-07:002008-04-07T22:48:13.479-07:00Overview of Order Management in the Order to Cash ProcessOrder Management receives detailed item information from the Inventory application and price list information from the Pricing application. Orders and returns can be entered manually or imported through an EDI, CRM, or external source. Once in the system the order is ready to be pick released and shipped, if needed by the Shipping application. It can then proceed through the AutoInvoice program into the Oracle Receivables application to be invoiced. All of the accounting information is transferred to the General Ledger by the Inventory and Receivables applications.<br />Thanks & Regards,<br />S.Grace Paul ReganS.Grace Paul Reganhttp://www.blogger.com/profile/08467360023113459306noreply@blogger.com1tag:blogger.com,1999:blog-5234259174543367247.post-35408023181994693692008-04-07T21:55:00.000-07:002008-05-01T21:55:15.760-07:00Order to Cash Life Cycle1--------Enter the Order----- Book-----------Pick Release-------------Ship Confirm----------2 2------- Auto Invoice----------Receivables-----------Invoice------------Receipt------------3-3--------Bank Reconciliation--------3<br /><strong>Inventory:</strong><br />1. Create Unit of Measure<br />2. Create a Location<br />3. Create an Inventory Organization<br />4. Create a SubInventory<br /><strong>Enter Items:</strong><br />5. Define Shipping Parameters<br />6. Create an Item<br />7. Create a Material Transaction<br />8. Add an Item to a Price List<br />Manage Parties and Customer Accounts:<br />9. Create customer Profile Class<br />10. Create Customer<br />11. Create a Customer Account<br /><strong>Enter Order:</strong><br />12. Create a Sales Order<br />13. Create a Sales Line<br />14. Create a Split line and Ship Set<br />15. Schedule an Order<br />16. Book an Order<br />17. Pick Release<br />18. Ship ConfirmProcess<br /><strong>Invoices:</strong><br />19. Create an Invoice<br />20. Process Invoices Using AutoInvoice<br />21. Enter a Manual Receipt<br />22. Apply a Receipt<br /><br /><strong>Scheduling:</strong> Scheduling provides approximate ship date based on ATP (On-hand, expected supply and demand). Scheduling sets Schedule ship date and Arrival date ( for this Inter location transit time to be set).<br />Passes the demand to inventory. (Item attribute OE translatable to be enabled).<br />S.O line demand consumes item’s forecast. Can place reservation if <span class="blsp-spelling-error" id="SPELLING_ERROR_0">SSD</span> is with in the value of OM: Reservation time fence If product is available on-hand then Schedule ship date = requested date. If the item is non-ATP, then schedule ship date = requested date<br />OM: Auto schedule- profile option for automatic <span class="blsp-spelling-error" id="SPELLING_ERROR_1">popup</span> of scheduling window.<br />In order line, Tools – Scheduling – schedule, reserve, unreserved, reservation details.<br />In order <span class="blsp-spelling-error" id="SPELLING_ERROR_2">TT</span>- Scheduling level can be given.<br />Concurrent “ Schedule Orders” <span class="blsp-spelling-corrected" id="SPELLING_ERROR_3">parameters</span> : order number, request date, <span class="blsp-spelling-error" id="SPELLING_ERROR_5">cust</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_6">po</span> no, ship to, customer, item.<br />OM: Schedule lines on hold- profile option to schedule hold lines.<br /><strong>OM: Scheduling role:<br /></strong><span class="blsp-spelling-error" id="SPELLING_ERROR_7">CSR</span> only – (Customer service representative) In order organizer, tab scheduling is gray out.<br /><span class="blsp-spelling-error" id="SPELLING_ERROR_8">CSR</span> and scheduling – In order organizer all tabs are enabled. If u click (T) scheduling, then rest all the tabs will be gray out and vice <span class="blsp-spelling-error" id="SPELLING_ERROR_9">versa</span>. Scheduling across orders is possible.<br />Scheduler only – only (T) scheduling is enabled.<br />Note: Concurrent “ Reserve orders” to reserve orders.<br />OM: Source code – defaults to Order entry, OM passed to inventory during scheduling.<br /><strong>Reservation:<br /></strong>Item attribute <span class="blsp-spelling-error" id="SPELLING_ERROR_10">reservable</span> must be enabled.<br />Reservation puts soft pegging with the inventory.<br />Item reservation is removed after ITS.<br /><strong>Dates on Order line:<br /></strong>a) Request date<br />b) Promise date<br />c) Scheduled ship date<br />d) Scheduled arrival date<br /><strong>Price in order lines:<br /></strong>a) unit price/selling price - Price of each qty<br />b) extended price /line price – unit price x no of qty<br />c) List price – Price declared in price list<br />d) Modifiers – factors that change the list price.<br />e) Qualifiers – factors that qualifies the modifiers.<br />Order header: acts as primary source to lines, open until all lines are closed, Dependent of lines. They are <span class="blsp-spelling-error" id="SPELLING_ERROR_11">OU</span> specific.<br />Order lines: they are dependent on order header, multiple lines and org is possible. Lines takes precedence over header. They are org specific.<br /><strong>Order types:<br /></strong>a) BSA – Blanket sales agreement.<br />b) Sales order<br /><br />Sales person: who is getting credited for sale. This is mandatory field.<br /><br />Quota sales person – More than one sales person can be entered to divide the sales credit. Cumulative should be 100.<br />Non-Quota sales person – we can enter multiple sales person. But cumulative can be more than 100% <span class="blsp-spelling-error" id="SPELLING_ERROR_12">eg</span>: middlemen, agents.<br />Gross margin amount = Extended sales price – unit price. Gross margin hold can be set.<br /><br />Thanks & Regards,<br />S.Grace Paul Regan.S.Grace Paul Reganhttp://www.blogger.com/profile/08467360023113459306noreply@blogger.com4tag:blogger.com,1999:blog-5234259174543367247.post-84732329204018757092008-01-01T08:23:00.000-08:002008-04-21T08:52:50.378-07:00Enter Sales Order<strong>Prerequisites:</strong><br />1. Transaction Types have been defined.<br />2. Customers exist in the Customer Master, including Contacts, Addresses, and Location<br />Business Purposes.<br />3. Price Lists have been defined.<br />4. Items have been defined in the Item Master and assigned to Price Lists.<br />5. Discounts have been defined and assigned to Price Lists.<br />6. Salespersons have been set-up.<br />7. Tax Codes and Tax Rates have been defined.<br />8. Invoicing and Accounting Rules have been defined.<br />9. Freight Carriers, Freight Terms, and FOB options have been defined.<br />10. Shipping Warehouses have been set-up.<br />11. Agreements have been defined (if Agreements functionality is required).<br />12. ATP Rules have been defined (if ATP functionality is required).<br />13. System Types have been defined (if Systems functionality is required).<br /><br /><a name="_Toc493326728"><strong>Sales Orders Window</strong></a><br />The Sales Orders window allows you to enter orders and returns.<br />The Main Tab region of the Sales Orders Order Information, enter the following:<br /><strong>Customer:</strong><br />Enter Customer Name (Customer Number will default in). Customers must first be setup in the Customer Master. If a Customer has not yet been setup, then navigate to the Customer Master either by selecting Quick Customer Entry from the Tools menu or go to full customer entry in Customers > Standard from the Navigator.<br /><strong>Customer Number:</strong><br />Alternatively, enter Customer Number and the Customer Name will default in.<br /><strong>Order Type:</strong><br />Select the appropriate Order Type. Order Type determines the order workflow, accounting rules, and other characteristics of the order.<br /><strong>Customer PO:</strong><br />Enter the Customer Purchase Order Number. A customer purchase order number must be entered if the order type you specified requires a purchase order number. Oracle will give you a warning if the Customer Purchase Order Number has been previously used, but it will not prevent you from using a duplicate Customer Purchase Order Number.<br /><strong>Order Date:</strong><br />The Current Date will default in as the Order Date. You may change this date.<br /><strong>Contact:</strong><br />Enter a Customer contact (optional). Contacts must also first be setup in the Customer Master and then selected from the List of Values. If a Contact has not yet been setup, then navigate to the Customer Master as described above, create the Contact, and then return to the Sales Orders Order Information form to select the Contact in this field.<br />Order Number:<br />Oracle will assign the Sales Order Number as soon as the Sales Orders Order Information is saved.<br /><strong>Ship-To:</strong><br />Select the Ship-To customer information. Defaulting rules may allow you to default ship-to address information when choosing the order type.<br /><strong>Salesperson:</strong><br />Select a Salesperson from a List of Values. The Salesperson entered in the Sales Orders Order Information form will receive 100 percent of the sales credit for the order. Sales credits may be apportioned to multiple sales persons in the Sales Credit window.<br /><strong>Select Currency:</strong><br />Select a currency for the order. The currency selected must match the currency on your price list selected for this order.<br /><strong>Bill-To:</strong><br />Select the Bill-To customer information. Defaulting rules may allow you to default bill-to address information when choosing the order type.<br /><strong>Entry Status:</strong><br />The initial entry status for a sales order is Entered. After Booking the order, the status will change to Booked.<br /><strong>The Others Tab region of the Sales Orders Order Information, enter the following:</strong><a name="PricingAlternateRegion"></a><strong><br />Payment Terms:</strong><br />Payment Terms are user-definable and must be set-up in advance (Setup >Orders > Payment Terms). Again, you may override the default value in this field.<br /><strong>Sales Channel:</strong><br />Enter a Sales Channel. Sales Channels must be setup in advance in the Order Management Quick Codes and then may be selected from the List of Values.<br /><strong>Warehouse:</strong><br />Select a Warehouse (inventory organization) from which order line(s) will be shipped.<br /><strong>Shipping Method:</strong><br />Select the Shipping Method to use for shipments to your customer.<br /><strong>Line Set:</strong><br />Choose whether to ship lines as a group or to arrive as a group. All lines in the order that have the same ship set number will be shipped or arrive together. The lines must have the same warehouse, scheduled shipment date, ship-to location, shipment priority, and shipment method.<br /><strong>Freight Terms:</strong><br />Select the Freight Terms. Freight Terms are setup in advance using Order Management QuickCodes.<br /><strong>FOB:</strong><br />Select the FOB point.<br /><strong>Shipment Priority:</strong><br />Select a Shipment Priority. Shipment Priority may be used at Pick Release to prioritize picking. Additional shipment priorities can be defined in the Order Management Lookups window.<br /><strong>Shipping Instructions:</strong><br />Enter special instructions to the Shipping Organization (Optional). These instructions will appear on the Pick Slip only.<br /><strong>Packing Instructions:</strong><br />Enter special packing instructions. These instructions will appear on the Pack Slip.<br /><strong>Tax Handling:</strong><br />Select a Tax Handling Status. The default is Standard Tax Handling. For a tax-exempt customer, create the tax exemption in the Setup > Tax > Exemptions form.<br /><strong>Tax Exempt Number:</strong><br />If you select Exempt in the Tax Handling field, then you will need to select a Tax Exemption Certificate from the List of Values.<br /><strong>Exempt Reason:</strong><br />As with the Tax Exempt Number, if you select Exempt in the Tax Handling field, then you will need to select a Tax Exemption Reason from the List of Values. These must first be setup in the Setup > Tax > Exemptions form.<br /><strong>Payment Type:</strong><br /><strong>Agreement:</strong><br />If the flag Agreement Required is checked on this Order Type, then an Agreement is required. More typically, an Agreement is optional. A Customer Agreement may be used to attach specific Price Lists, Discounts, Payment Terms, Invoicing Rules, and Accounting Rules for sales orders for particular customers or groups of customers. See the Creating and Using Customer Agreements Training document for more information.<br /><strong>Currency:</strong><br />The base currency for this sales order.<br /><strong>Price List:</strong><br />The Price List used for this particular sales order. You may override the default in this field.<br /><strong>Invoicing Rule: </strong><br />Invoicing Rules must be set at the order Header level and will be applied to all Lines except for Service Lines. The two Invoicing Rules delivered with R2i are Advance Invoice (in which invoicing will take place at the beginning of an invoicing schedule) and Arrears Invoice (in which invoicing will take place at the end an on invoicing schedule).<br /><strong>Payment Terms:</strong><br />Payment Terms are user-definable and must be set-up in advance (Setup >Orders > Payment Terms). Again, you may override the default value in this field.<br /><strong>Payment Type:</strong><br /><p>Three Payment Types have been defined: Cash, Check, and Credit Card. If you enter Cash as the Payment Method, only the Amount field will be enabled in this region.<br />If you enter Check as the Payment Method, then the Amount and Check Number fields will be enabled.<br /><span style="font-size:85%;"><strong>If you enter Credit Card as the Payment Method, then the following fields will be enabled:</strong> </span></p><p>Amount, Credit Card Type, Credit Card Number, Card Holder, Expiration Date, and Approval Code. All fields allow free-form data entry except Credit Card which must be set-up with a List of Values in advance. R2i is delivered with the following Credit Cards defined: American Express, Discover, Mastercard, and Visa.<br /><strong>Order Source:</strong> </p><p>If this order is being imported form another source (i.e.is not being manually entered) that source will be identified in this field. This includes if the order is being copied from a previous order. </p><p></p><p></p><br /><p><a name="_Toc493326731"><strong>Line Items Tab</strong></a><br /><br />The Sales Orders Line Items Tab consists of the following tabs:<br />· Main<br />· Pricing<br />· Shipping<br />· Addresses<br />· Returns<br />· Services<br />· Other</p><p align="justify">In the Main Tab area of the Sales Order Line Item Information, enter the following:<br /><strong>Line Number:</strong> This will automatically default as 1.1 when the line information is first entered. If there are existing lines the line number will automatically increment by one. <br /><strong>Ordered Item:</strong>Enter the Ordered Item for this order line. Items must be setup in the Item Master and also on a Customer Price List before they may be selected in the Sales Order Line <strong>Item field.</strong> <br /><strong>Quantity:</strong>Enter the Quantity for this particular line item.<br /><strong>UOM:</strong>The Unit of Measure will default in form the Item definition. <br /><strong>Unit Selling Price:</strong>The Selling Price is the discounted price of the item. <br /><strong>Schedule Ship Date:</strong>Select the Schedule Ship Date from the calendar or use Scheduling functionality. See OM Schedule Order Training Documentation.<br /><strong>Line Type:</strong>Select or accept the default for Line Type. <br /><strong>Salesrep:</strong>Select or accept the default for Salesrep.<br /><strong>Tax Code:</strong>Select or accept the default for Tax Code.<br />In the Pricing Tab area of the Sales Order Line Item Information, enter the following:<br /><strong>Price List:</strong>Select a Price List for the order. The value for Price List will default from Sales Orders Order Information tab previously selected. <br /><strong>Unit Selling Price:</strong>Modify the Selling Price (Optional). The Extended Price will automatically default when the Unit Selling Price is updated. </p><p align="justify">In the Shipping Tab area of the Sales Order Line Item Information, enter the following:<br /> <strong>Warehouse:</strong>This is the default Shipping Warehouse for all sales orders line item information.<br /><strong>Receiving Org:</strong>Enter the Receiving Inventory Organization. Only applicable for Drop Ship Orders and Return Material Authorizations (RMAs). <br /><strong>Request Date:</strong>The Current Date defaults in as the Request Date. Change it to the date the Customer would like the Product Shipped.<br /><strong>Promise Date:</strong>The Current Date defaults in as the Promise Date. Change it to the date the Customer has been promised for shipment date.<br /><strong>Source Type:</strong>Enter the Source Type for the item being shipped. If the item is to drop shipped the Source Type will be external. Otherwise the Source Type will default as internal.<br /><strong>Shipping Instructions:</strong>Enter special instructions to the Shipping Organization (optional). These instructions will appear on the Pick Slip only.</p><p align="justify"><strong>Packing Instructions:</strong>Optionally enter special packing instructions. These instructions will appear on the Pack Slip.</p><p align="justify">In the Addresses Tab area of the Sales Order Line Item Information, enter the following:<br /><strong>Ship-to Location:</strong>The customer’s primary Ship-to Location will default in from the Customer Master.<br /><strong>Bill-to Location:</strong>The customer’s primary Bill-to Location will default in from the Customer Master.<br /><strong>Ship-to/Bill-to Contact:</strong> (Optional) These default in from the Customer data. If the required contact has not yet been set-up, then they will first need to be created in the Customer Master, and then may be selected from the List of Values on this form.<br />If the customer has not selected a Bill-to and/or a Ship-to address as primary, then you will need to manually select addresses in this form.<br />If the required address has not yet been set-up, then navigate to the Customer Master either by selecting Quick Customer Entry from the Tools menu or go to full customer entry in </p><p align="justify">Customers > Standard from the navigator.<br />The Ship-to/Bill-to Locations set at the Sales Orders Order Information will default to Line Item Information. You have the option to override the Ship-to Location for individual lines on the order. </p><p align="justify"><strong>Additional Line Information:</strong>Active when at the Sales Orders Line Information window displays Holds, Return Activity, Deliveries, Receivables, Internal Requisition, Drop Ship and Quantity History.</p><p align="justify"><a name="_Toc493326742"><strong>Booking the Order</strong></a><br />The final step in the Sales Order Entry process is to Book the order.<br />This signifies that the Order Entry process is complete and that the order is eligible for the next stage in the line flow for this order, as defined by its Transaction Type.<br />Select the Book Order button<br />The Entry Status of the Order will change to Booked.</p><p align="justify"><a name="_Toc493326744"><strong>Viewing Workflow Statuses and Processes</strong></a><br />The Sales Orders window displays the order header status in the Main tab of the Order Information tabbed region. The order line status is displayed in the Main tab of the Line Items tabbed region.<br />The Workflow Status option on the Sales Order window Tools menu launches the workflow status page. The window shows in tabular format all the activities an order header or line has completed and the corresponding results. See the OM Order and Line Workflow Overview document for further details on Order Management Workflows.</p><p align="justify"><a name="_Toc493326745"><strong>Close the Order</strong></a><br />Closing orders that are complete enhances performance, since many programs, windows and report queries retrieve open orders only. Orders marked as closed are not selected, increasing system speed and efficiency. Closed orders are excluded from many of the standard reports available in Order Management, so you can limit your reporting to the active orders.<br />Close lines and close orders are implemented using workflow. Order Management provides seeded close line and close order workflow sub-processes to close the order header and line, respectively. These processes, when included in the order header or line workflow, closes the status of the eligible order or lines. Once an order is closed, no lines can be added. The order header close order process checks at the end of every month to see all the lines associated with are closed. It closes the order header if it finds that all the lines are closed.<br />An order line is eligible to close when it completes all of the line-level activities within the workflow process. Order lines can close independent of each other. Once an order line is closed, no changes can be made to any fields except the descriptive flexfield, for which you can define processing constraints.<br /><strong>Note:</strong> Be sure to include the standard sub-processes of close line and close order at the end of all your line and order flows to ensure that your orders and returns close once all prerequisites have been met.</p><p align="justify">Thanks & Regards,</p><p align="justify">S.Grace Paul Regan.</p>S.Grace Paul Reganhttp://www.blogger.com/profile/08467360023113459306noreply@blogger.com6tag:blogger.com,1999:blog-5234259174543367247.post-12978891784674573622007-12-20T07:29:00.000-08:002009-02-20T07:41:51.276-08:00R-12 - Release Content Document (Order Management)<span style="font-size:130%;"><strong>Order Management</strong><br /></span><br /><strong>Overview</strong><br />========<br /><br />Oracle Order Management drives the order fulfillment process of any business. The open,workflow based architecture supports tailored, automated fulfillment processes withoutcustomization. It captures multi-channel demand from sources including EDI, XML,telesales or web storefronts. As part of a complete order to cash solution it enables global order promising integrated to shipment execution<br /><br /><br /><strong>Features</strong><br /><br /><strong>1. Multi-Organization Access Control</strong><br /><strong>2.Inventory Convergence</strong><br /><strong>3.Customer Acceptance</strong><br /><strong>4. Mass Scheduling</strong><br /><strong>5.Enhanced Header Attribute Cascading</strong><br /><strong>6.Exception Management Enhancements</strong><br /><strong>7.Workflow Validation Tool</strong><br /><strong>8.Credit Card Security Code</strong><br /><strong>9.Create Orders in Contact Center</strong><br /><strong>10.Payment Due With Order</strong><br /><strong>11.Recurring Charges</strong><br /><strong>12.Telecommunications Service Orders with Equipment</strong><br /><strong>13.Rosetta Native Message: PO Acknowledgements in Order Management</strong><br /><strong>14.Scheduling ATO Items without BOM</strong><br /><strong>15.Customer Credit Check Hold Source Support across Operating Units</strong><br /><strong>16.Renaming Blanket Sales Agreements to Sales Agreements</strong><br /><strong>17.Oracle Shipping Execution Changes</strong><br /><strong></strong><br />Thanks & Regards,<br />S.Grace Paul Regan<strong>.</strong>S.Grace Paul Reganhttp://www.blogger.com/profile/08467360023113459306noreply@blogger.com23