BI Publisher
Discussion List
-
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 173 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
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 332 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 942 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 … -
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 12 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… -
how to translate the AR Invoice Line Description to French in BIP Reports in BIP ReportsSummary: The customer has a business requirement to translate the AR Invoice Line Description into French for their reports. Language should be picked dynamically based … -
Sql query to get the payroll balance ITD value from the below image It is not from balance resultsHi Team, I need an sql query to fetch the payroll balance ITD value from the below screens (Not from balance results which can be seen in person results). For an employe… -
AP_INVOICES_PKGSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Organization Calendar Events with Coverage Area Data Extraction QuerySummary: Query to extract Organization Calendar Events with Coverage Area (Geography) Content (please ensure you mask any confidential information): Hi, We have a requir…Vasanthakumar Ravi 13 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
OTBI - Issue while submitting Custom report - Asset Cost DetailSummary Error while selecting parameters for Custom OTBI report which was copied from Asset Cost Detail reportContent Error while selecting parameters for Custom OTBI re…User_2025-02-04-10-47-46-258 52 views 4 comments 0 points Most recent by User_HI2N6 Reporting and Analytics for ERP -
Unable to View "Not Started" Course Status for Assigned LearnersSummary: In the Specialization view, the course status is displayed as “Not Started” for learners who have already been assigned to the specialization. However, when an … -
Issue w/ Balance Definitions with several elements for rolling 12 months not producing correct valueIssue with Balance Definitions made out of several elements for rolling 12 months as the dimension but the results don't change at all and tested for multiple users with… -
Inquiry on Table for Bursting Email TrackingSummary: Inquiry on Table for Bursting Email Tracking Content (please ensure you mask any confidential information): In accordance with the requirement report, emails ha…ViswanadhK 41 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Add an Infolet Box of OTBI Report in Invoice Page like seeded infolet using SandBoxSummary: I am working on a requirement in OTBI where I need to create Infolets on the Invoice page in the front end, similar to the seeded Infolets, using Sandbox. There… -
Some users can not export pdf report when click view pdf button on PO or agreement screen.Summary: We are currently facing an issue in the production environment related to the "View PDF" functionality on the Purchase Order and Agreement screens. When certain…Ahmed Abdelhamid 322 views 4 comments 0 points Most recent by Rishabh257 Reporting and Analytics for SCM -
Change the rtf template for Receivables Aging by General Ledger Account for Multifund AccountingSummary: I've created a new rtf template for the "Receivables Aging by General Ledger Account for Multifund Accounting Report" and put it in the custom folder, but when …