Records getting created in Global domain through Inbound integration but not visible inCompanyDomain

[Obito]

Hi All,

I am facing issue when records getting created in Global domain through Inbound integration but these records are not visible to company domain users. Is there any specific reason which is why this is happening.

Thanks

[Sohail Khilji]

Hi @Obito ,

This issue can occur when the datatype of the "sys_domain" column of the affected table is set to something other than CHAR (for example, VARCHAR2). Typically, the sys_domain field is a CHAR datatype, which means that all values are padded to 32 chars. So, the values you see where global is padded with spaces is correct (for the normal case where the field is CHAR(32)). Since this instance has a different field type (ex: VARCHAR2), the extra spacing causes problems.

See if it helps...

[Obito · Accepted solution]

Hi ,

Records were getting created into TOP domain because the Integration user's domain was TOP.  & Users being in Company domain was not able to see those records.

Thanks