Error when trying to view Change PO suggestions

Epicor ERP 10
,
1

Hi,

I am getting an error on the Change PO Suggestions screen. I hit the binoculars, then hit Search and an error that states it cannot find the PORel_UD table. It is true, this table does not exist but can I find and correct the object that i supposedly looking for it?

I looked at a client and SQL trace but could not find the answer.

Thank you,

Daniel

2

Make sure your Data Model is in sync in UD Column Maint. Were UD Columns added to PORel at one point, then deleted?

1 Like
3

Is the search defaulting to a BAQ or QuickSearch?

image

Try using the Basic search tab

4

I didn’t add any UD columns to the PORel table. But is there any place where I “look” at the data model?

5

I get the error when I hit Search on the Basic search…

image
image.png949Ă—853 45.1 KB

6

Are there any BPM’s enabled for the highlighted BPM?

image

7

Look in user defined column maintenance.

image

8

Go to
image

Then in Extended User Defined Table Maint, click the search, and you’ll see all the UD Ext tables

image
image672Ă—679 16.8 KB

As you can see in mine, I have a UD Ext table for POHeader, but none for PODtl or PORel

9

No PORel_UD

image
image.png1390Ă—899 37.5 KB

10

No BPM:

image
image.png646Ă—780 23.8 KB

11

Unlike, (but worth ruling out) …

If there is a test environment on the same app server
AND the Production (aka LIVE) system and the test system were both installed in the same directory on the client computer,
AND the test environment has the PORel_UD

The files on the workstation may have been updated to match those required for the test environment.

12

The LIVE and the Test Environment has installed on different folders on my PC and none of them have the PORel_UD.

13

Have you tried clearing the client cache?

Does this happen to other users and on other workstations

14

Yes, I cleared the cache and no change. I tried with my account on another workstation and I still have the issue. But I found out that the behavior depends on the site. We have 6 sites: I have no issues with 4, in 1 site I have an error that mentions PORel_UD and and in the last one I also have an error message but it does mention PORel_UD (same object though)…

15

You don’t get the error until you hit the Search button, correct?

Maybe try regenerating the PO Suggestions, with the option to build from scratch.

16

If you can, try recycling your app pool. Is this on a production environment and just started today at random?