Reports
Discussion List
-
ESS Job Parameters Not Displaying When Submitting Copied Journals ESS JobSummary: We created a custom ESS job by copying the seeded "Journals for Mexico" report, including: A new custom data model A new custom report A new custom ESS job The …Geethanjali kandlakoyya 95 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
HCM Approvals report secured by locationSummary: I have a requirement to create a report or analysis of approvals and their statuses, but it must also consider the employee’s location. The report should only d…Ismael Jimenez 11 views 4 comments 0 points Most recent by Ismael Jimenez Reporting and Analytics for HCM -
how to pull data from FCCS into Analytics and combine with Fusion Cloud ERP data (Finance)Summary: We would like to have some ideas about how to extract data from FCCS in reports in Analytics and combine with Fusion Cloud ERP data (Finance) Content (please en…Hans Krogstie 21 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Table name and column for EXPENDITURE BUSINESS UNITSummary Table name and column for EXPENDITURE BUSINESS UNITContent what could be the Table name and column for EXPENDITURE BUSINESS UNIT for project commitment although …
-
SoX BI report for Role and ESS changesHi All, As part of SoX auditing, we are looking for lookback BI reports to identify Role and ESS changes as we find from our analysis that the Audit reports available ou…Sam Mathews-81448 31 views 3 comments 0 points Most recent by Sam Mathews-81448 Reporting and Analytics for ERP
-
OTBI Analysis Report – Duplicate Rows Issue Even After Enabling DISTINCTSummary: I am working on an OTBI analysis where I am seeing duplicate rows in the output. For example, the same Person Number and Person Name (e.g., "101 – Ben") is repe…Manoj Muddineni 61 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
need to fetch the timestamp when Invoice status changes to Approved at summary levelSummary: for every invoice, when clicked on 'Validate' it will kick a process in the backend "Validate Invoices" which will change the status of Invoice to Validated nee…Anjali Sidharthan 11 views 1 comment 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
User engagement reportsSummary: In FCCS is there any way to generate User engagement reports? Like what features does a user is using regularly may be generating reports, passing Journals, ent…Amara Sai Sandeep 21 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Unable to see data in xml_data_cache column of HRC_txn_data table.Summary Unable to see data in xml_data_cache column of HRC_txn_data table.Content Hi Team, As we know, Data_Cache column is deprecating from 21A and new column xml_data_… -
Check-Ins ReportContent We are considering implementing the Check-Ins feature in our 2021 performance reviews. We will need to be able to track completion rates. Perhaps I am overlookin…User_2025-10-31-00-57-47-193 78 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to disable play button on FCCS reports?We have users who see the "play" button when they open the migrated FR report. How can I disable it and get the report load automatically?Patrick Pontillas 31 views 1 comment 0 points Most recent by Komala Reddy-Oracle Financial Consolidation and Close
-
Variance arrows/icons in ReportsIn Planning and creating Reports, is there a feature for displaying variance arrows/icons either natively or through a workaround? Thanks for any insight. App Type: PBCS… -
Can we dynamically pull values from formula row depending on dynamic quarter and year?We want to pull values in current quarter and previous quarter dynamically from the formula row. Is there a way to do it using IF formula or any other way? In the below …
-
Need sample query to get Original transaction number from credit memosSummary: Need sample query to get Original transaction number from credit memos Content (please ensure you mask any confidential information): need to know about the bac…MayuriMMote 242 views 3 comments 0 points Most recent by Mohamed M. Faramawy-Oracle Reporting and Analytics for ERP
-
Reports under Workforce Compensation planSummary: Hello experts, Please let me know where can I find the details of delivered reports available under Workforce Compensation and related data models. Thanks, Cont…Vaishnavi Agrawal 35 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the YeaSummary BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the Year ParameterContent Hi, This is related to earlier post: https…User_MC37Q 1.1K views 5 comments 1 point Most recent by NIRMAL KUMAR L Reporting and Analytics for HCM -
Access to customize reports in Publisher greyed outHi all, Hoping someone could assist with an issue regarding access to customize reports in Publisher. The user has BI Author and BI Admin. The folder permissions for the…G. Class-Peters 23 views 0 comments 0 points Started by G. Class-Peters Reporting and Analytics for HCM -
Receiving this error desk when running the deduction reportSummary: When running the deduction report receiving this error on completion with no output. An internal assertion test couldn't be completed at location ProcReportPayA… -
HR Action / Termination Action in Manage Work RelationshipSummary HR Action / Termination Action in Manage Work RelationshipContent Hi - We are trying to move all of our BI Publisher reports to Analysis and encountered an issue…Roy Paolo Paunlagui 202 views 13 comments 1 point Most recent by Anjaneyulu Reporting and Analytics for HCM
-
Unable to proceed to create Dataset using webservice in Oracle BIP ReportSummary: Unable to create dataset with Webservice while creating custom BIP report Content (please ensure you mask any confidential information): below are the steps to …SireeshaJaladi 121 views 6 comments 1 point Most recent by Sri Prasanth Reporting and Analytics for ERP
-
Not able to view seeded template at the seeded path after customising the reportI have customized the seeded template for the US Payslip report and it is present at the custom path:/shared/Custom/Human Capital Management/Payroll/Payment Distribution…Aditya Jadhav 32 views 4 comments 0 points Most recent by Aditya Jadhav Reporting and Analytics for HCM
-
How to add response of questionnaire?Hi team, I want to add response of questionnaire for below query. Could anyone help me? SELECT distinct paam.person_id ,to_char(paam.person_id) PERSON_NUMBER ,PPNF.DISPL…
-
Import Costs Scheduled Process Only Shows Counts, Not Details- How to Get detailed based on ESS JobSummary: How can we get detailed records (line-level) of successfully imported project costs from the Import Costs scheduled process in Oracle Fusion, since the standard… -
Individual Compensation plan data not populating on a reportSummary: our Division Admins can see Additional pay amounts for ICP's on the compensation screens but when they run a report no data displays for the ICP for them. We ar…
-
OTBI/BIP catalog/folder last update date differenceHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified … -
Is it possible to use a dimension in a formula and if so, what is the syntax?Summary: I'd like to use a formula using our entity and intercompany dimensions. Is it possible to do something like: if Entity = 001 or Intercompany =001, then pull in …
-
Is there another SOAP call that we can use to trigger BIP without exposing the Username & Password?Summary: We are currently using the SOAP wsdl below to trigger BIP report. Unfortunately client wants the username/password to be hidden in the SOAP envelope. Is there a…
-
How to add page break in etext template (Fixed position based) in BIP reportHow to add page break in etext template (Fixed position based) in BIP report? Need to add page break after every 50 rows.Harshitha S Motagi 31 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
query object permissionswe are looking for the physical tables or BI publisher SQL that will allow us to see the permissions for the objects in our catalogs (data models, report templates, prom…
-
OTBI Report (Dashboard) Security Not Mirroring FusionContent My understanding of the OTBI security is that security applied in Fusion will also be applied when running reports. You'll see the same data. However, if additio…Rebecca L Smith 63 views 13 comments 0 points Most recent by GPOtimization Reporting and Analytics for HCM