Reports
Discussion List
-
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 Most recent 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 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
-
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 211 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…
-
Assistance Required: Identifying Primary Keys and Table Relationships in Oracle ERP BackendHi Team, We require information on the primary keys and relationships between Oracle ERP backend tables. We are currently retrieving primary key details from the "FND_PR… -
Need Table Storing Bank's "Active" Flag from Personal payment Methods ScreenHello, I'm trying to locate the backend table that stores the "Active" flag status displayed on the Personal Payment Methods > Bank Information screen in Oracle HCM (Sel…Jahnvee Sharma 31 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
Can't inquire into Invoices in the system using Action Link in OTBISummary: Hi. I'm trying to create OTBI Report that will show outstanding Invoices (Unpaid after Due Date is already Due). I'd like to add Action Link, so user will be ab…Yftach Paschur-Oracle 1 view 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP