BI Publisher
Discussion List
-
Scheduling in HCM ExtractWe have the following requirement for the extract and would like to seek inputs on feasibility and the recommended solution approach. Requirement: The extract XX needs t… -
Oracle HCM BI Table to retrieve employees Eligible for eligibility profileHi team, the client ask for creating a report to track Eligibility Profiles and Employees eligible for them. Is it possible to create a report like this "dynamically", s… -
OTBI analysis opens directly without showing prompt when opened from the reports and analytics pageHi team, Facing an issue where an OTBI analysis opens without showing any prompt from the reports and analytics page ( it's added to favourites ) but when opened by navi…Raghavendar 510 views 2 comments 0 points Most recent by CA Nirmal Choudhary Reporting and Analytics for ERP
-
How to Include Invoice Legal Entity in Custom Oracle Payment File for Third-Party IntegrationSummary: We are working on integrating Oracle ERP Cloud with a third-party platform to process Accounts Payable (AP) payments. The process involves submitting a Payment …Khushbu Mahindru 5 views 3 comments 0 points Most recent by Willson Mach Payables, Payments & Cash Management
-
Bursting Report for Line Managers - Future Hire Notifications (No Data Returned)Summary: Hi Community, I'm developing a bursting report in BI Publisher that will notify line managers about employees starting on their hire date. The report should run…Vishal Purohit 3 views 2 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM -
Historical FTE values in BICCHi, The customer would like to extract assignment history data, including FTE, using BICC. I found that we can retrieve historical assignment data through HcmTopModelAna…
-
How to add a QR code in AR print PDF report, where the QR code is coming from 3rd party system.How to add a QR code in AR print PDF report, where the QR code is coming from 3rd party system while integration. We don't want add as an attachment in the invoice, we n…Thanigainathan R 111 views 4 comments 0 points Most recent by Sunil Pradhan Receivables & Collections
-
The selected analysis object doesn't contain a list of people to assign the learningSummary: I have created a very simple BI Report, which includes person_id, Display Name and Job Name. I have applied a filter on the Job Name field to limit the data ret… -
I am getting this error in bursting code ORA-01489: result of string concatenation is too long".Summary: I am getting this error in bursting code ORA-01489: result of string concatenation is too long". Content (please ensure you mask any confidential information): …Shiv Garg 15 views 2 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Fixed Asset Additions/Adjustements Infotile datasource in OTBISummary: Hi, Where can we find this data for Fixed Assets in incomplete status, exceptions etc? Do we have an OTBI subject area to create this type of KPI/analysis? Cont…
-
Help in query to retrieve Relationship Criteria on Eligibility Profile for BenefitsSummary: Hello! I am currently biulding an query to get all the Eligibility profiles and their criterias. Currently, I am in need to find the table to give me the relati…Matheus Roberto 31 views 2 comments 0 points Most recent by Saulo Salvador Reporting and Analytics for HCM -
Which table stores the Auditor Notes for Expense reportsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
We have a requirement to audit changes to folder permissions for custom folders in Reports and AnalySummary: We have a requirement to audit changes to folder permissions for custom folders in Reports and Analytics. Is there a way to get these details? Content (please e…Akash M Mahalle 13 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
Tables that store the errors in FAH when the import Accounting transaction process failsSummary: What are the tables that store the errors in Accounting Hub when the import Accounting transaction process fails ? Version (include the version you are using, i…
-
HCM Alerts Composer: Not able to loop the comma-separated data to one below the other inside a TableSummary: We are looking for a way to get the comma-separated values one below the other. Content (please ensure you mask any confidential information): Version (include …
-
Table to identify password updateSummary: Is there a table that tracks the password updates? We have a scenario where the password of a service account stopped working all of a sudden. I have run the pa… -
What's wrong in this bursting?Summary: Content (please ensure you mask any confidential information): I have this template and this bursting query: Report works fine: Why do I get an empty output whe…Stefano_Mazzocca 21 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Report to get the User login and logout time in oracle fusion HCM instance.We are searching for any kind of report that will show the information or details about the users login and logout time to the Oracle fusion HCM instance. Could you plea…
-
Generate Check Payment statusSummary: We have Gnerate Check Payment Status as "Void" or "Paid and not Reconciled". Need to know in which table/OTBI suject area holds this exact value. Content (requi…
-
Seeded Asset Additions Report: YTD Depreciation showing zero for legacy assetsSummary: On the seeded Asset Additions Report, why is the YTD Depreciation column showing 0.00 while initial depreciation field has value. Content (please ensure you mas… -
Unable to Retrieve Qualified Entitlements Plan Details Using OTBISummary: Unable to Retrieve Qualified Entitlements Plan Details Using OTBI Content (please ensure you mask any confidential information): Hi Experts, We have a requireme…Vasanthakumar Ravi 12 views 2 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
Need table name which store Fiscal Classification CodeSummary Need table name which store Fiscal Classification CodeContent Hi Guru's, Please let me know which table store the Fiscal Classification Code which comes under "M…Rohit Soni-259808 227 views 5 comments 1 point Most recent by Dpalmborg-Amica Reporting and Analytics for ERP
-
TransactionDocumentExtractDm data model used for Disbursement Payment File FormatsHi Guys Does anyone know of the existence of comprehensive documentation around the set of fields that are available to be used in a new "Disbursement Payment File Forma…
-
How to Format a Date Column to include Time Stamp in BICC Extract OutputSummary: Hi, I am trying to extract fusion table data using BICC, and I am seeing when the data is exported the date fields doesn't have the time values in it even thoug…Ragul Halan 35 views 2 comments 0 points Most recent by Deputy Birara-Oracle Reporting and Analytics for ERP
-
How to get the last period of previous fiscal Period in FRSSummary: We create " Income Statement" . The report having Two Columns , Column A represent "Accounting Period Selected in prompt" i.e Sep-2025 Column B for Previous yea…Rama Mohan ReddyB 25 views 1 comment 0 points Most recent by Rama Mohan ReddyB General Ledger & Intercompany
-
Table for ESS Job scheduleSummary What is the table name in Oracle Cloud which stores the Schedule of an ESS JobContent Is there a table name or query which I can use for fetching the frequency, …
-
How to force repeat on rows in pivot tableSummary Trying to build a pivot table using the report editor with repeating valuesContent Has anyone been able to force a repeat on a row value in a pivot table? The ex… -
Where is the justification for a budget override request stored?Whenever a user creates a budget override request, he/she needs to enter a justification or reason for the override. The name of the field depends on the transaction for…
-
How to fetch log error from ESS Job ''Run Convert Pending Workers Automatically Process''Summary: Need to create an report(BI/OTBI) to fetch data of "Run Convert Pending Workers Automatically Process" job log error Content (required): Version (include the ve…