Reports
Discussion List
-
Exportfolder location in Oracle Reporting Web Studio through PCMThe oracle application used is PCM and when scheduling a batch run through oracle reporting web studio, there is an option for the results to be saved in an external dir… -
Restricting a record if its already sent - Oracle Fusion ERP Cloud BI Report Requirement.Summary: We have a report requirement that once payments exceed $600 during a calendar year, we report to the downstream app within 20 days. Also, once a supplier has be…Abhilash K - Deloitte USI 51 views 2 comments 0 points Most recent by AnupamAgr Reporting and Analytics for ERP -
I cannot see bursting enabled in batch scheduler in FRSSummary: I cannot see bursting enabled in batch scheduler in FRS Content (required): I created a batch and added two reports. Next I created a batch scheduler and added …ShitalRamteke 1 view 2 comments 0 points Most recent by Carlos Suarez Lopes Reporting and Analytics for ERP
-
Is it possible to pull USD balance directly for TAR Book Balance Automation?Right now we have set up TAR book balance automation, but for foreign entity it pulls local currency book balances then translated using FX rates to USD balance. Is it p…
-
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…
-
Reports and Analytics - Catalog - usage numbersSummary: Need to identify usage nubmers of reports in the ERP Tools and Analytics catalog Content (required): We are trying to identify the frequency and usage of report…Marko Puskac 41 views 4 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
Need PVO details for PER_ROLES_DN? Not able to find one in BICC mapping to Finance/HCM listSummary: I am looking BICC Tag for PER_USER, PER_USER_ROLES , PER_ROLES_DN HAve found following for PER_USER and PER_USER_ROLES and not for PER_ROLES_DN HcmTopModelAnaly…Antony P Patrick -Oracle 111 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
HSDL Updates to Requisition are not captured in IRC_LC_HISTORY TableSummary: When a requisition is updated using HSDL and if EXT_PUBLISH_JOB_STATUS , EXT_PUBLISH_JOB_END_DATE columns are being updated without any change to phase or state…vinay karumanchi 12 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Spreadsheet Data Loader (HSDL)
-
Table that stores the file contents of an attachmentHello, We need a table that stores the base64 format of the attachment uploaded in a work order or if there is any table that stores the binary format of the file conten…
-
Error with running narrative reports on smart viewHi, my client is facing errors with running Narrative reports through smartview for both epm book and reports. They are able to view reports on HTML and pdf but not exce…
-
Assignment Manager (Unsecured) significantly slower in Workforce Performance Subject AreasSummary: Material / significant slowness that appear to be driven by [Assignment Manager (Unsecured)] folder within Workforce Performance Subject Areas, relative to othe…
-
Taleo Oracle Analytics: OAS Agent Management - Secure SendSummary: Is OAS Agent Management a secure send? What we know in the past for OBI, it is not but with the multiple upgrades happened and migration to OAS, we wanted to va…Martin Hernando 1 view 1 comment 0 points Most recent by Martin Hernando Taleo Enterprise Integrations
-
Query on Management Reports in PBCSSummary: Hello , There are a couple of projects that we are working on and was hoping that you could give us guidance . Is there a way to refresh an MR report in excel, …
-
Need to know which bi reports are being run by a user in a monthly basis and how oftenWe need to know which bi reports are being ran by a user in a monthly basis. Here the challenging thing is report ran might be scheduled or adhoc (ran directly) , we nee…
-
OTBI Dashboard only shows Indirect on promptSummary: OTBI dashboard is only showing Indirect in drop down prompt. Need to be able to choose between Direct and Indirect reports. Content (please ensure you mask any … -
OTBI - Calculate age in years and monthsSummary How to calculate the age in years and months?Content Hi, In OTBI I want to create a column which present the full age of the employee, for example 43.12 (means 4…Yaniv 899 views 18 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Customization of ICP ReportHi, Our client requires some customizations in the ICP report format, such as: Changing the order of accounts in columns. Adding a new table for custom calculations. Mod…Bakul Dehariya 31 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
how to convert blob type to actual text in oracleSummary: the underlying tables store the xml data of employees in blob format, the customer wanted to see the exact content of this File_data column in output results.. …Rama123-Oracle 42 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to get one time data in audit tables after enabling auditing for HCM processes.Summary: How to get one time data in audit tables after enabling auditing for HCM processes. Content (please ensure you mask any confidential information): We have enabl… -
Generate a count of employee self service requests for certain employee data fieldsSummary: Is there a way in OTBI to generate a count of the number of times an employee changed personal information data in self-service over a period of time? My unders…
-
Creating BIP Reports via SOAP WebserviceSummary: Creating BIP Reports via SOAP Webservice Content (please ensure you mask any confidential information): 1)Can we create a BIP data model and report dynamically …Kishore S-Oracle 733 views 6 comments 3 points Most recent by Sudhan Reporting and Analytics for ERP -
MMM-YY date format, grouping dates and showing same value in promptWhen doing the custom data format for a date field as MMM-YY, how can that be achieved in the prompt so that they're only having to select a single value for the month a…
-
Fetching Job Requisition with Sensitive Information in OTBIHi Team, We are fetching job requisition details from OTBI in the Recruiting - Recruiting Real-Time subject area. However, we also need to retrieve additional candidate-…Jeeva - Cloud Vantage 21 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Generate Button disabled for Enterprise Journal Reports Tab after December 2024 UpgradeSummary: There are multiple system reports appearing under Task Manager Reports Tab after December 2024 upgrade, Even Generate button is enabled to extract reports in PD…
-
Query to get REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, REQUISITION STATUSSummary: Can anyone please help me in writing a Oracle SQL Query for BI Report to fetch columns like REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, RE…a.w.anand 3K views 9 comments 0 points Most recent by Gongati Nandish Kumar-Oracle Reporting and Analytics for HCM
-
Filtering on attributes on epbcs reportingMy client wants to have a report where they are able to filter on the attributes. They currently have three separate attributes in the POV but they would like to be able…
-
Fast Formula with FF type "Extract Criteria" is not working when we are trying to add it in extract.Summary: Hi Team, We have designed extract to pull the employee assignment details but it was picking the multiple records for an employee. We used fast formula in "Filt…
-
Is it possible to add a Field Tag inside the Textbox in RTF TemplateSummary: We have a requirement to add name field inside a text box and add a photo inside a circle shape. I tired, but not able to add those fields. I even tired to add …Sujeeth Chinta 81 views 9 comments 0 points Most recent by User_OCKZO Reporting and Analytics for HCM -
Table name and column for award numberSummary Table name and column for award numberContent In EBS GMS_Awards_All has award number in fusion what is the corresponding table and column to get the value.
-
Is there a list of Essbase cubes and fields available for Cloud ERP?We are trying to find a list of all Essbase Cubes and the fields in those cubes so we can create reports more effectively in SmartView. Does anyone know where we can fin…