BI Publisher
Discussion List
-
Query to get Report run History in Fusion HCMSummary: Query to get Report run History in Fusion HCM Content (required): Hi All, Can we get the detail who all have run the BI report, is there any query available. He…Swati U 1.8K views 11 comments 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM -
Document of record - config ignored + inconsistent behaviourSummary: Document of record is attaching even though configuration states that document name is required and relevant. HCM Extract has an output item that points to a BI… -
Can we download AP invoice attchement for BU / period of timeSummary: Can we download AP invoice attchement for BU / period of time Content (please ensure you mask any confidential information): Can we download AP invoice attcheme… -
Report on Career AmbassadorHi, is there any Oracle HCM table available to report employees who signed up for Career Ambassador?Francesco Cerioni 21 views 5 comments 0 points Most recent by Francesco Cerioni Reporting and Analytics for HCM -
Query to get all possible list of ess job statusesHi, Is there a standard or common lookup which holds all possible values of ESS Job statuses like Succeded, Error, Warning etc. ? There's one common lookup 'ORA_WLF_ESS_…Ankit_Bhadja 1.3K views 4 comments 1 point Most recent by User_65LA6 Reporting and Analytics for ERP -
SQL Query for Fixed Asset YTD DepreciationSummary: Hello, We have a customized Oracle BI Publisher Report for Fixed Asset's YTD Depreciation. Our business requirement is that : When an asset is fully depreciated…
-
Regarding "SEPA Credit Transfer Initiation" paymentHello gurus, Good day! 1. I would need the original copy of "ABBL XML FORMAT" the xsl template for the "SEPA Credit Transfer Initiation (with unstructured remittance det…viji_r 31 views 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
How to fetch "Check Payment Status" and "Check Issued State" in HCM for US Payroll ?Summary Hi All, Kindly help me to fetch the details of the Check payment as in HCM. As I required a few below columns: Check Payment Status: What is the current status o…abhjkum-Oracle 32 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Global Talent Community Pool data not visible in OTBISummary: Hi Team, We are using OTBI to fetch data from the candidate data belonging to "Global Talent Community Pool". However, we are getting only one record having sta…
-
Certification: Retrive attachments information with OTBI or BI PublisherHello, our customer asks to retrive the information associated to the attachments section of certifications (URL and PDF), is it possible? if so, how? Any advice? Thank …Alessandra T. 1 view 0 comments 0 points Most recent by Alessandra T. Reporting and Analytics for HCM -
How to add ICS file in custom alert/notification?Summary: How to add an ICS file in a custom alert/notification? We have created a BI Publisher report for customized notifications in which we are using RTF templates. C…
-
What is the table storing Account Type?Summary: What is the table storing Account Type? Content (please ensure you mask any confidential information): Hi Experts, May I ask what is the table storing accountin…
-
HCM secured views - listHi, Can you please suggest where can I get all the list of secured views for HCM? Thanks in advance. Version (include the version you are using, if applicable): 24C -
CertificationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Vijay Kumar Reddy 1 view 1 comment 0 points Most recent by HarishVummidi Reporting and Analytics for HCM
-
Report to extract all Dynamic Group/Analysis Criteria and the filters applied to it.Summary: We have Dynamic Group/Analysis Criteria created in Oracle Learning. Is there a report we can use to extract all Dynamic Group/Analysis Criteria and the filters …
-
Is there a way in BIP PL SQL to retrieve where the transaction has been done?Hello Experts, for example, the transaction was done in Me Tab, then PL SQL will tell that this is Me tab page, or in a My Team page. I am currently creating a transacti…Joliver Caangay 1 view 1 comment 0 points Most recent by Joliver Caangay Reporting and Analytics for HCM
-
Is it possible for Oracle Tables for all HCM transactions including archived transactionsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Check Printing IssueSummary: Overflow in Check Printing Content (please ensure you mask any confidential information): We have to customize the out of the Box Check Printing report. Above t…KetanDoshi 12 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
IP address when an employee completes a courseSummary: Please let us know if there is a way to capture the IP address when an employee completes a course or any where in table the IP address is captured when employe…
-
Can anyone please share the best practice to create BIP Report template having more than 50 columnsSummary: Can anyone please share the best practice to create BIP Report having more than 50 columns I have a requirement to develop a BIP report having 54 columns and he…Kundan Kumar17 21 views 0 comments 0 points Most recent by Kundan Kumar17 Reporting and Analytics for HCM
-
Is there a way to delete data from FND_SESSION_ATTRIBUTES, FND_SESSIONS tablesSummary: Hi Fellow Developers, The requirement is to delete all data from FND_SESSION_ATTRIBUTES, FND_SESSIONS tables for security reasons. Content (please ensure you ma…Dhilip Kumar P. 31 views 5 comments 0 points Most recent by Jun Ye-Support-Oracle Applications Security
-
Is it possible to report on Alert History?Summary: Need to see alert history in easy to read format Content (required): We have quite a few alerts running and would like visibility to what is sent and when to he…Janine Brown 425 views 10 comments 4 points Most recent by Murali Togaru Reporting and Analytics for HCM -
which table and column the 'Stage' field is fetched from in the 'Manage Payment Process Requests' ?From which table and column the 'Stage' field is fetched from in the 'Manage Payment Process Requests' screen in Oracle Fusion Payables as attached?Nirosha Yelicherla 61 views 4 comments 0 points Most recent by lkarthik-Oracle Payables, Payments & Cash Management
-
Payables Trial Balance Report ESS Job Template changeSummary: Hi, User requested to create a template change for Payables Trial Balance Report, the ESS job. As this is an oracle developed report you cant make a template ch…aireyevan 51 views 3 comments 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management
-
Project info for an expenseHello all, I've a requirement to pull the project details like expenditure organization, task number,project numer for an expense itemizations created for an expense lin…
-
Set default value for LOV to NULLI have a BIP report with multiple LOV parameters. When data-model/report is opened all LOV parameters are set to ALL by default, I need these parameters to be set to NUL…
-
Receivables Aging by General Ledger Account Report - seeded Datamodel not workingSummary: I have been able to customize the Receivables Aging by General Ledger Account Report to be more usefull, by using the seeded datamodel and creating a new report…Anders W. Langholm 21 views 7 comments 0 points Most recent by Tyrion Lannister Receivables & Collections
-
Need an help for SQL querySummary: Content (please ensure you mask any confidential information): I want to extract report for Manage Legal Reporting Unit Registrations, however I have a SQL whic…Shilpa Dam 83 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM