Hello - in a nutshell…no DFFs are delivered "out of the box". - DFF functionality is provided for you to configure your own as required. Go to Set up & Maintenance > Manage descriptive flexfields, then you can add you own where you want them. Eg for employee assignments, this will be under "Assignment Attributes". Once…

Hello the majority of Finance tables are not data-tracked like HR. If you change the GL combination, you are just overwriting it, so the previous value is lost. I think the only way to track the previous value, is to turn on auditing but this would add an overhead to the system, so its not really recommended unless…

Hi Advanced Tab > Prefix SET VARIABLE PARAM_EFFECTIVE_DATE can be used to run report as at a specific date. EG to run report as at 2021-01-01 : SET VARIABLE PARAM_EFFECTIVE_DATE= '2021-01-01'; For users to set the date - set up a dashboard prompt and set the results to a presentation variable eg VAR_DATE Then just use this…

Use the lineage mapping spreadsheet https://community.oracle.com/customerconnect/discussion/40249/hcm-otbi-subject-areas-to-database-lineage-mapping-spreadsheet

hiya yeah, i've not been able to find anything for OTBI myself. For on-premise, could query the the Agent table, S_NQ_JOB - but even this only had details such as job name, run date etc….didn't have details of Emails sent. And assuming this table still exists in cloud, can't find a way to query it. Can look at the usage…

Hello several posts about this subject already on this forum. This one says not possible and includes link to idea to vote https://community.oracle.com/products/oracleanalytics/discussion/22756/cloud-fusion-bi-publisher-ways-to-confirm-if-the-email-from-bursting-was-actually-sent-out-or-not

hi yes "Payroll Costing Setup Details Real Time" is correct subject area - thats what we use. Can you elaborate why its not returning correct data? Only issue we have, is the Costing subject area does not have a common "Worker" dimension for some reason, so this makes joining to other subject areas tricky and therefore…

@Riyaz Ali-Oracle isn't that what I said above?

Hello - either use pivot table - put comments as a measure and set the aggregation to Max or create separate case statements Data: Via Pivot Table: Via Separate Case statement columns using table Manager: max(case when "Performance Document Participant"."Role Definition" = 'Manager' then cast("Document and Rating…

Ah "applications" as in job application…i see…thought you meant application setup. Sorry not sure on that we don't use recruitment - isn't there a recruitment SA where can report on application statis? - create a report then look at the SQL then use that if need a BIP report? or can just create a BIP report using a data…

What is an incomplete application? You mean some module which config isn't complete? not sure how you can tell that - alot of functionality is optional

hi yes - how have you created the report? just take it out of that. eg if via the GUI, just don't include it - person_id excluded in example below Or if created a RTF template just don't included those fields don't want in the template

Presume you mean via sql? Manager is obtained via table per_assignment_supervisors_f. Smple query below for an Emps manager If you want the manager's manager - you just need to add the relevent tables again and do required joins. (or could also do a hierarchical level query) select ppf.person_number, ppfsup.person_number…

hi the question in the post was how to combine SAs. If you are getting an error - that is a different question. Suggest you provide further details / sample XML etc and explain what you are trying to achieve

Click on the "Add subject area" icon

ah yes sorry i misunderstood the initial question….not sure if that is achievable then

hi yes …so just try the same solution as for analytics - removed the pod info…. i don't know if this will work or not but its worth a try

hi no process im aware of - its instantaneous for me - ie set a SA to "deny" > create new analysis > SA now not visible. I have all the top level roles too - admin, integration ,security manager etc and the "deny" works for me. Sorry, not sure what else to suggest

I have BI admin and cant see it once denied - thats what we do for all the SAs that we dont use…just try it out…presume you have test envs

Hi - its works for me - try clearing your browser cache etc I can only see what has been granted