Analytics Software

Hi all,
I hope someone has the patience to help me.
I have sifted through several threads and tried various things without total success.
I have the following columns:

Client Surrogate Key,(Integer),(Surrogate Key),Mapping:sequence.nextval,ODI-Key:Y
Client Master AC No,(Varchar2(10)),(Natural Key),Mapping:Equivalent Source Column,ODI-Key:Y
Client Account ID,(Number(10)),(Natural Key),Mapping:Equivalent Source Column,ODI-Key:Y
Client Status,(Number(3)), (Insert Row),Mapping:Equivalent Source Column
Client Credit,(Number),(Overwrite Column),Mapping:Equivalent Source Column
Starting Timestamp,(Date),(Starting Timestamp),Mapping:Tried No Mapping or sysdate
Ending Timestamp,(Date),(Starting Timestamp),Mapping:Tried No Mapping or 01/01/2400
Current Record Flag,(Number(1)),(Current Record Flag),Mapping:Tried No Mapping or 0

There are no phsyical keys on the target table.
I am starting with an empty target table.
IKM Oracle Slowly Changing Dimension - I have unchecked 'Journalized Table in the Staging Area'

Execution fails at 'Historize old rows' step ...

Operator Exceution Tab ...
--------------------------------
1747 : 42000 : java.sql.SQLException: ORA-01747: invalid user.table.column, table.column, or column specification
java.sql.SQLException: ORA-01747: invalid user.table.column, table.column, or column specification

Operator Description Tab ...
---------------------------------
update DWDIMS.CLIENTS_ACCOUNTS_DIM T
set (



) = (
select


from DWSTAGE.I$_CLIENTS_ACCOUNTS_DIM S
where S.CLIENT_MASTER_AC_NUMBER = T.CLIENT_MASTER_AC_NUMBER
and S.CLIENT_ACCOUNT_ID = T.CLIENT_ACCOUNT_ID
and S.IND_UPDATE = 'I'
)
where (T.CLIENT_MASTER_AC_NUMBER, T.CLIENT_ACCOUNT_ID)
in (
select X.CLIENT_MASTER_AC_NUMBER, X.CLIENT_ACCOUNT_ID
from DWSTAGE.I$_CLIENTS_ACCOUNTS_DIM X
where X.IND_UPDATE = 'I'
)

-----

Any assistance is very welcome.
Regards
Tony