Results 1 to 4 of 4

Thread: Report based on work center messages

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Jul 2002

    Report based on work center messages

    Does anybody have a good way of figuring out the joins between the various F01131.. tables? Basically we don't have access to the users work center messages. So we wanted to write a report to figure out their messages. But not sure how to join the various tables to get messages by user. Any ideas would be appreciated.

    JDE 9.1

  2. #2

    I built a report for our EDI process that shows messages from the SO Create UBE. There could be different message types for different situations so I recommend looking at the Work Center (especially noting the child relationships) and data browser and/or UTB to understand available fields for particular scenarios. Here are the basics I used. F01131 is the parent, so you start there for user and date. SERK then is used to go into F01131M PSRK. In turn, F01131M SERK may be found in F01131M PSRK indicating a child record. This allows for continued child levels in the F01131M. Some potentially useful fields include: F01131M PPSRK always has the SERK from F01131, LV in both tables indicates the level of the tree this record is on, ZMMSGP and ZMTSV contain useful information about the error/message.

    So, the report is basically a section on F01131 to find the correct starting record(s), a section on F01131M that contains code using SELECT/FETCH NEXT to iterate through the levels, and a section that is called to simply print the line detail as needed. I suppose you could create a second F01131M section to be called from the first one to do iteration, instead of FETCH NEXT, as well.

    Hope this helps,

    Current: E1 9.1, TR, Win2008 R2, SQL Server 2008 R2, WebLogic, OneView, Embedded BIP
    Original: E1 8.0, SP 24.1.2, Win2003, SQL Server 2005 SP3, all fat client

  3. #3
    Senior Member peterbruce's Avatar
    Join Date
    Jan 2004
    NSW Australia
    Thanks, Peter

    "Give a person a fish, feed them for a day, teach them how to fish, feed them for a lifetime."

    E9.1 TR9.1.2.1, Enterprise Server: Sun, Database Server: Sun, Oracle DB: 11g, Weblogic.
    Create!form 7

  4. #4
    Join Date
    Jul 2002
    Thanks Peter & Jer!!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company, Oracle or Peoplesoft.