[OAUGNet]-Problem with PA AutoAccounting (Event Revenue Account function)

["Zimmerman, Wade" <zimmermanwade@lcsnet.com>]

Hello everyone.  I am hoping that one of you has a quick answer for this
frustrating issue.

We are using SQL to determine the Natural Account value for the Event
Revenue Account function in Projects.  I am receiving an error of
'PA_AA_NO_ROWS|RULE|2_NaturalAccount_Event_Type_Spec_Fee'.

The SQL is as follows:
select decode(paa.attribute1, 'Y', 'Speculative Fee', :2) 
from pa.pa_projects_all paa 
where segment1 = :1

1=Project Number and 2=Event Type

The Function then uses the result to pull the correct value from a
Lookup Set.

Basically, if the DFF in attribute1 = Y, then we need the Lookup Set to
use the value of Speculative Fee, otherwise the Lookup Set will use the
Event Type to pull the Natural Account Value.

I tried using a CASE statement but ended with the same result.

I also tried replacing 'where segment1 = :1' with 'where project_id =
:1' and changed 1 to reference Project ID but then the process ends in
error status with the message 'AA-paxsql'.

Does anyone have any ideas?  Am I able to use a DFF in my
AutoAccounting?

The process runs perfectly in TOAD.

Wade K. Zimmerman
ERP Financial Systems Manager
 
zimmermanwade@LCSnet.com
 
CONFIDENTIALITY NOTICE: This electronic mail transmission and any
documents accompanying this electronic mail transmission is intended by
Life Care Services LLC for the use of the named addressee(s)to which it
is directed and may contain information that is privileged, or otherwise
confidential.  It is not intended for transmission to, or receipt by,
anyone other than the named addressee(s) (or a person authorized to
deliver it to the named addressee(s)). It should not be copied or
forwarded to any unauthorized persons. If you have received this
electronic mail transmission in error, please delete it from your system
without copying or forwarding it, and notify the sender of the error by
reply e-mail or by calling Life Care Services LLC at (515) 875-4500, so
our address record can be corrected.
 


#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>