Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Hi User_8O8W5 , Try the below options: Option 1: Use “Supplier Status” from Supplier Profile If available in your environment, look for: "Supplier"."Supplier Status" Filter: Supplier Status is equal to 'Active' However, this field may not be exposed in all Fusion environments or may be hidden due to role-based access.…
-
Hi SarahDonoghue, Try the below options: Use Workforce Management – Worker Assignment Real Time instead. This subject area: Returns current assignment data as of a given date Supports effective date filtering via: SET VARIABLE PARAM_EFFECTIVE_DATE = '@{P_DATE}{2025-06-30}'; Is better suited for headcount and FTE trending…
-
Hi All, Please check the below KM note: Oracle Fusion BI Publisher: Parameter Search Window displays only a partial list of the expected values (around 999 rows) (Doc ID 2079456.1) Oracle Fusion BI Publisher: Parameter Search Window displays only a partial list of the expected values (around 999 rows) KB67172 Thanks, Riyaz…
-
Hi User_SA32B, Ckeck below: Overview of Dunning You could also try posting it in the product specific analytics forum and there are better chances of getting the right guidance. Thanks, Riyaz Ali
-
Hi, You can create a hyperlink in the first report (Project) that passes parameters (like Project ID) to the second report (Cost per Project). Steps you can try:Enable Parameters in the Target Report In the Cost Report, define Project ID as a report parameter. Make sure it accepts values passed via URL. Construct the…
-
Check this: Could not establish connection. Connection to Microsoft Azure SFTP server is not supported at this time. (Doc ID 2983577.1)
-
If my response has answered your question or assisted you with your concern, please click"yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for
-
Hello Craig W NNL, Please check the below: SQL for Current approver of AP Invoice — Cloud Customer Connect Try this: SELECT ai.invoice_id, ai.invoice_num, aiah.approver_id, fu.user_name AS approver_user_name, aiah.approval_history_id, aiah.action_date, aiah.history_type, aiah.approver_action FROM ap_invoices_all ai JOIN…
-
If my response has answered your question or assisted you with your concern, please click"yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for
-
Try the below: Suppress Blank Lines with <?if:condition?>...<?end if?> Use inline formatting like: <?if:FIELD!=''?><?FIELD?><?end if?> Check the below: Setting Report Processing and Output Document Properties
-
Ho @Anil Pandey-Oracle, Try the below:Use normalize-space() in the RTF Template Wrap your field expression like this: xml Avoid fo:bidi-override Unless Necessary While fo:bidi-override helps with left-to-right formatting, it can introduce Unicode control characters. If your data is already left-to-right (e.g., numeric…
-
Hi @Mark Stoker, You could also try posting it in the product specific analytics forum and there are better chances of getting the right guidance. Thanks, Riyaz Ali
-
Try running the below: Run the “Refresh Manager Hierarchy” Process Run “Synchronize Person Records”
-
Hi @AVorster-Oracle, As I mentioned earlier, You could also try posting it in the product specific analytics forum and there are better chances of getting the right guidance. Thanks, Riyaz Ali
-
Hi @User_KNFCO , Please try the below: SELECT ID, Test_Date, Test_Type, Test_Result, COUNT(*) OVER ( PARTITION BY ID, Test_Type ORDER BY Test_Date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW ) AS Attempts FROM ( SELECT *, MIN(CASE WHEN Test_Result = 'Pass' THEN Test_Date END) OVER (PARTITION BY ID, Test_Type) AS…
-
Hi @AVorster-Oracle, Please check this: Delivered Reports in Fusion HCM — Cloud Customer Connect What all are the standard reports available in Oracle Fusion HCM? — Oracle Analytics You could also try posting it in the product specific analytics forum and there are better chances of getting the right guidance. Thanks,…
-
Hi @Amit Kumar Sah , You could also try posting it in the product specific analytics forum and there are better chances of getting the right guidance. Check this: Preview Invoice Report Thanks, Riyaz Ali
-
Hi @Anjum Saeed , If my response has answered your question or assisted you with your concern, please click"yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Thanks, Riyaz Ali
-
Please check below: Create a Chart from an OTBI Analysis Graph Data in Analyses
-
If you are not getting the "Bar width" , "Bar gap" or "Cluster width".Try the below:Change the Graph Type Switch between Vertical Bar, Horizontal Bar, or Clustered Bar. Clustered Bar graphs naturally introduce spacing between categories. Limit the Number of Categories Fewer categories on the X-axis = more space between…