@SARAORC This forum is dedicated to Fusion Data Intelligence. Please confirm the application you are using here? Also provide more details (if possible) screenshots showing the issue.
NOTE: For Fusion related queries we have a separate sister community.
https://community.oracle.com/customerconnect/
Can you please elaborate your query a bit more? What are you trying to build is it an OTBI or a BIP or in FDI?
Thanks.
@MandeepGupta Thanks for the response.
It was a BIP report, I am trying pull the data of entry hours for the salaried employee hours from the state of earnings page.
So, I need to split the hours eg: if the value is 80 I need to split into 8 hrs/day as 10 separate rows.
You can write something like below:
select papf.person_number ,'80' num_of_hours, to_number('80')/to_number('10') per_day_hours from per_all_people_f papf, (select level lvl from dual connect by level <= to_number('80')/to_number('10') ) where trunc(sysdate) between papf.effective_start_date and papf.effective_end_date and lvl <= to_number('80')/to_number('10') and papf.person_number = '269628'
Hi @MandeepGupta
Thanks for the response
Not all the employees have 80 hours some of them have 72 and 64 hours.
Based on the hours I need to split the values.
For Example:
That was just an example. Instead of below:
'80' num_of_hours, to_number('80')/to_number('10') per_day_hours
Use your actual table.column names.
If you are not able to replicate, share the table name and column name, I can try to write it for you.
I try to replicate the table and column with this query, but it is not working.
I am sharing the table and column below.
Table - Pay_Run_Balances
Column - Balance_Value
Could you please write it for me using this table.
In your main select clause:
add below:
Pay_Run_Balances.Balance_Value num_of_hours
,(Pay_Run_Balances.Balance_Value/10) per_day_hours
FROM …..
add a new line in from clause:
,
(select level lvl
from dual
connect by level <= (Pay_Run_Balances.Balance_Value/10)
)
in where clause:
and lvl <= (Pay_Run_Balances.Balance_Value/10)
Thanks for sharing.
Hi, Just done 26.R3 in our test pod, It went in easily enough, added advanced collections etc. Can back after the update completed and we no longer have any subject areas in OAC. Seems the latest update is causing for us a 500 internal server error and we can only access our custom data sources. As we were using FTR which…
Hi Experts, We are trying to create a report using OTBI to extract the PO line amount - Do we have the column which extracts the PO line amount out of the box available under subject area: Procurement-Purchasing Real Time or do we need to calculate it using the formula - PO Line Amount = Ordered Quantity × Unit Price Any…
Under the Workforce - Absence Management subject area, the Total Duration of Absence (Days) field does not return data for Life Leave and Annual Leave Half Pay. As an alternative, I used the Absence Duration field, which successfully captures all leave types. However, it does not correctly retrieve leave records that span…
Hello Experts, I am having issue while working with HCM - Workforce Core in which I am using Person Number and Department Name. The value getting is not in line with the data in my fusion environment. Please guide what I am missing. 26C.
Team, I heard we can use the AI assistance for generating the Start model in the SME. So how to enable this feature as our instances are already in 26.R2 version. Using this blog for reference: Guided Star Schema Generation: Bringing AI-Assisted Design to Semantic Model Customization | analytics Regards, Guru
