Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Wednesday, September 2, 2015

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

1 comment:

ajay gunupuru said...

is there any standard report which would show the sales orders interfaced to AR but for which invoice could not be created due to some issues in oracle r12

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect