Reports
Discussion List
-
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 235 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 31 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 21 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 197 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 122 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 31 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 66 views 13 comments 0 points Most recent by GPOtimization Reporting and Analytics for HCM
-
How to restrict the data in OTBI report based on AOR (Area of Responsibility)We have created HCM reports from the Absence module, Goals and performance, etc. and we need to restrict the data based on AOR. Is it possible to restrict the data in th…Vikas V. Kamat 201 views 7 comments 0 points Most recent by GPOtimization Reporting and Analytics for HCM
-
OTBI Worker Attributes Changed After Redwood EnablementSummary: Our reports stopped working in Production after migrating to Core HR Redwood. We’ve observed changes in OTBI column attributes when comparing Redwood and non-Re…Josel Pleyto 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can you help me add the assignment status (Active/Inactive/Suspended,etc) to this SQL query?Summary: Hello team! I have this code, but I don't know how to add the assignment status (Active/Inactive/Suspended, etc). Could you please help me with that? Thank you …Claudia Linares L 101 views 13 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
The extract chunking task does not generate the default XML(at least parameter data) file.Hi Team, We observed that when there is no data to chunk, the extract chunking task completes successfully after 25C; however, it does not generate the default XML file …
-
Where are project asset details (and additional details) stored?Summary: Looks like the central project asset table is pjc_prj_assets_all. In the UI there's additional details areas that I'm not seeing a corresponding table. I'm spec…Jason Parker 1 view 1 comment 0 points Most recent by Clara Azoitei-Support-Oracle Project Management -
Absence calendar seeded report does not show any dataSummary: Absence calendar report does not show any data Content (please ensure you mask any confidential information): Could someone advise why does the data does not po…
-
Create an alert or mail delivery system for a sequence in OACI have a sequence in OAC. The sequence has multiple data flows present. I need to setup some sort of alert so that I get an alert in case a data flow fails. How to get t…
-
Migrate Reports from one instance to otherSummary: Need help to migrate Report from 1 instance to other Content (please ensure you mask any confidential information): I exported the report using Snapshots. But w…
-
How to setup global POV name as Alias in Report PBCS?Summary: Hi, I am having trouble finding the setting for the global POV bar on the report display name. My client wants it to display as an alias, but I cannot find the …
-
Failed to select any new views or all views that you requested to built exist alreadySummary: We are using Optimize Aggregation schedule job on a ASO cube, received below error Failed to select any new views or all views that you requested to built exist…
-
Cross Reference Grid Oracle EPM ReportI created a cross reference grid. I can view both grids (Grid 1-Actual Report Referencing to Grid 2-Data). I can view both grids but a user all of a sudden cannot view t…