Hi @User_1BMP8 Audit columns like LAST_UPDATED_BY, LAST_UPDATED_BY will help you find the information you are looking. Regards Venkat

Hi @Dawn Cawston - CPS Not sure whether you are able to resolve this issue. If not, you can give it a try by creating a new column with expression in your report with a RANK function. Idea is to Rank the employees based on the working pattern start date and filter rank=1 to get the first working pattern record to see the…

Hi Yes, it is possible. With out converting to sql means you mean selecting the option "Convert this filter to SQL"? Yes by clicking the AND condition will change the filter to OR and we can keep adding nested OR filters as shown Regards Venkat

ok, I'm not sure whether applying max() is functionally the correct way to eliminate multiple records with duplicates.. Technically yes, it helped to remove duplicates.. It should be handled via date criteria or some other additional conditions to eliminate the multiple records for the same employee for performance rating…

Hi @AjayKumar Maddipati I presume you are using Workforce Performance - Performance Rating Real Time subject area to build this report. In your report along with Performance Rating.Rating Level.Rating Level, can you also use date from and date to check if those null records has any active date tracking. In that case, you…

Hi @satya_nvs You could achieve this by using regular expression in the reporting column expression to separate alphabets from string of characters. E.g. To extract numbers EVALUATE('REGEXP_REPLACE(%1,%2)',"Fiscal Calendar"."Accounting Period Name",'[^[:digit:]]') To extract alphabets…

Hi @Stefan pettersson You could define the formula as below No of Positive Values: SUM(CASE WHEN "Facts"."Amount">0 THEN 1 ELSE 0 END) Count of All Values: count("Facts"."Amount") % of Positive Values: (SUM(CASE WHEN "Facts"."Amount">0 THEN 1 ELSE 0 END)/count("Facts"."Amount"))*100 Have used both table view and pivot view…

Hi You could select each of the set operation and click on the filter button above as highlighted to see the filters applied Regards Venkat

Since your requirement is to pivot the data (rows to columns), then you could create a pivot table view while creating the report instead of table view. I suppose that will solve your issue Regards Venkat

Hi, Please check this oracle doc id in support.oracle.com You may find this useful. Oracle Fusion Recruiting Cloud: OTBI: How to Report on Request Information Questions and Responses (Doc ID 2693295.1) Subject Area: Recruiting - Recruiting Real Time Dimension/Folder: * Job Application > Request Info Questionnaire Responses…

Hi You could use OAC evaluate function to execute a db function for regexp_replace to achieve this. Something like evaluate('regexp_replace (%1, %2)','Hello &nbsp','&nbsp') Regards Venkat

Hi Laxmish, You can define a session variable for PORTALPATH which gets initialized for all the users with the default landing page. How To Use Session Variable PORTALPATH? (Doc ID 2215294.1) Regards Venkat

Hi Bharath Thanks for the input. The challenge here is every recipient will have multiple combinations of parameter selections for report executions and each of that combinations will have to be selected ,executed and delivered in a recurring mode one after the other. E.g. Recipient 1 1) Ledger 1, Location 1, Department 1,…

Hi Indra, Based on the user selected period/date or current date, have a row-wise initialization in the RPD for no of dates that you want to calculate/initialize using the initialization query based on the current date and use them in the column headers as below. You could use the server variable and fix that in the column…

Hi Narayan, Already explored this option but this wouldn't work for this requirement. We cannot be definite of the IP ranges of the login users. So if we set this up, it can either accept all IP/will deny access if it falls with in that IP range. But it should accept connections if it falls in the IP range but should also…

Thank you, Much appreciate your response. Yes, it is possible to achieve via coding as a post agent step where there needs to be an intermediate steps to process and move the file to a stage before uploading to the target location. It would be nice to have a no code solution in OACS where the customers will be able to…

Hi @mickel rmeily Yes it should be put in the edit formula. Like below Pls replace "Summary"."Actual Sales Amount" below in the edit formula with the actual measure that you are trying to report. If you still face difficulty, please share the XML from the Advance XML table and will modify and share the XML back where you…

Hi @mickel rmeily Yes in the edit formula Pls replace the "column" with the actual measure column ifnull("Project Billing - Revenue Transaction RealTime"."Revenue Transaction Measures".Revenue Amount",0) Regards Venkat

Hi @CarolineAnderson Furthermore, we can add a formula Fact.Colum1-Fact.Colum1 to the ELSE condition which will always equates to 0. So we don't need to worry about ELSE being evaluated if the first condition is false. Its just an hack :) to make the calculation as a measure column CASE WHEN Requisition Status='Pending'…

Hi @mickel rmeily If you have created a table view, then you can have a formula with an expression as below ifnull(column,0) if you have created a pivot view, then you can suppress null with 0 by modifying the column data format with number format as #,##0;-#,##0;0 Hope this helps Regards Venkat

Hi @CarolineAnderson You could add an ELSE condition to your CASE statement and then add a fact measure column to the ELSE part of your condition. As far as your query is not evaluated for ELSE and satisfies your first criteria, this calculation measure would give you the desired results and this way it can be treated as a…

Hi In such cases, when there is missing last update date/create date in the PVO, do a full data extract of the PVO and do a comparison with last extract with current extract to identify the delta changes (MINUS operation) in the target system/extraction process. The PK of this PVO is Fullfilllineid Other method is to use…

Hi Abhishek You need to replace the D_DAY with your actual time dimension table. This table is given for reference purpose. If you are using FAW, then I think the table is W_DAY_D. Pls give a try Regards Venkat

Hi Below query snippet will help to identify the days excluding weekends. D_DAY is the time dimension at day level. You need to pass requisition creation date as 1-Jan-2022 and requisition end date as 15-Jan-22 in the query as commented below to calculate requisition posted days. You need to replace them with actual db…

This feature is currently not available. There is an ER Enhancement Request 34045416 - FREQUENT FAW REFRESH is already logged. This feature will be able in future release of FAW (probably by End Of September 2022).

Hi Amrita, You could try running an OTBI report on the PO Headers subject area for the DFF attribute to see if it has an reference to this PVO in the query log. Ideally you should be able to add via a custom data store as illustrated here which was last updated on Sep 8, 2022. So I presume, this content is latest. FA BICCC…