Skip to main content
Solved

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

  • September 23, 2021
  • 1 reply
  • 194 views

Ravindu Perera
Hero (Employee)
Forum|alt.badge.img+9

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
---------------------------
[OK]
---------------------------
"

 

Is there a fix for this issue?

Best answer by Devni Panduwawala

Hi Ravindu,

 

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

 

Best regards,

Devni

This topic has been closed for replies.

1 reply

Forum|alt.badge.img+8
  • Hero (Employee)
  • 24 replies
  • Answer
  • September 23, 2021

Hi Ravindu,

 

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

 

Best regards,

Devni