Updating tables to remove special characters
We have an issue with the "Receiving Transactions Register" erroring for a specific date; the log file shows:
emsg:was terminated by signal 6
Enter Password:
*** glibc detected *** ora_rw20_run: free(): invalid pointer: 0xd809ef27 ***
I found a solution: Note "Generic Receiving Datafix Scripts and Root Cause Patches (Doc ID 601639.1)" directed me to:
30. Remove item description's special characters in shipment line
Note 1345570.1 - RCVTXRTR Receiving Transactions Register Report Errors: Rep-0004 Signal 6
In Note 1345570.1, the fix is to run this update script:
UPDATE RCV_SHIPMENT_LINES
SET ITEM_DESCRIPTION = LTRIM(RTRIM( REPLACE(REPLACE(REPLACE(ITEM_DESCRIPTION , CHR(9),' ') , CHR(10), ' ') , CHR(13), ' ')))