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
  • 179 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

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

Forum|alt.badge.img+8

Hi Ravindu,

 

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

 

Best regards,

Devni


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings