List of Contributions

Good morning Pheng, Assuming this is an optional Prompt, have you tried leaving the value completely blank? What is the query performance like if you delete the prompt and hard-code a value in criteria? I work in HCM, so my system isn't exactly the same as yours. But when we write prompts, ...

Good morning Lidia, I'm not sure if your question was just about criteria for determining what the B.LINE_AMT "type" was for each row (Charge, Payment, Refund), or if it was also about report formatting to match the needs of your vendor. I can't help with the first, as I only work in HCM (on the ...

Very interesting idea. I'm assuming you want to do this in PSQuery/Query Manager... I just created an ad-hoc query as a quick test. I WAS able to use a number as a default prompt-value and then use that prompt within an expression that performs a calculation. The prompt field type was Number, the field ...

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 ...