Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Financial report Prompt

661221Oct 2 2008 — edited Oct 6 2008

Hi,

Financial report:

In a report i want in Col:=1 ( Year=prompt) , Col:=2 (Year=Prompt-1),

If the user selects 2008 in col:=1, i need to get 2007 in col:=2 ....how can we get it...

If i put Col=1 ( Year=User POV) & col=2(YEAR=Relative member currnent POV year:Off set=-1) ....WORKS PERFECTLY.

But if i do the same with Promt ....It is Prompting Twice For COl=1 & Col=2.......

How can i get only 1 prompt

thnx in advance

Anuradha

This post has been answered by Iain Curtain on Oct 3 2008

Jump to Answer

807557

smtp is your mail server, not client
if you want to relay your mail to a different smtp server, add the following line to you /etc/mail/main.cf file

DSmymailserver.mydomain.com

807557

My server is not in a domain. It is configured in a workgroup.
Does this cause the sendmail to fail?

Regards,
Ashok Kumar.G

807557

try this command and post the results:

date | mailx -v -s "test email" email_address

807557

Hi Chris,

The output is given below.

# date | mailx -v -s "test email" ashokdb2k@gmail.com
# ashokdb2k@gmail.com... Connecting to [127.0.0.1] via relay...
220 OLMXDB.OLAMNET.COM ESMTP Sendmail 8.13.8+Sun/8.13.8; Thu, 24 Dec 2009 14:30:02 +0800 (SGT)

EHLO OLMXDB.OLAMNET.COM

250-OLMXDB.OLAMNET.COM Hello localhost [127.0.0.1], pleased to meet you
250-ENHANCEDSTATUSCODES
250-PIPELINING
250-EXPN
250-VERB
250-8BITMIME
250-SIZE
250-DSN
250-ETRN
250-DELIVERBY
250 HELP

VERB

250 2.0.0 Verbose mode

MAIL From:<root@OLMXDB.OLAMNET.COM> SIZE=93

250 2.1.0 <root@OLMXDB.OLAMNET.COM>... Sender ok

RCPT To:<ashokdb2k@gmail.com>
DATA

250 2.1.5 <ashokdb2k@gmail.com>... Recipient ok
354 Enter mail, end with "." on a line by itself

050 <ashokdb2k@gmail.com>... Connecting to gmail.com via esmtp...
050 <ashokdb2k@gmail.com>... Connecting to mailhost.OLAMNET.COM via esmtp...
050 <root@OLMXDB.OLAMNET.COM>... Connecting to local...
050 220 olmxdb LMTP ready
050 >>> LHLO OLMXDB.OLAMNET.COM
050 250-olmxdb
050 250-8BITMIME
050 250-ENHANCEDSTATUSCODES
050 250 PIPELINING
050 >>> MAIL From:<>
050 250 2.5.0 ok
050 >>> RCPT To:<root>
050 >>> DATA
050 250 2.1.5 ok
050 354 go ahead
050 >>> .
050 250 2.1.5 root OK
050 <root@OLMXDB.OLAMNET.COM>... Sent
250 2.0.0 nBO6U25X029484 Message accepted for delivery
ashokdb2k@gmail.com... Sent (nBO6U25X029484 Message accepted for delivery)
Closing connection to [127.0.0.1]

QUIT

221 2.0.0 OLMXDB.OLAMNET.COM closing connection

807557

Hi,

Thanks for that can you run the following commads:

mailq
grep DS* /etc/mail/sendmail.cf
nslookup gmail.com
nslookup mailhost.OLAMNET.COM

Also after you make changes to the sendmail file you need to refresh the sendmail service so it picks up the new config.

user4994457

ASHOKDB2k wrote:
# mail -s "HELLO" ashokdb2k@gmail.com

Nothing happens after this... i tried with different mail id's and different mail servers but all failed.
can someone help me in troubleshooting this issue?

It's sitting there waiting for you to type in your message, and then send an EOF to signal the end of the message. For a mailer with a little more verbosity, try replacing 'mail' with 'mailx'.

--
Darren

807557

Hi Chris & Darren,

Thanks for your updates. Currently i have resolved the issue and i am able to send mail to gmail & yahoo accounts. The issue was with my domain name present in /etc/hosts file and settings in /etc/nsswitch.conf file.

But i am unable to send any mail's to my company's POP3 mail server email accounts.

# mailq
/var/spool/mqueue is empty
Total requests: 0

