In the General Ledger Transactional Balances Real Time, there are measures for "Entered YTD CR" and "Entered YTD DR". This gives totals for the calendar year. How do I update this to return sums for the FY (Jul 01 - Jun 30)?
These are the formulas…assuming you are filtering on accounting period name, and filter on balance type (ie: A for Actual). Attached is XML for a simple version with prompts for concatenated segment and accounting period name. (Just copy/paste this into new analysis in advanced section, copy the entire file, replace what is in Analysis XML with the data in .txt file and click apply xml, then you can go back to criteria tab/etc to see the design)
Beginning Balance
"- Balance"."Beginning Balance"
Period Net Activity
"- Balance"."Period Net Activity"
Ending (YTD) Balance
"- Balance"."Ending Balance"
Thank you!
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
we have a requirement to fetch Worker Historic information like Current Job Title Previous Job Title Previous Department New Department Previous Manager New Manager Previous Location New Location which subject area stores this information in the OTBI?
Could you please provide an update on when the 26C Deprecated BI View Objects document will be available? As Oracle Cloud 26C is scheduled to roll out soon, with test environments expected to be updated on August 7, followed by the production release on August 21, we have a limited window to review and assess any potential…
Hi team, I would like to add the work order notes to my work order schedule calendar, but I'm unable to find where these notes are stored and what otbi subject to use to access them. Be great if I can be pointed in the right direction, thanks
