DAC is not able to read source tables on EBIZ even though DB user has the access. I am trying with Read User A , but the tables are present in User B(APPS),C(CSI),D(OKC) ects.
On the Oracle SQL Developer User A is able to read tables in User B,C,D. But when i use the same user(A) to import the tables present in B,C,D DAC is not reading them to import.
I am using the process (Design-> Tables->Right Click->Import from DB ->Import DB tables --> Source Connection)
Option: Tried manually entering the source tables (Design-> Tables) and added in Individual Task (Task--> Source Tables->Add Remove) as one of the Source table.
This is creating an issue
Design-> Tables->Right Click (on the table created manually) Related Tasks--> ALL--> "Failed to Read Related Task" ERROR Message
Any pointer would greatly help.
Can you verify for any other table for UserA from DAC side?
like find a table just delete one of column from columns list then save and then try to import the same again etc
that should tell you something