Oracle R12 Order Management and Purchase Orders Data Fix Patches and Scripts

Meta Link ID	General Issues
863761.1- FAQ: Troubleshooting Stuck Pick Release and Shipping Transactions 3-7610030631 : KPIT-CPG-MFGGPRD-APPSUP-APP-ONT:Pick Release Issue due to Trailing space in Customer PO.	PO Trail Issue at Ship Confirm
3-7640139111 :  Not able to deliever materials into WMS enabled org	user can't Deliver LPN, LPN Data Corruption,LPNs stuck in receipt due locked by user
3-8539618891 : KPIT-CPG-MFGGPRD-APPSUP-APP-AR: Duplicate 'Bill To' Business Purpose for same site under same OU	Duplicate Bill to Removed from Business Purpose
2-5844711 - Serial Numbers are not visible in LOV while delivering the Items in to Inventory	Serial Number Lock Release,
3-5290067251 - script to change normal price list to intercompany on	Change Normal Price List to Intercompany Price List
390023.1-How To Reset a Purchase Order or Requisition From In Process or Pre-Approved To Incomplete/Requires Reapproval For Isolated Cases	Unable to cancel the PO line
SR 3-6398139421 : KPIT-CGT-CGTSL2D-APPSUP-APP-ONT_Interface trip Stops complete with warning	Records Stucked in TOI :Missing Serial Numbers
SR 3-7640139111 : 17301980 Not able to deliever materials into WMS enabled org SR 3-8157707783 : ESC 17866820 Unable to perform Move Any LPN transaction for some LPN's	Unable to perform Move Any LPN transaction, LPN Data Corruption
181860.1- INVTVTMP - Deleting Pending Transactions In The MMTT Table For A Cancelled Sales Order	records got stuck in MTL_MATERIAL_TRANSACTIONS_TEMP
1322105.1- (Inventory Reservations Not Relieved for Closed or Canceled Sales Orders and Some are Orphaned: Clean up scripts for Releases 11i and 12) FAQ: Inventory Standard Datafixes (Doc ID 568012.1)	Orphan Reservation Removed from Sales Order reservations, Reservation Against Close Line
3-5458447411: KPAO_CTT_HSTPROD 11i: delivery is closed but lines are in Staged/Pick Confirmed status	delivery is closed but lines are in Staged/Pick Confirmed status
3-5822972041 : BUG 14221718: Receiving correction fails:WMSINB-19139: LPN validation failed	clear the stuck transactions from  transaction status summary
SR 3-5887368221 : Cannot Transact Move order for Sales order SR 3-6313389681 : 14781458 KPIT-CGT-CGTSL2D-APPSUP-APP-ONT- Not able to transact the Move order	records are stuck in pending transactions
SR 3-6932768371 : DF 16515563 : KPIT-CPG-MFGPRD-APPSUP-APP-OM-Not able to send the DSNO	ITS Completed in Warning, The delievry is interfaced, however the ASN for the delivery is failing.
3-6506739761 : DEV: KPIT-CTT-PROD-APPSUP-APP-ONT-Sale line Stuck in Awaiting Invoice Interface and shipped	sale order lines  are having the status as  "Awaiting Invoice Interface - Pending Complete Delivery status
390023.1  How To Reset a Purchase Order or Requisition From In Process or Pre-Approved To Incomplete/Requires Reapproval For Isolated Cases	Standard PO is  stucked in "In process"
SR 3-6697581611 : DEV:KPIT-CGT-CGTSL2D-APPSUP-APP-ONT- SO Header Closed but Sales Order Line in Supply eligible	Order Header status is closed but Order Line is still in 'Awaiting Shipping' status.
SR 3-6772561641 : DEV:KPIT-CPG-MFGGPRD-APPSUP-APP-ONT :Order lines cancelled but order header in booked status SR 3-7678777171 : DEV:KPIT-CPG-MFGGPRD-APPSUP-APP-ONT- Sales Order Can not Cancelled SR 3-8839049081 : 19011696 : Sales Order Header Booked status even after all lines are closed / canceled status.	Sales Order lines cancelled but order header in booked status
SR 3-5549583781 : KPAO_CPG_MFGGPRD: Order header BOOKED though all Lines are closed	Order header BOOKED though all Lines are closed,all sales order lines are in closed and cancelled status sales order header is not getting closed as sales order line workflow is stuck in suspended status
3-7678777171  DEV:KPIT-CPG-MFGGPRD-APPSUP-APP-ONT- Sales Order Can not Cancelled(Cancelled orders in Oracle show in booked status)	Cancelled orders in Oracle show in booked status, Change Sales Order Header Status
SR 3-6469784481 : Uncosted material transaction	Transactions stuck in pending transactions with error "CST_MATCH_DATE_PERIOD"
3-6734771651-Order shipped but no invoice generated as the line is in pending approval status	ORDER INVOICED BUT NO INVOICE NUMBER PRODUCED
SR 3-6560586641 : 16059492: KPIT-CGT-CGTSL2D-APPSUP-APP-APS-Drop ship qty still reflecting in On-Hand	script to remove the orphan serial interface records
SR 3-6077927691 : KPAM-CPG-MFGGPRD Unable to Process Serialised Transactions (WIP, Shipping etc).	record is stuck in TOI with error -Serial Records are missing
3-6579847231 : KPIT-FSB-FSGNAPRD-APPSUP-APP-ONT - Need to remove line from Shipping Transaction Form	Need to remove line from Shipping Transaction Form
SR 3-6536583911 : 21:KPIT-CTT-PROD-APPSUP-APP-ONT-Line closed but actual shipment date not updated on sales order line	Line closed but actual shipment date not updated on sales order line
SR 3-6575652012 : DEV: KPIT-CTT-PROD-APPSUP-APP-ONT-Sale line Stuck in shipped	Sale line Stuck in shipped
201537.1 - Transactions Stuck MTL_TRANSACTIONS_INTERFACE Table with error: 'For This Transaction Row The Serial Records Are Missing'	Transaction stuck with error in TOI with error message as 'For this transaction row theserial records are missing'
SR 3-6516402531 : KPIT-CTT-PROD-APPSUP-APP-ONT-Can not Remove Orphan Move Order Records From Pending Trxns	Can not Remove Orphan Move Order Records From Pending Trxns
3-6424776851 : KPIT-CPG-MFGGPRD-APPSUP-APP-INV - Can not do Subinventory Transfer for an Item	Can not do Subinventory Transfer for an Item
3-6531717691 : 15970664 KPIT-FBU-CFGEMPRD-SUPPORT-APP-ONT-ORDER LINE STATUS AWAITING REPRICING -INVALID SETUP	LINE STATUS AWAITING REPRICING -INVALID SETUP
SR 3-6759741541 : KPIT-CTT-CTT PROD-APPSUP-APP-OM- Not able to do ship confirm for several deliveries	Not able to do ship confirm for several deliveries
SR 3-6371545381 : 14828247: KPAO_CPG_MFGGPRD_Date currupted on SSD on sales order	Date currupted on SSD on sales order
SR 3-6090925881 : KPAO_CPG_MFGGPRD RCA for - For this transaction row, serial records are missing	transaction row, serial records are missing
SR 3-6575652012 : DEV: KPIT-CTT-PROD-APPSUP-APP-ONT-Sale line Stuck in shipped	Sale line Stuck in shipped
SR 3-5682225071 : KPAO_FBU_CFGEMPRD: Release Sales Order for Picking is Errored out	Line cancelled on SO but not on shipping trxn,Release Sales Order for Picking is Errored out
1322105.1-Inventory Reservations Not Relieved for Closed or Canceled Sales Orders and Some are Orphaned: Clean up scripts for Releases 11i and 12	Reservation on Closed and canceled Line
1322105.1- (Inventory Reservations Not Relieved for Closed or Canceled Sales Orders and Some are Orphaned: Clean up scripts for Releases 11i and 12)	Stock has not downdated upon invoicing, After Invoice Stock not Deplicated
3-8765796471-Delivery Stuck in Interface but SO Line is closed	Delivery Sutck at Interface Line Closed
SR 3-5844638021 : DEV:Sales Order Line status at Order Line level stuck at shipped status 1354799.1-Sales Order Lines stuck at Shipped status though assoicated delivery details are interfaced to Order Management	Sales Order line struck at shipped status, Line Status Shipped instead of Closed
SR 3-9131986891 : COLLAB: Sales order line struck at Awaiting reprice - pricing error : we want to close the line.	Awaiting reprice - pricing error,REPRICE_PRICING_ERROR
Custom Script	Invoice number change -  Custom Script
3-9232231058 : Unable to produce invoice	Unable to generate invoice for Order number
3-9423950841 : MTI records stuck with oracle error 332211.1 -MTI (MTL_TRANSACTIONS_INTERFACE) Has Error Code 'Oracle Error' / Duplicates	MTI records stuck with oracle error,
SR 3-9597207501 : KPIT-CGT-CGTSL2D-APPSUP-APP-ONT- ITS Completion in Error SR 3-9620248190 : Data Fix for Duplicate Inventory transactions - Cont. SR # 3-9597207501	ITS Completed in Error " Split quantities must sum up to original quantity"
SR 3-9611293331 : 19639544 KPIT-CPG-MFGGPRD-APPSUP-APP-ONT-Workflow stuck in Fulfill Notified status	Line AR interfaced but no Invoice Generated
SR 2-5844711 : Serial Numbers are not visible in LOV while delivering the Items in to Inventory	Couldn't do Pick and Shipping,ailing to Pick Release as the corresponding Serial Numbers which are attached to them are having GROUP MARK ID populated
SR 3-9684504731 : Sales Person is missing on AR invoices, we need to update Sales Person for affected invoices	Sales Person is missing on AR invoices,
SR 3-5844638021 : DEV:Sales Order Line status at Order Line level stuck at shipped status	Sales order line Stuck in Shipped Status
SR 3-9753613431 : KPIT-CPG-CPG3S-APPSUP-APP-CZ: Need to restore accidentally deleted model	restore accidentally deleted model
SR 3-9414697631 : change a finally closed PO status of shipment to Open status	finally closed PO status of shipment to Open status
303544.1-How To Remove Pending and Error Receiving Transactions from Transaction Status Summary	pending recieving transactions  delete
SR 3-9918802301 : Error while updating items FRM-40654: Record has been updated. Requery block to see change	PO User not able to update the item. Found there is special characters in item descriptions. Need to apply data fix to remove special characters from item description
SR 3-7924740961 : BLANKET RELEASE WITH STATUS PRE-APPROVED How To Reset a Purchase Order or Requisition From In Process or Pre-Approved To Incomplete/Requires Reapproval For Isolated Cases (Doc ID 390023.1)	PO Authorization Status as "in Porcess"  Unable to maintain or cancel this release
3-9871122721 : 20147494 - Not able to transact the Move order Record Stuck in pending Transact SR 3-10047322181 : Not able to backorder the Move orders	Transact move Order Issue,Shipping Trsancation form Line Trasnact Move Order/BackOrdered
428037.1-Sales Order Remains At Ready To Release Status After Pick Release.	Sales Order Remains At Ready To Release Status After Pick Release,Mover order transacted , line status still shows as Release sale Order
SR 3-9927504241 : LPNs not available to transact	Items showing as 'unavailable to transact',LPNs not available to transact
SR 3-9931771631 : CFGNAPRD: Sales Order line is Closed but shipping transaction form shows as "Pick Release"	Sales Order line is Closed but shipping transaction form shows as "Pick Release"
3-9992686231-Unable to cancel the IRISO line,getting error message	ISO Lines can not cancel if IR open,IRISO Line Issue
1563677.1-R12: Unable To Cancel Drop Ship Sales Orders Lines after Cancelling Associated Purchase Order Lines	Patch 16880686: In Oracle Purchasing, Drop Ship functionality, if Purchase Order is canceled first, then getting error on canceling the Sales Order line.
SR 3-10108258821 : Not able create delivery for the Sales order line	Not able create delivery for the Sales order line
SR 3-10239819061 : 20513306 Error while adding model to order 'This bill explosion is already in progress	error saying ‘BOM Explosion is already in progress in another user session. Please try again later’
SR 3-5290067251 : KPAO_CTT_PROD: Approval needed for running the script to change normal price list to intercompany on	oracle provided data fix to convert the price list into Intercompany Price List
SR 3-10166827971 : Item got delivered without Locator in "Locator Controlled Subinventory"	Item got delivered without Locator in "Locator Controlled Subinventory"
SR 3-4204941421 : Receiving Transactions stuck	Receiving Transactions stuck,User is unable to  drop the below LPN due to missing move order line in mtl_txn_request_lines  table
SR 3-10240717261 : Create accounting cost management going into warning	Create accounting cost management going into warning
SR 3-6896340061 : 16485621: LPN Corruption	special characters in LPN numbers
SR 3-4204941421 : Receiving Transactions stuck	Pending Receiving transaction need to clear
390023.1-How To Reset a Purchase Order or Requisition From In Process or Pre-Approved To Incomplete/Requires Reapproval For Isolated Cases	PO Stcked in Process
SR 3-5394147471 : KPAP_CTT_AUK_HSTPROD : WMSINB-23846:Lot/Serial validation failedLot/Serial validation failed.	Lot Serial Validation Failed Error
SR 3-4951723481 : 13435242-Item stuck in receiving	Item stuck in receiving -INVALID LPN
Custom Script-Duplicate Entires in Sourcing rules	Duplicate Entires in Sourcing rules
SR 3-6515289151 : 16033467 - Single serial number received twice	Single serial number received twice
Cannot print Blanket Purchase Agreement.  NO SR	Cannot print Blanket Purchase Agreement.
SR 3-8173578221 : RCV11i - Receipt records stuck in Pending Transaction Form SR 3-7640139111 : 17301980 Not able to deliever materials into WMS enabled org	PO Receipt stuck in Pending Transaction Form due to fractional quantity in receiving transaction  form
SR 3-5837891911 : 14314492: User is not able to perform the correction transaction from rceiving.	Transactions were stucked into the "Pending transaction
SR 3-8130040391 : KPIT-CPG-MFGGPRD-APPSUP-APP-ONT-Not able to create Autodeliveries	Not able to Auto create Deliveries
SR 3-9793586791 : cant cancel SO line	cant cancel SO line
SR 3-9300916982 : 19279671 -- Impossible to deliver LPN000000006652 - LPN_ID=46531 on BR 621000157-564 SR 3-9329616789 : 19464915 Cannot deliver LPN000000005873 (LPN_ID=45657) on BR 621000494 - 115	Unable to perform Move Any LPN transaction
SR 3-6756229841 : BUG 16301476 - KPIT-COMP-CTT-SUPPORT-APP-ONT- UNABLE TO PURGE PARTIALLY PROCESSED SCHEDULE	UNABLE TO PURGE PARTIALLY PROCESSED SCHEDULE - RLM
SR 3-7865006461 : DEV:KPIT-FSB-FSB1P-APPSUP-APP-ONT- Order Management is not updating statues "cancel"	Sales Order Line is cancelled but  shipping Transaction form shows as"Pick release"
SR 3-4213622211 : Error :LPN is not available	Unable to cancel MOVE Order
SR 3-7851855811 : 17633423 KPIT-CGT-CGTSL2D-APPSUP-APP-ONT--Invoice not generated for the sales order line	Sales Order  Line NOT present on AR Invoice
SR 3-6723107351 : 16234439 -Not able to do the receipt correction	Parts Shipped but Showing in Material Workbech
EDI-INO: 810 Outbound Invoice Frequently ASked Questions (Doc ID 283555.1)	Invoices 18593 for which INO file was not generated
SR 3-9918802301 : Error while updating items FRM-40654: Record has been updated. Requery block to see change	User not able to update the item. Found there is special characters in item descriptions
SR 3-8695498051 : 18424710 KPIT-EBU-SEYPRD-APPSUP-APP-OM: Duplicate Movement ID - Movement Static Report	Movement Statistics Processor' has run for 2 times on the same time stamp. Due to this reason duplicate data was inserted into mtl_movement_statistics table.
SR 3-6723107351 : 16234439 -Not able to do the receipt correction	LPN has data corruption
SR 3-6515289151 : 16033467 - Single serial number received twice	Serial number 2012C-P20196074-01 is received twice in the system. hence item A024R606 is resides into the inventory with out serial number.
FAQ: Inventory Standard Datafixes (Doc ID 568012.1)	Line 1.1 was partially shipped which created line 1.2. Reservations against line 1.1 are not released and as a result CEVA are unable to transact move orders.
SR 3-8765796471 : Delivery Stuck in Interface but SO Line is closed	Error msg: ORA-20002: 3133: Activity instance 'SHIP_LINE' is not a notified
SR 3-9040397271 : 19048660 Delivery is not Interfacing,Case of multiple Data Corruption.	ITS IN ERROR
SR 3-7167584771 : DEV: KPIT-CGT-CGTSL2D_APPSUP_APP_ONT Shipping Trans form showing 1 extra record for same SO Line	When Queried the Order and Item on Shipping transaction form : The results shows 2 records for the same Sales order Line, whereas on the sales order line for line 1.1..0 the actual line quantity is 2 which is shipped and fulfilled however still 1 quantity is showing as reserved and Line status is closed
SR 3-6563929531 : OUT: Planning Schedule (830/DELFOR) failing	OUT: Planning Schedule (830/DELFOR) failing  duplicate ASL Attribute value.
SR 3-6071018221 : 14677131 R12 : Error FRM-40105: Unable to resolve reference to item PO_HEADERS.DOC_TYPE_NAME	Unable to DELETE 0 quantity on PO - distribution
SR 3-9666502501 : KPIT-CPG-MFGGPRD-APPSUP-APP-GL:- Unable to update the Accounting period dates in Standard Calendar.	Business user mistakenly define the Jan-15 period from 01-Jan-15 to 02-Feb-2015 instead of 01-Jan-2015 to 01-Feb-2015.  When they tried to change the period from 02-Feb-2015 to 01-Feb-2015 they were facing error message.We have raised SR with Oracle, oracle refer to  Oracle consulting team, They have provided the data fix for updating the 'To Date:- from 02-Feb-2014 to 01-Feb-2014'.Please see the attached script for your reference. We need to update the script for above GL To-date in Accounting calendar.
SR 3-5837891911 : 14314492: User is not able to perform the correction transaction from rceiving	Transaction were stuck into the Pending transaction while doing Correction
3-6398139421 : KPIT-CGT-CGTSL2D-APPSUP-APP-ONT_Interface trip Stops complete with warning,	WSHINTERFACES failed on MCOPGG02 : Records stuck in TOI with following error "For this Transaction row serial number is missing"
SR 3-8623132141 : KPIT-CTT-PROD-APPSUP-APP-ONT: In Drop Ship the Qty is not depleted	SO picks printing delayed -  Pick Selection List Generation - SRS,  which is completing in ERROR
SR 3-6336133951 : Accounting entries not generated for receipt transaction	Customer is not able to see the receipts in receipt write off form. The issue is because of accounting entries not generated and receipt data is not available in  RCV_RECEIVING_SUB_LEDGER table
SR 3-6756229841 : BUG 16301476 - KPIT-COMP-CTT-SUPPORT-APP-ONT- UNABLE TO PURGE PARTIALLY PROCESSED SCHEDULE	the schedule status is stuck at Partially processed however all the lines are processed already So need to apply data fix provided by oracle in order to change the status of the schedule as 'Successfully Processed'
SR 3-6723107351 : 16234439 -Not able to do the receipt correction	User is not able to see lpn # LPN000000995674 contents from MSCA but it present in the material workbech
SR 3-6336133951 : Accounting entries not generated for receipt transaction	We have investigated the issue and found that accounting entries have not been generated for receive transaction for receipt # 157132
ROOT CAUSES for issue in note 1291007.1 (Order Lines Closed but Delivery Details Open) (Doc ID 1582503.1)	Order Lines Closed but Delivery Details Open