Invalid Table Name error when 'Show All Reservable Parts' checkbox is ticked in Manual Reservation Shop Order screen - when there are custom fields in ShopMaterialAllocUtil

  • 23 September 2021
  • 1 reply

Userlevel 4
Badge +7

Hi, in our customer’s APPS10 environment;


1. Go to an Assembly Shop Order with custom fields defined in ShopMaterialAllocUtil (Under manuak resevatuons detail > RMB> Custom fields)
2. Now RMb on on line? Manual Reservations
3. Check 'Show all reservable parts' checkbox
4. You get an oracle error saying

"invalid table name

Failed executing query (ORA-00903: invalid table name)"

At the same time, while the aboce check box is checked

RMB on the detail tab> Custom Objects> Fields> Overview

You get another error saying;

IFS Applications
The view for this page and logical unit do not match. It is not possible to add a Custom Field to this page


Is there a fix for this issue?


Best answer by Devni Panduwawala 23 September 2021, 05:55

View original

1 reply

Userlevel 4
Badge +7

Hi Ravindu,


This issue can be solved via 158476 which is available from UPD12 onwards.


Best regards,