Results 1 to 4 of 4

Thread: Report based on work center messages

  1. #1
    Member
    Join Date
    Jul 2002
    Location
    Philadelphia,PA
    Posts
    350

    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.

    Thanks,
    Matt
    JDE 9.1

  2. #2
    Matt,

    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,

    Jer
    Current: E1 9.1, TR 9.1.4.4, 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
    Location
    NSW Australia
    Posts
    2,044
    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
    Member
    Join Date
    Jul 2002
    Location
    Philadelphia,PA
    Posts
    350
    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.