# grep DS* /etc/mail/sendmail.cf
##### SENDMAIL CONFIGURATION FILE
##### DO NOT EDIT THIS FILE! Only edit the source .mc file.
#O DontBlameSendmail=safe
# default LDAP map specification
# need to set this now before any LDAP maps are defined
#O LDAPDefaultSpec=-h localhost
# my LDAP cluster
# need to set this before any LDAP lookups are done (including classes)
#D{sendmailMTACluster}$m
#Dj$w.Foo.COM
DS
DnMAILER-DAEMON
CPREDIRECT
DZ8.13.8
O DeliveryMode=background
#O IgnoreDots=False
#O HostStatusDirectory=.hoststat
# single thread deliveries (requires HostStatusDirectory)?
#O SingleThreadDelivery=False
O DaemonPortOptions=Name=MTA-v4, Family=inet
O DaemonPortOptions=Name=MTA-v6, Family=inet6
O DaemonPortOptions=Port=587, Name=MSA, M=E
#O DirectSubmissionModifiers
O QueueDirectory=/var/spool/mqueue
# time for DeliverBy; extension disabled if less than 0
#O DeliverByMin=0
#O DontPruneRoutes=False
# default UID (can be username or userid:groupid)
#O DefaultUser=mailnull
#O UserDatabaseSpec=/etc/mail/userdb
#O DelayLA=0
#O MaxDaemonChildren=0
#O DefaultCharSet=unknown-8bit
#O DialDelay=0s
#O DontExpandCnames=False
#O DontInitGroups=False
#O DoubleBounceAddress=postmaster
#O DeadLetterDrop=/var/tmp/dead.letter
#O DontProbeInterfaces=False
# Return-Receipt-To: header implies DSN request
#O RrtImpliesDsn=False
# Data file (df) memory-buffer file maximum size
#O DataFileBufferSize=4096
#O MailboxDatabase=pw
# override compile time flag REQUIRES_DIR_FSYNC
#O RequiresDirfsync=true
#O AuthMechanisms=EXTERNAL GSSAPI KERBEROS_V4 DIGEST-MD5 CRAM-MD5
#O DefaultAuthInfo=/etc/mail/default-auth-info
# DHParameters (only required if DSA/DH is used)
#O DHParameters
# QUEUE GROUP DEFINITIONS #
H?D?Resent-Date: $a
H?D?Date: $a
# HPosted-Date: $a
# H?l?Received-Date: $b
# addresses sent to foo@host.REDIRECT will give a 551 error code
R$* < @ $+ .REDIRECT. > $: $1 < @ $2 . REDIRECT . > < ${opMode} >
R$* < @ $+ .REDIRECT. > <i> $: $1 < @ $2 . REDIRECT. >
R$* < @ $+ .REDIRECT. > < $- > $#error $@ 5.1.1 $: "551 User has moved; please try " <$1@$2>
# handle non-DNS hostnames (*.bitnet, *.decnet, *.uucp, etc)
R<TEMP> $* $#error $@ 4.1.8 $: "451 Domain of sender address " $&f " does not resolve"
R<PERM> $* $#error $@ 5.1.8 $: "553 Domain of sender address " $&f " does not exist"
R<FORGED> $#error $@ 5.7.1 $: "550 Relaying denied. IP name possibly forged " $&{client_name}
##### MAIL FILTER DEFINITIONS
##### MAILER DEFINITIONS
R$+ $: $>AddDomain $1 add local domain if needed
R$+ $: $>AddDomain $1 add local domain if needed
R$+ $: $>AddDomain $1 add local domain if needed
SAddDomain
Mlocal, P=/usr/lib/mail.local, F=lsDFMAw5:/|@qPSXmnz9, S=EnvFromSMTP/HdrFromL, R=EnvToL/HdrToL,
T=DNS/RFC822/SMTP,
Mprog, P=/bin/sh, F=lsDFMoqeu9, S=EnvFromL/HdrFromL, R=EnvToL/HdrToL, D=$z:/,
Msmtp, P=[IPC], F=mDFMuX, S=EnvFromSMTP/HdrFromSMTP, R=EnvToSMTP, E=\r\n, L=990,
T=DNS/RFC822/SMTP,
Mesmtp, P=[IPC], F=mDFMuXa, S=EnvFromSMTP/HdrFromSMTP, R=EnvToSMTP, E=\r\n, L=990,
T=DNS/RFC822/SMTP,
Msmtp8, P=[IPC], F=mDFMuX8, S=EnvFromSMTP/HdrFromSMTP, R=EnvToSMTP, E=\r\n, L=990,
T=DNS/RFC822/SMTP,
Mdsmtp, P=[IPC], F=mDFMuXa%, S=EnvFromSMTP/HdrFromSMTP, R=EnvToSMTP, E=\r\n, L=990,
T=DNS/RFC822/SMTP,
Mrelay, P=[IPC], F=mDFMuXa8, S=EnvFromSMTP/HdrFromSMTP, R=MasqSMTP, E=\r\n, L=2040,
T=DNS/RFC822/SMTP,
#

nslookup MYMAILSERVERIP

# nslookup MYMAILSERVERIP
Server: 203.208.224.91
Address: 203.208.224.91#53

Non-authoritative answer:
36.6.127.203.in-addr.arpa name = mail.XXXX.com.

Authoritative answers can be found from:
6.127.203.in-addr.arpa nameserver = dnssec2.singnet.com.sg.
6.127.203.in-addr.arpa nameserver = dnssec3.singnet.com.sg.
6.127.203.in-addr.arpa nameserver = dnssec1.singnet.com.sg.
dnssec1.singnet.com.sg internet address = 165.21.83.11
dnssec2.singnet.com.sg internet address = 195.13.10.226
dnssec3.singnet.com.sg internet address = 165.21.100.11

#

nslookup mailhost.OLAMNET.COM

# nslookup OLMXDB.OLAMNET.COM
Server: 203.208.224.91
Address: 203.208.224.91#53

** server can't find OLMXDB.OLAMNET.COM: NXDOMAIN

#

Please advice...!!!

Regards,
Ashok Kumar.G

807557

If you can send email to a yahoo and gmail account from your server does your internal email accept external email? If it does then can you try the following command and post the result:

date | mailx -s "test email" gmail-email-address,internal-email-address

1 - 8

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 3 2008

Added on Oct 2 2008

#business-intelligence-applications, #business-intelligence-foundation, #hyperion-query-and-reporting, #prompt, #report

5 comments

627 views

Analytics Software

Financial report Prompt

Comments

Post Details