Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to customize P03B102 to update F03B11 & having problems Table I/O

Status
Not open for further replies.

mt195451

Programmer
Dec 20, 2007
1
US
Problem Description: I need to update the F03B11 in the P03B102. I am updating the file in the OK "Post Button Pressed" button Pressed after the F03B11 has been updated in the table. The problem is that the Table I/O update is not being processed and is locked on the UPDATE statement.
The Update is after the file has been updated and the Cache is destroyed.

"Call the B03B0158 function to destroy the entry cache.
///
Receipts Entry Destroy Cache"

In the debug log the program stops on the TABLE UPDATE that I put in and does not move to the next statement no matter how long I wait.
If I kill the program after 1/2 plus hour the program back outs out all the previous table entries including the F03B11 and F03B14 records.
=======================================================================
FORM: Receipt Entry [HEADER DETAIL] (W03B102E)
=======================================================================
CONTROL: HYPITEM &OK
EVENT: Post Button Clicked
-----------------------------------------------------------------------
>>>>>> SKIPPED CODE >>>>>>>>>>
If VA frm_TypeTransaction is not equal to <Blank>
And VA frm_TypeTransaction is not equal to <Null>
F03B13Z2 Process Receipt Header Outbound Transaction
End If
End If
End If
If SL CountryCode is not equal to <Blank>
And SL CountryCode is not equal to <Null>
Plug & Play - P03B103 Country Server Exits
End If
//
B03B0069 function to maintain unapplied cash.
//
F03B14 Maintain Unapplied Cash
//
// ... Call the B03B0158 function to destroy the entry cache.
//
Receipts Entry Destroy Cache
//
// Update the RU document type using the Balance Sheet Business Unit for the
// company on the receipt. Both the F03B11 and the F03B14 tables.
//
F03B11.Select
F03B11.Select
F03B11.Fetch Next
F03B11.Update
 
There are very few JDE/PeopleSoft people are this site, a bettter site may be jdetips.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top