Partially-accepted PO

sshepard

Active Member
B733.2 SP 11.3 (No SARs or ESUs) NT

(We are testing Mother ESU 1 in test environment, but until deployed ...)

We occasionally get Commit Fail errors when loading POs. Usually, at night,
I just run PO Re-post to get rid of the commitments.

Unusual case recently - Header did not take but the one "J" line type took.
Does not appear in the F4301 but does appear in the F4311. When I try to
delete the line item, I cannot pull up the detail line.

How can I get rid of this PO Line Item so it won't display on Open PO Items
reports ?

[After rummaging through the first ESU being tested, I think the ESU will
fix this problem, but until then ...]

Steve S.
 
Steve,

You can use SQL or access to delete the offending record from F4311. JDE will be non the wiser about the record.

> B733.2 SP 11.3 (No SARs or ESUs) NT

(We are testing Mother ESU 1 in test environment, but until deployed ...)

We occasionally get Commit Fail errors when loading POs. Usually, at night,
I just run PO Re-post to get rid of the commitments.

Unusual case recently - Header did not take but the one "J" line type took.
Does not appear in the F4301 but does appear in the F4311. When I try to
delete the line item, I cannot pull up the detail line.

How can I get rid of this PO Line Item so it won't display on Open PO Items
reports ?

[After rummaging through the first ESU being tested, I think the ESU will
fix this problem, but until then ...]

Steve S.




--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=7509
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +

<



Mike Dupaix
JDE Certified Professional
(630) 904-5373 – Office/Fax
(630) 750-2500 - Cell
 
Not sure if this is related to your problem, but we had some major problems with
Purchase Order entry and JDE wrote an ESU to fix it. This first surfaced as a
"Threaded Business Function" error. JDE asked us to map (through OCMs) all category
code 2 business functions to run on the server, rather than the default of local.
We did this and then we got the "commit failed" error on purchase order entry.
Turns out, our servers were running too fast (what a novel concept!), by making
multiple entries into the database table (F43199) that tracks activity history on a
PO within the same second!?! The ESU actually put a one second time delay into the
process between each entry. The user was creating a blocking lock on the database
table and was actually locking himself out. This combination resolved our problems,
but took the better part of 3 months to figure it out. The SAR number for our
release was 4796595. I understand this is also an issue with Oracle and this fix
was included in Update 1 for Xe.

B7332 / SP 11.2 / NT 4.0 / SQL 7.0

Susan Ferlita
Hillsborough County Sheriff's Office
Tampa, FL

sshepard wrote:

> B733.2 SP 11.3 (No SARs or ESUs) NT
>
> (We are testing Mother ESU 1 in test environment, but until deployed ...)
>
> We occasionally get Commit Fail errors when loading POs. Usually, at night,
> I just run PO Re-post to get rid of the commitments.
>
> Unusual case recently - Header did not take but the one "J" line type took.
> Does not appear in the F4301 but does appear in the F4311. When I try to
> delete the line item, I cannot pull up the detail line.
>
> How can I get rid of this PO Line Item so it won't display on Open PO Items
> reports ?
>
> [After rummaging through the first ESU being tested, I think the ESU will
> fix this problem, but until then ...]
>
> Steve S.
 
to Susan Ferlita;

Thank you for the response regarding Commit Fails on PO Entry.

Steve S.

>
 
Mike D - My partner is the SQL man. Thanks for the info - I had not thought
of that.

Steve S.

>
 
Back
Top