@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, I'm new to OTBI & FDI and need your help. Is it possible to do a report to identify missing default expense account in FDI or OTBI? Thanks for your help.
Hi Team We are using SCM- Maintenance subject areas for reporting . We enabled the Asset related DFFs (CSE_ASSETS_B) under Data Configuration successfully but the Asset DFFs are not reflecting under Descriptive Flexfield Folder . We do not see any Asset folder even under the Descriptive Flexfield folder . Please advise if…
We made some changes in the Fusion UI, and those changes were reflected correctly in OTBI but not in FDI. To refresh the data in FDI, the Oracle support team advised me to reload the relevant functional area (Absence Management). I navigated to Application Administration → Human Capital Management, selected Absence…
Data are synchronized with Oracle HCM and I can see PN 2470, which was terminated in the past. If I add any assignment information I find no records, why?
In an analysis/report, when the Bottom Up Manager details are selected from the hierarchy, the Top Position Person record drops out. This is due to the fact that this top level position does not have a record in the Fusion table : PER_MANAGER_HRCHY_CF which is the source to load OAX$OAC.DW_MANAGER_CF_DH . The requirement…
