×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

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

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

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

(OP)
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
 

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

There are very few JDE/PeopleSoft people are this site, a bettter site may be jdetips.  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close