This content has been marked as final. Show 12 replies
Does your interface/package/scenario fail or succeed?
If failing: in which step is it failing and which error message is shown?
If succeeding: check in which step of the flow that your object is not inserting the records like you want. You can perform all the SQL's manually one by one on the back-end systems to verify where the problem is occurring.
firstly i checked C$ table there in operator it shows no of rows 10 but when i checked that table no rows are there.Are you talking about No. of Insert or No. of Rows ? Those 2 are different .
If it is No. of Insert , then those record should be there in your c$ table.
What you can do is that copy the select part of the query which loads into c$ table , run the same in a sql cient like toad , sql*plus etc and see if it is returning data or not.
from REF_DATA_DB.BANKING_INSTITUTION BANKING_INSTITUTION
insert /*+ append */ into XXSVB.C$_0XXSVB_BANKS_STAGING
As you said you see the data in C$ but not in I$ or Target . am i right ?
First check if the data you are trying to load is not already present in the target . As you have mentioned you are using Oracle Incremental Update and it check with the target for insert/update records , if records already present they wont be loaded into I$ or Target .
If that is not the case make sure your commit is true.
Hope this helps.