Hi, Can you share the apply_patches_import.txt file you edited before applying the patch to check once.. Thanks, Yaswanth

Hi, This issue comes when the orainventory folder is different from the one BIAPPS is referring. I too faced the similar issue and debugged a lot and found the root cause. 1. Please check your /home/ where you can see oraInventory folder. Open that. 2. Open the middleware folder, you will find one more oraInventory. 3.…

Hi, We got the same requirement and I thought and implemented the below approach.. 1. Create helper report. Report with employee number/ username, department 2. In the main report, use a filter where department in (select department from helper report) 3. Based on above result, you will get all the departments.. So, we…

Hi, Can you check the source column from where the BASE_ORG_NUM and INTEGRATION_ID are getting populated. One possibility will be in source the column might have different data. If that's not the case, the domain mapping needs to be done from our end in BIACM to make sure that the both columns are identical. Have you done…

Hi, Can you share us the bi server log to check in detail. Thanks, Yaswanth

Hi, Try logging in to below schema's from database and check if you are able to login (PRD_BIA_ODIREPO and PRD_DW). Regards, Yaswanth

Hi, If possible can you share the query of the failed scenario. Regards, Yaswanth

Hi, If possible, can you please share the query at which step you are facing this error from the session log so that it will be easy to debug. Thanks, Yaswanth

Hi, This will just returns the complete name of a physical object, including its catalog and schema name. If you open this function, the implementation syntax will be <%=odiRef.getObjectName("L","$(VALUE)","D")%>. So, it will just get object name. For more info, you can refer getObjectName() Thanks, Yaswanth