Advance Pricing & Performance in SO Detail (B7331)

fsaeed

Member
B7331 SP7.1 /NT 4.0 SP 5.0/SQL 7.0 SP2.0 / Citrix MetaFrame 1.8
8 processor HP / 4G of RAM Enterprise box


We had JDE Tier 1 business consultants setup our advance pricing with the
following 6 layers of PRICING PREFERENCE HIERARCHY and about 42 schedules:

1). Item Number by Ship To Address
2). Item Group by Ship To Address
3). Item Number by Sold To Address
4). Item Group by Sold To Address
5). Item Number by All Customers (Base Pricing Only)
6). Item Group by All Customers (Base Pricing Only)

I am more tehnical than not. For what I have been told, these business
consultants have not seen such complex advance pricing. The only reason I
mention this is because these consultants specialize in advance pricing and
I am not questioning their expertise.

As we grow and add more users we have started to see the following advance
pricing performance issue:

o If we don't have advance pricing setup for certain customers with no one
on the system:(FAT or Terminal Servers)
P4310 - Adding one line and going from that line to a new line in the SO
detail takes less than 1 second.

o If we do have advance pricing setup for certain customers with no one on
the system:(FAT or Terminal Servers)
P4210 - Adding one line and going from that line to a new line in the SO
detail takes 3-4 second.

o If we do have advance pricing setup for certain customers with 100+ type
load on the system: (FAT or Terminal Servers)
P4210 - Adding one line and going from that line to a new line in the SO
detail takes 6-20 second (depending on the load).

I have searched the old JDElist/ New JDElist articles and have seen this
issue mentioned but no ideas about how to solve this problem. Someone did
mention that they are going to call the repricing UBE for advance pricing at
night. We cannot implement this solution for a lot of reasons.

We are pushing Denver to resolve this issue as soon as possible since 3-4
seconds per line is not acceptable out in the field.

My questions to the list are:

Are any of you doing complex advance pricing and how is your performance??
Have any of you heard of performance problems and/or solutions that I may
have missed??

Thanks in advance for any comments and suggestions....

Faisal
 
Hi Faisal,

At first excuse me that I copy a post (with some changes) which was sent just previously to Richfer, as a reply to you but the situation seems the same. Thanks.

We have similar problems like you but in P4312 "PO Receipts" and in P43291 "Landed Cost Selection" application.
It occurs on our B7332 system which have been upgraded from B7321.

Please, let me some question and request.

1.) Have your system also been upgraded? If yes then from which release?
2.) Do you have also problem with P4312 and P43291?

Would you be so kind as to notify me on my e-mail address when you get something information or any solution in this issue?

Thanks in advance,
Zoltán
P.S.: Of course, I will also notify you if we find something.

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Hi Zoltan,

Both sound like performance problems but do not seem to be interconnected
yet... We have not recently upgraded and are not having problems with "PO
Receipt" or "Landed Cost Selection" applications.

JDE had initially said that "multiple levels in the Preference Hierarchy
(more than 4) would cause some performance issues". But this is not
acceptable from a business point of view plus we have a backup system(less
than 4 levels) that we tested this on and it still took 2-3 seconds per SO
detail line with no one on the system.

I have seen one other response on the JDEList that says the same thing about
response and "multiple levels in the Preference Hierarchy (more than 4)" in
advance pricing. SARS that relate to performance issues and advance pricing
are:

5141603 :: 5141603 Pricing Performance System45 FOR B7332
5122550 :: 5122550 Pricing Performance System45 FOR XE

But none come out say how performance was effected and do these SARS
actually solve the problem. It seems like they help. Of course neither
solutions are going to help us in B7331.

Still looking for a miracle cure to this problem.......


Thanks in advance,

Faisal
B7331 SP7.1 /NT 4.0 SP 5.0/SQL 7.0 SP2.0 / Citrix MetaFrame 1.8
8 processor HP / 4G of RAM Enterprise box
 
Back
Top