missing F43121 record when doing receiving of purchase order line

[david_mallory]

We are experiencing errors when doing receiving of PO items with program P4312. The F0911 GL record and the F4111 Cardex records are being written, but the F43121 receipt record is not being written. We are not getting a "commit failed" error message.

Has anyone else seen this ? Do you have any info on cause or fix ? JDE has been no help.

Dave Mallory
Denver Water
OW Xe Update 3 SP 17.1
NT 4.0
Oracle 8.1722

 

[ame]

Do you have any records in this file already? It sounds like the table may
be corrupt. If you copy out the data there... and then regenerate the table
and indexes... and then copy the data back in... the problem should be
fixed... let me know. thanks, Bobby







Has anyone else seen this ? Do you have any info on cause or fix ? JDE has
been no help.

Dave Mallory
Denver Water
OW Xe Update 3 SP 17.1
NT 4.0
Oracle 8.1722


_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail

 

[sean_gilbert]

Have you checked the jde.log and jdedebug.log
Have you recently changed next numbers for the receipt 'OV' document type. Has there been row security applied to this table.

 

[david_mallory]

We get this situation intermittently. The table is 4 years old. Most of the time it works fine. We have not changed Next Numbers. We have no row security on this table. We have sent JDE a log showing the problem and they still do not believe there is a bug.

I will send the table copy/regenerate/copy back idea to I.T. Thanks

Dave Mallory

 

[vetheridge]

have seen this before also. we had to delete all of the user overrides associated with the receipting application. this seemed to fix it.


regards,

Vici Etheridge
Business Systems Analyst

 

[sandesh agrawal]

We are experiencing errors when doing receiving of PO items with program P4312. The F0911 GL record and the F4111 Cardex records are being written, but the F43121 receipt record is not being written. We are not getting a "commit failed" error message.

Has anyone else seen this ? Do you have any info on cause or fix ? JDE has been no help.

Dave Mallory
Denver Water
OW Xe Update 3 SP 17.1
NT 4.0
Oracle 8.1722

If the receipt is made for inventory item and there is no "P" (Primary) record exists in F41021 table for branch plant and short item no then this issue comes . Pls check add P record and test the case by initiating new purchase order. This solution will not work for existing PO which has already been created.