I have a few views that generate errors in Visual Studio. The error is "Value cannot be null. Parameter name: key"
Here is the SQL for the view:
CREATE OR REPLACE FORCE VIEW "STRM"."ACCT_ACCOUNT_BALANCE"
AS
SELECT "A"."ACCOUNT_ID",
NVL("B"."BALANCE", 0)
FROM "STRM"."ACCT_ACCOUNT" "A",
(SELECT "ACCOUNT_ID",
SUM("AMOUNT") AS "BALANCE"
FROM (SELECT "TRANSACTION_ID",
"ACCOUNT_ID",
-"AMOUNT" AS "AMOUNT"
FROM "STRM"."ACCT_TRANSACTION" "T",
"STRM"."ACCT_TRANSACTION_TYPE" "TT"
WHERE "T"."TRANSACTION_TYPE_ID" = "TT"."TRANSACTION_TYPE_ID"
AND "TT"."IS_CREDIT" = 1
AND "T"."IS_VOID" = 0
UNION
SELECT "TRANSACTION_ID",
"ACCOUNT_ID",
"AMOUNT"
FROM "STRM"."ACCT_TRANSACTION" "T",
"STRM"."ACCT_TRANSACTION_TYPE" "TT"
WHERE "T"."TRANSACTION_TYPE_ID" = "TT"."TRANSACTION_TYPE_ID"
AND "TT"."IS_CREDIT" = 0
AND "T"."IS_VOID" = 0
)
GROUP BY "ACCOUNT_ID"
) "B"
WHERE "A"."ACCOUNT_ID" = B."ACCOUNT_ID"(+);
I am fairly new to Oracle, as I usually work with SQL Server. I don't see any obvious syntax errors. Would someone please review my SQL and let me know what's wrong? Thanks.
I'm using version 12.1.0.2.4 of Oracle Tools for Visual Studio with Visual Studio 2013 Premium.