Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
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 https://community.oracle.com/customerconnect/kb/articles/1-accepted-answer
-
Hi, Please check the below: PVO that is exposed public view for IBY_PAYMENTS_ALL table that is available in BICC — Cloud Customer Connect Thanks, Riyaz Ali
-
Hi, Please check below: What do I do when I get a BI report time-out error? Thanks, Riyaz Ali
-
Hi SarahDonoghue, Please check below: Workforce Management - Worker Assignment Real Time Thanks, Riyaz Ali
-
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,…