Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

Updating tables to remove special characters

edited Oct 17, 2018 11:07AM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 3 commentsAnswered

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), ' ')))

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center