RE: Query - overLimitAmount

 jain cj wrote:

> 
> When I am running a query like this
> 
> *******************************************************
> SELECT
>          	(SELECT LineOfCredit FROM SI_LoanProduct WHERE 
> acct.FinancialControlId =
>             SI_LoanProduct.ProductId) AS LineOfCredit,
> 	(acct.acctBalance - la.CreditLimit) as overLimitAmount
> FROM
>          SI_accountPortfolios acpf,
>          SI_productProperties pp,
>          SI_accountAssociates assoc,
>          SI_FinancialControls fc,
>         SI_Accounts acct,
>         SI_LOANACCOUNT la
> WHERE
>         assoc.isDeleted = 'N' AND
>         acpf.CustomerId <> 1 AND
>         assoc.AssociateCustId = 1 AND
>         acpf.AcctPortfolioId = acct.acctPortfolioId(+) AND
>         acct.FinancialControlId = pp.ProductId  AND
>         acct.deleted = 0 AND fc.FinancialControlId = 
> pp.ProductId   AND
>         (la.Undone = NULL OR la.Undone = 0) AND
>         assoc.accountId = acct.accountId AND acct.accountId = 
> la.accountId(+)
> *************************************
> 
> 
> getting an error
> *****************************************************
> 
> 
> ---- Error -------------------------------
> Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
> General error;-8 POS(12) Execution failed, parse again.
> SELECT
>          	(SELECT LineOfCredit FROM SI_LoanProduct WHERE 
> acct.FinancialControlId =
>             SI_LoanProduct.ProductId) AS LineOfCredit,
> 	(acct.acctBalance - la.CreditLimit) as overLimitAmount
> FROM
>          SI_accountPortfolios acpf,
>          SI_productProperties pp,
>          SI_accountAssociates assoc,
>          SI_FinancialControls fc,
>         SI_Accounts acct,
>         SI_LOANACCOUNT la
> WHERE
>         assoc.isDeleted = 'N' AND
>         acpf.CustomerId <> 1 AND
>         assoc.AssociateCustId = 1 AND
>         acpf.AcctPortfolioId = acct.acctPortfolioId(+) AND
>         acct.FinancialControlId = pp.ProductId  AND
>         acct.deleted = 0 AND fc.FinancialControlId = 
> pp.ProductId   AND
>         (la.Undone = NULL OR la.Undone = 0) AND
>         assoc.accountId = acct.accountId AND acct.accountId = 
> la.accountId(+)
> 
> ***************************************************
> 
> It is successfully running in oracle(There is no record selected)...I 
> created the same table structure in
> sap db..so what is the problem...expecting the reply

Which version do you use?
We need a vtrace of that topic according to 
http://sapdb.2scale.net/moin.cgi/VTrace

Elke
SAP Labs Berlin