BI Publisher
Discussion List
-
Is there a filter/prompt/SQL or a report for a daily dashboard for HR Helpdesk for new/close SRis there a dashboard available or report, or any sql/filter/prompt I can use for OTBI in order to get a daily dashboard for HR Helpdesk queries specifically looking for … -
AUTOMATICALLY INCREMENT THE DATE PARAMETER FOR COST TRANSFERS TO COST MANAGEMENT SCHEDULE RUNSSummary: Hi Content (required): Currently, my team is testing the 21D release update. The aforementioned feature (AUTOMATICALLY INCREMENT THE DATE PARAMETER FOR COST TRA…Sheneli98 197 views 4 comments 0 points Most recent by Neha_Singh Payables, Payments & Cash Management
-
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 93 views 16 comments 0 points Most recent by Jayanthi Shetty Reporting and Analytics for HCM -
Is data contained in a report created/ scheduled in BI Publisher automatically encrypted ?We are looking to improve the way data is extracted from Oracle Fusion and delivered to internal customers. Using BI Publisher reporting, it is not clear or visible if t…
-
Regarding Extract DBI of work-schedule asisgnment when assigned at Enterprise levelSummary: Hi Folks, When I assigned work schedule at assignment level then I got the value in HCM extract of WS and the Pattern as well but if i remove the assnment level…
-
Scheduled agent is failedHi Experts, I’m hoping someone can assist me here. We have several agents scheduled that were running successfully. However, one of the scheduled agents has suddenly sto…Angela Nietes 20 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Does anyone know how to prevent BI Folder being accidently moved?Summary: Any strategy to prevent the BI folder structure from being accidently manipulated. When a folder is accidently moved, the reports that use a BI Publisher data m…
-
value set values exportSummary: Hi Team, We have defined a Asset key flexfield and would be loading 100 values on a daily basis, we would want to have a report to view the value set values add…
-
How to track email delivery status for the emails (invoice, dunning) sent to customers?Summary: Oracle Fusion Accounts Receivable (AR) sends high volumes of customer emails daily, such as Invoices, Customer Statements, and Dunning Letters. However, there i…
-
Learning incident custom notification report is appearing blankSummary: We modified a custom report workflow notification but the notification appears blank in production. In backend the template shows all the changes The FYI notifi…
-
Where does the payment acknowledgement email come from and how to customize it?Summary: We recently set up a payment acknowledgment with the bank and have the payment file register with document detail email once the disbursement and acknowledgment…Nikki Reich 7 views 3 comments 0 points Most recent by lkratzberg Payables, Payments & Cash Management
-
Unable to search employee on Assign Learn?Summary: Unable to search employee on Assign Learn? I have followed below steps , didn't resolved the issue. Add the PER_ENABLE_WORKER_SEARCHES_USING_EFFECTIVE_DATES_PRI…
-
Report to fetch a list of all active configured approvalsSummary: Hello, Wanted to check if there is a way to build a report (sql query or OTBI) to fetch a list of all active approval rules in the system. Note: Approvals rules…DebayanB 157 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to track email deliveries of Print Receivables ESS Job?Summary: We are trying to track the delivery of invoices to the customers which are sent via email but we are unable to get any delivery failure notification in case cus…
-
HSDL template failing for certain usersHi, We are experiencing performance issues with HCM Spreadsheet Data Loader (HSDL). Users are able to generate/download the spreadsheet from Oracle Fusion HCM successful…
-
Use the ESS web service to schedule a job for running the BI cloud extractsSummary: We have been attempting to run a BICC based job from a SOAP\API call using something similar to the ErpIntegrationService submitESSJobRequest SOAP function but …AaronBaltimore 306 views 6 comments 0 points Most recent by LaurentDup Reporting and Analytics for ERP
-
SQL query to fetch number of direct reportees to a line managerSummary: I want to build a BI report where I need to fetch the count of direct reportees to the Line Manager. Content (please ensure you mask any confidential informatio…Tamseel Aijaz 917 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How can I access the list of EU countries?I have a query; SELECT * FROM hz_geographies WHERE geography_type IN ('ECONOMIC REGIONS') I want to question the countries within the EU. However, when I run the query, …Gül Öner 21 views 1 comment 0 points Most recent by Gangadhara S Ariga Reporting and Analytics for ERP
-
26B - Some learning assignments missing Actions issue will be fixed in patch?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
What are the limitations for BI Published reports?Summary: What are the limitations for BI Published reports? Content (please ensure you mask any confidential information): What is the maximum number of rows I can expor… -
BI Publisher: Can I have Action Links on the BI Publisher Report just like in OTBI AnalysisSummary BI Publisher: Can I have Action Links on the BI Publisher Report just like in OTBI AnalysisContent Hi, BI Publisher: Can I have Action Links on the BI Publisher … -
OBJECT_ID stores the Period of Service ID instead of the Assignment ID for PER_ALL_ASSIGNMENTS_M ?Usually, for transactions related to the Assignment page: •Object Name → PER_ALL_ASSIGNMENTS_M • Object ID → Employee Assignment ID However, in one particular case invol…Ashish_Goyal_MPC 42 views 7 comments 1 point Most recent by Ashish_Goyal_MPC Reporting and Analytics for HCM
-
IEX_DUNNING : get_language_from_locale ORA-01403: no data foundSummary: Send Dunning Letters Job is giving above error Content (please ensure you mask any confidential information): Version (include the version you are using, if app…ramesh.daniyala.mcd 5 views 0 comments 0 points Started by ramesh.daniyala.mcd Receivables & Collections
-
Printable Expense Report Receipt Required CheckboxSummary: I am modifying the seeded Printable Expense Report and noticed that the Receipt Required Column always return as null (checkbox). Upon validation from excel usi…
-
Need table name 'Source: Talent Profile’ information displayed in the Candidate Search HCM?Summary: Please provide the table name in Oracle Fusion HCM that corresponds to the under-Degree 'Source: Talent Profile’ field shown on the Candidate Search page. This …Janardhana Kondaveeti 23 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
BIP Scheduled Trigger Failing - Help NeededSummary: Hi all, I'm trying to add a schedule trigger to my BIP report that's currently scheduled, but when it runs with the code, it fails with the following message: D…
-
I am trying to generate BIP report from Duplicate Identification Batch resultSummary: I am trying to generate a BI Publisher report for Customer Data Management Duplicate Identification batch results. I need the following attributes in the report…
-
How is everyone handling and accessing metadata within OracleSummary: Looking for metadata for both business and log-based data. Would like the Oracle dictionary rather than re-creating the wheel. Where can I locate a full table a…