INVMWBIV: Cannot Copy All On hand Quantity Records From Material Workbench Form To Excel Due To Non-Printable Or Special Characters (Doc ID 2182038.1)

Last updated on MAY 24, 2023

Applies to:

Symptoms

User is trying to copy all displayed records on Material workbench to Excel . Using the top left box, the user selects all the records, scrolls down to the end of the form to load all records and then right click to select "Copy All Rows" . Then, he tries to paste this to Excel.

Steps to replicate the issue:

1. Go to the material workbench form >  Inventory > Onhand Quantity > Material workbench
   2. Select an organization and click on find.
   3. Click on the top left box on the grid to select all records > Right Click > Select 'Copy All rows'  > Try to export to excel.
   4. Records export partially and stops abruptly. 

- Identifying script

SELECT
MFG_part_num,
attribute3,
REGEXP_REPLACE(attribute3, '[^[:print:]]', '') as cleaned_data
FROM
apps.mtl_mfg_part_numbers
WHERE
REGEXP_REPLACE(attribute3, '[^[:print:]]', '') <> attribute3;
 

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.