Page 2 of 3 FirstFirst 1 2 3 LastLast
Results 11 to 20 of 26

Thread: Email PDF Output

  1. #11

    Re: Email PDF Output

    Hi Geri,

    I will try the logic you gave.

    Anyways, I learnt something new here. I was not knowing that we can place ER in place other than sections.This is the first time I will be using Edit Report Level Event rule.
    --------------------
    XE.,EnterpriseOne 8.9, 8.10, 8.11,8.12
    Win2K , Oracle

  2. #12

    Re: Email PDF Output

    Hi Geri,

    Can I do something like this:

    1)Derive full Report name(along with Job Number) in Child report
    2)Pass value from 1) to Driver Report through report Interconnect
    3)In driver report send email.

    Will this work,

    Sonia
    --------------------
    XE.,EnterpriseOne 8.9, 8.10, 8.11,8.12
    Win2K , Oracle

  3. #13
    New Member
    Join Date
    Nov 2001
    Location
    TX, USA
    Posts
    23

    Re: Email PDF Output

    I think you should be able to do so because you will be passing back the pdf file pointer back to the driver section so it can attach the file to your email. Let me know if this works for you.
    One World
    B9 - SP3
    Oracle 10G

  4. #14

    Re: Email PDF Output

    Hi Geri,

    I tried doing Table I/O operation on F986110 but somehow it is failing.
    I don't know why it is not working,even if I only give submitted date as selection criteria, it is not working.

    Can OCM mapping for F986110 be the reason why it is failing?
    --------------------
    XE.,EnterpriseOne 8.9, 8.10, 8.11,8.12
    Win2K , Oracle

  5. #15
    New Member
    Join Date
    Nov 2001
    Location
    TX, USA
    Posts
    23

    Re: Email PDF Output

    Good morning Ainos!

    I don't think the OCM mapping is affecting your table I/O. Do you know how to turn your UBE logging on? If yes, you may want to see if there's any additional information you could gather from the log to determine why your Table I/O is failing. Have you also tried using this code on the "child" UBE itself to try and send the email?

    If the table I/O works in the child UBE, then perhaps you are not passing the correct parameters back to the parent UBE (or calling UBE).

    Good luck and hope this works. If you still have problems, could you send me your codes so I can take a quick look at it?
    One World
    B9 - SP3
    Oracle 10G

  6. #16

    Re: Email PDF Output

    Finally I was able to figure out why Table I/O on F986110 was failing.

    It sounds pretty weird, but the entry of child report in F986110 was taking place only after the status is 'D'. So instead of doing table I/O in child report, I did it in driver report. It worked!!!

    Thanks Geri
    --------------------
    XE.,EnterpriseOne 8.9, 8.10, 8.11,8.12
    Win2K , Oracle

  7. #17
    New Member
    Join Date
    Jul 2005
    Posts
    29

    Re: Email PDF Output

    Hi Geri
    I am on XE and tried using your code, But I am not able to find business function "Get UBE Output Path"
    Does it having other description in XE ? Can you please tell me the Souce Module Number for this business function

    Thanks
    Demi
    Demi
    CNC-8.11 SP1
    Tool Release: 8.97
    MS SQL2005 SP3
    WIN 2003

  8. #18
    New Member
    Join Date
    Nov 2001
    Location
    TX, USA
    Posts
    23

    Re: Email PDF Output

    Good morning Demi -

    Forgot that this is a custom NER. Here are the details for this NER:

    GetOutputPath ==========================================
    Get UBE Output Path ================================================== ======
    [N589801] [D589801] ================================================== =======

    GetOutputPath <~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~

    evt_szEnvironmentName_ENHV [ENHV]
    evt_szOutputPath_NFLF [NFLF]
    evt_szNameObject_OBNM [OBNM]
    evt_szUBECode_OLCD04 [OLCD04]
    evt_szOLFunctionCode_FUNO [FUNO]
    evt_szPathCode_PATHCD [PATHCD]
    evt_szB9Path_NFLF [NFLF]
    evt_szMachineUsage_USAGE [USAGE]
    evt_szMachineKey_MKEY [MKEY]
    0001 // ----------------------------
    0002 // Initialize Vars
    0003
    0004 evt_szOLFunctionCode_FUNO [FUNO] = 'UBE'
    0005 evt_szNameObject_OBNM [OBNM] = DS szSRCNameObject_OBNM [D589801,OBNM]
    0006 evt_szEnvironmentName_ENHV [ENHV] = DS szEnvironmentName_ENHV [D589801,ENHV]
    0007 If evt_szEnvironmentName_ENHV [ENHV] = <Null>
    0008 evt_szEnvironmentName_ENHV [ENHV] = SL Login Environment
    0009 EndIf
    0010 Read INI [ReadIni,B980055,D980055,CDBASE]
    DS szSectionName [D980055,SECTNM] <- 'INSTALL'
    DS szVariableName [D980055,CVVVARNM] <- 'B9'
    DS szValueForEntryDefault [D980055,DVAL] -> evt_szB9Path_NFLF [NFLF]
    DS szFileNameOne [D980055,FILE1] <- 'JDE.INI'
    0011 evt_szOutputPath_NFLF [NFLF] = concat(rtrim([VA evt_szB9Path_NFLF],' '),'\\')
    0012 // Check for TC
    0013 F9860.Fetch Single (index 3)
    TK NameObject [F9860,OBNM] = evt_szNameObject_OBNM [OBNM]
    TK FunctionCodeOpenSystems [F9860,FUNO] = evt_szOLFunctionCode_FUNO [FUNO]
    TK ObjectLibrarianCode04 [F9860,OLCD04] -> evt_szUBECode_OLCD04 [OLCD04]
    0014 If evt_szUBECode_OLCD04 [OLCD04] = '5'
    0015 // UBE is a TC
    0016 Get Path Code From Environment [GetPathCodeFromEnv,B9800094,D9800094,CCORE]
    DS szUsrliblname [D9800094,LL] <- evt_szEnvironmentName_ENHV [ENHV]
    DS szPathcode [D9800094,PATHCD] -> evt_szPathCode_PATHCD [PATHCD]
    0017 evt_szOutputPath_NFLF [NFLF] = concat(ltrim([VA evt_szOutputPath_NFLF]," "),[VA evt_szPathCode_PATHCD] )
    0018 evt_szOutputPath_NFLF [NFLF] = concat(rtrim([VA evt_szOutputPath_NFLF],' '),"\\")
    0019 evt_szOutputPath_NFLF [NFLF] = concat(ltrim([VA evt_szOutputPath_NFLF],' '),"export")
    0020 evt_szOutputPath_NFLF [NFLF] = concat(rtrim([VA evt_szOutputPath_NFLF],' '),"\\")
    0021 Else
    0022 evt_szOutputPath_NFLF [NFLF] = concat(ltrim([VA evt_szOutputPath_NFLF],' '),"PrintQueue")
    0023 evt_szOutputPath_NFLF [NFLF] = concat(rtrim([VA evt_szOutputPath_NFLF],' '),"\\")
    0024 EndIf
    0025 // Check for Enterprise Server
    0026 Get Audit Information [GetAuditInfo,B9800100,D9800100,CCORE]
    DS szMachineKey [D9800100,MKEY] -> evt_szMachineKey_MKEY [MKEY]
    0027 F9650.Select (index 1)
    TK MachineKey [F9650,MKEY] = evt_szMachineKey_MKEY [MKEY]
    0028 F9650.Fetch (index 1)
    TK MachineUsage [F9650,USAGE] -> evt_szMachineUsage_USAGE [USAGE]
    0029 F9650.Close
    0030 DS szMachineUsage_USAGE [D589801,USAGE] = evt_szMachineUsage_USAGE [USAGE]
    0031 DS szPathFlatFile_NFLF [D589801,NFLF] = evt_szOutputPath_NFLF [NFLF]

    -------------------
    Data Structure
    D589801 <~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    [OBNM] -> szSRCNameObject_OBNM
    [ENHV] -> szEnvironmentName_ENHV
    [NFLF] <- szPathFlatFile_NFLF
    [USAGE] <- szMachineUsage_USAGE
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    One World
    B9 - SP3
    Oracle 10G

  9. #19
    New Member
    Join Date
    Jul 2005
    Posts
    29

    Re: Email PDF Output

    Geri
    Thanks a lot

    Rgds
    Demi
    Demi
    CNC-8.11 SP1
    Tool Release: 8.97
    MS SQL2005 SP3
    WIN 2003

  10. #20

    Re: Email PDF Output

    Good Monday morning!
    Thank you for the very informative post regarding the “Email PDF Output”. I have been looking for solution for some time and was very glad to see a working solution.
    While implementing your solution I ran into a problem. Somehow I can not find the function “Get UBE Output Path”. I assume it is a business function so I searched it by function name, description but just could not find it. Would you please provide more information so I can locate it? If it is developed by you, would you mind sharing the source?
    I’d really appreciate your help.
    PS we are using B810.

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 and, or Oracle.