Reports
Discussion List
-
How to get Month name as abbrevation concat with year in OTBIHi Experts, Can someone please help me how can we get Month name Concat with year in the same column in OTBI. We have a requirement to show the date's in the below scree… -
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,…
-
Project Costing - Actual Costs Real Time: want to summarize totals by GL expense accountSummary: Project Costing - Actual Costs Real Time: want to summarize totals by GL expense account. The subject area itself includes fields like Natural Account, Concaten… -
AR Transaction Register Report erroring as too many records. how have people got round thisSummary: AR Transaction Register Report erroring as too many records (trying to run for full quarter as needed for external audit). how have people got round this? Conte…Jill Stanton 32 views 7 comments 0 points Most recent by Jill Stanton Reporting and Analytics for ERP
-
Filter Person Number Using Copy PasteSummary: In an OTBI Analysis, is there a way to filter a column based on a copied list of values? For example a column from an excel file or a comma separated list. For …
-
Required Table to get "Add Organizations to Tree" under Manage Project Organization ClassificationsSummary: We are unable to get the right table where the Add organization tree information stored. We tried to link the table PER_ORG_TREE_NODE_RF, PER_ORG_TREE_NODE, FND…
-
How can Fusion BI Report generate two different PDFs for same data at each ESS run.I have a requirement where my report should have two outputs one with all price columns other without for same data. Based on my bursting logic I can generate two emails…
-
TimecardApprovalNotificationReportSummary: I am getting the below error when i try to view the data model of TimecardApprovalNotificationReport HCM folder. Can anyone please suggest the solution. ORA-009…
-
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,…Revital Mefano 787 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Merging Multiple PDF Attachments as Additional Pages in a Single PDF Output BIP ReportI am working on a BI Publisher report in Oracle Fusion and would like to understand whether the following requirement is technically feasible. For an AP Invoice, there m…User_HRWJI 22 views 1 comment 0 points Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP
-
Learning items with learning outcomes assigned are not displayedLearning items with learning outcomes assigned are not displayed. In the front we can see data according to this but not in OTBI. Using the "Workforce Learning - Learnin…
-
Reporting on Line Item DetailsSummary: Is there any way to report on "Line Item Details" users have entered in forms? I know you can use the "CellText" function in reports to view comments, but it do… -
bursting defSummary: Please confirm if Narrative Reporting can send reports via busting definition to a local directory instead of sending the reports via email? If yes, please sugg…
-
Exit interview questionnarieSummary: Exit interview questionnarie Content (required): Hi All, We got requirement to develop a BI report for exit interview questionnaire details. In that Exit Interv…Venkatesan 111 views 6 comments 0 points Most recent by UchihaItachi Reporting and Analytics for HCM
-
Time Entry report to get updates and deletion of time entrySummary: Need a report for time entry to pull all new creation, updated and deleted records. Content (required): We have a requirement for integration where we need to g…Raghavendra M 71 views 11 comments 0 points Most recent by User022-Oracle Reporting and Analytics for HCM -
FCC demo application for client demoDo we have Demo FCC application for a client demo. I imported snapshot form one of the Oracle tutorials link, but it does not have good demo ready data, inserting data t…
-
FR stopped sending emailsSummary: It looks like the financial reporting batch schedule has stopped sending completion emails. The batch itself is finishing successfully but no emails notificatio…
-
Sql query to get reporting unit hcm information data - tax reporting unit -French Establishment InfoSummary: Hello, We need to extract data in BIP for the reporting unit hcm information data - tax reporting unit -French Establishment Info. Does anyone have more details…Stanciu Maria 34 views 7 comments 0 points Most recent by UchihaItachi Reporting and Analytics for HCM
-
How to remove special characters in the output of a e-text templatesSummary: We want to send all the open POs to a third party system in .txt format. The item description have a lot of special characters, how to remove it in the output w…
-
Report to get data of direct & indirect Reportees of a managerSummary Looking at a way for creating a Report to get data of direct & indirect employees of a managerContent Hi I am looking to create a report which will fetch te data…Mohit Gupta-45440 963 views 8 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
"Preview Offer" feature in HTML does not show correctlySummary: The "Preview Offer" task shows the Offer Letter in different formatting on different parts of the page when previewed in HTML. However, when downloaded in PDF f…Louis K.Emezina 41 views 3 comments 0 points Most recent by dresultay Reporting and Analytics for HCM
-
How to Trigger Bursting Email to Employee with 2 Attachments Along with Email BodySummary: Hi, We have developed a custom bursting report which has Email body configured in Parameter5 and single pdf attachement is generated based on rtf template. We g…puja suryanarayana 2 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Can Global POV map different member names across FCCS and Planning grids in Narrative Reporting?Summary: “Does Global POV in Oracle Narrative Reporting require exact member name match across FCCS and Planning grids, or is there a way to map equivalent members?” Con… -
Renaming UDA member nameSummary: Is it possible to rename a UDA member? We have used it across multiple forms, reports, and business rules, so we want to avoid updating forms and reports if pos… -
Strategy to keep users from accidentally moving folders/reports on the Catalog pageHello. Asking if anyone has a proven strategy to address the risk of a report user, on the Catalog page, accidentally moving folders or reports from their original locat…
-
Table to Extract Vacation Rule DelegationSummary: Hi, I want to extract vacation rules created in HCM Fusion. I have found table that stored vacation rule in Oracle Apps but can't find equivalent table in Oracl…
-
HCM subject area "Workforce Profiles - Library Objects Real Time" join questionHello. Any advice on how to join the HCM subject area workforce profiles - library objects real time to workforce profiles - person profile real time ? Not finding commo…Rich R. 11 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
The FRS report is not returning any data and does not populate any results.Summary: Hello, The FRS report is not returning any data and does not populate any results. I have tried adjusting the parameters, but there is still no impact. What is … -
Getting attribute values in report for FCCS as Plug account tagged for the ICP accountsHi, We are trying the member property text function for account to pull the custom attribute value assigned to the account in the FCCS application but we are facing erro…