List of Contributions

Aaron, In my experience, I've never been able to create a query in PSQuery without at least one record in the FROM statement. However, there may still be a solution to your issue. Here at CU, we have a record named PTIA_DUAL. It has a single field named PTIA_DUMMY which always returns a value ...

Thanks Scott. The Oracle docs don't indicate whether there is a difference between HCM and CS when it comes to the PERS_REFRESH app engine. My assumption is that they are the same. The Oracle docs also don't mention if PERS_REFRESH is configurable. I was assuming it wasn't and that the field mapping ...

Does anyone have documentation, or method for discovering/documenting how and where each field in the PERSONAL_DATA record in Oracle HCM is sourced, without guessing? Oracle indicates that PERSONAL_DATA is not (or at least is no longer) a parent-record itself. Rather, it is a "transaction record", ...

Thanks for providing the character limit for the prompts Scott. I'm always learning from you. To be honest, I don't know if there is an advantage to the REGEXP_ I haven't used this expression in a few years. I just remembered having it in my "bag of dirty tricks and hacks" and thought I'd throw ...

Good morning Bob & Kendall, I wasn't able to locate Post #44 in my blizzard of emails, so I apologize if this is redundant. I use the following INSTR expression and criteria. As previously mentioned, this method is limited by the field width of PSQuery prompts, and by the character-count of whatever ...