BI Publisher
Discussion List
-
CSV file bank statement importSummary: We have reached out to our BANK, but they are unable to provide statements in the BAI2 format. One BANK can provide statements in CSV format, while the other do…Naresh12345 24 views 3 comments 0 points Most recent by Naresh12345 Payables, Payments & Cash Management -
Issues while displaying Calnedar View in OTBISummary: Unable to call https://www.gstatic.com/charts/loader.js using Narrative view in OTBI Content (please ensure you mask any confidential information): We have a re…
-
Burst to Documents of RecordSummary BI publisher report bursting to DoR possible?Content Hey, We would like to create a BIP report (containing the approved notice period and other relevant data) in…Ann Van Roosbroeck 381 views 4 comments 2 points Most recent by Tara Samari-237472 Reporting and Analytics for HCM -
Conditional Region for Pictures on BI PublisherSummary: Difficulty Applying Conditional Region for Displaying Different Logos in BI Publisher Word Add-In Content (please ensure you mask any confidential information):…
-
How to generate a BI Publisher URLI need to create a direct URL for the PayablesTrialBalance.xdo report in BI Publisher that will display the report with the correct parameters and formatting in the brow…
-
Does Oracle Fusion Allow a Link to Microsoft Power BI?Summary I'm looking to see if Fusion would allow Microsoft Power BI to link to the Servers In Order to Build ReportsContent My company uses Microsoft Power BI for alot o…Brian Burns 87 views 5 comments 5 points Most recent by daniel.valdovinos Reporting and Analytics for ERP -
Oracle Fusion (HCM) Allow a Link to Microsoft Power BI to get dashboards?We are currently implementing Oracle Fusion HCM and the client has several dashboards already developed in Microsoft Power BI. These dashboards are published in Power BI…daniel.valdovinos 37 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to create an ER diagram that illustrates the relationship between tables within Oracle Fusion?Summary: How to create an ER diagram that illustrates the relationship between the PER_LOCATION_EXTRA_INFO_F table and the LOCATION_ID and LOCATION_NAME columns in HR_LO…Dhilip Kumar P. 33 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
What Tasks are done in Print Receivables Transactions and Child Jobs?Summary: Hello, we are having a customized Print Receivables Transactions process (Datamodel and Templates are customized) in Oracle Fusion cloud. To be able to do some …
-
Issue while creating AR Customer Profile using we serviceHi, I tried to create Ar customer profile using the ReceivablesCustomerprofileservice webservice It was working perfectly before with me using the same combination of pa…
-
BI table for AR transaction approvalHi Team, Please help to get table that stores AR transaction approval History. I am not able to find any dedicated table like AP Invoices (AP_INV_APRVL_HIST_ALL). Also t…
-
Which table stores the acknowledgement date of performance document and comments entered by employeeSummary: We are trying to customize one performance module seeded report. In the report, we are trying to fetch whether document is acknowledged by employee or not. If y…
-
how to create custom dependent parameters for ESS jobwe have requirement to create dependent parameters for ESS jobs. we are creating custom LOV's using SQL query. need to use custom LOV's for parameters.chandrakanth makam-Oracle 273 views 6 comments 1 point Most recent by Charan Sai Vambolu Receivables & Collections
-
SQL to retrieve employee name,person number,department name and department DFF detailsSummary: SQL to retrieve employee name,person number,department name and department DFF details Content (required): Hi All, Please share SQL to retrieve employee name,pe…C.R.Balaji 15.3K views 6 comments 0 points Most recent by Penmetsa_Sushma Reporting and Analytics for HCM -
Payroll query that fetches results only if Archive and Generate Payslips is run post Payroll runSummary: We have a requirement to fetch the run result values only if the Archive Periodic Pay results and Generate Payslips processes have been run for the person post …Pinky Mukherjee 746 views 5 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM -
Can I change the date format in the BI Publisher data model to 'DD/MON/YYYY'?Summary: In the Fusion, publisher reporting → data model→ SQL Query "select to_char(to_date('12/09/2024','DD/MM/YYYY'),'DD/MON/YYYY') from dual;". It always returns 12/0…
-
Why IRC_HTTP_REQUESTS is having blank when there is a data in Recruiting Messaging ConfigurationSummary: Hi Team, The SMS communication information is stored in IRC_COMM_ACCOUNTS but We are not getting anything in these tables IRC_HTTP_REQUESTS, IRC_HTTP_BODY_TOKEN…Opkey PA 1 view 1 comment 0 points Most recent by Prabhu Mohan-Oracle Recruiting, Opportunity Marketplace
-
Need inputs to fetch the Absence "Plan Use" informationSummary: Need inputs to fetch the Absence "Plan Use" information Content (please ensure you mask any confidential information): In the absence records, we need to fetch …
-
Request for Source Tables and Query to Retrieve Budgetary Control Transaction DetailsHello Community, I would like to ask for your guidance regarding the source tables used to retrieve the detailed transaction information shown in the Review Budgetary Co…
-
Schedule the ESS Job set in Oracle fusion for Mon-FridaySummary: How to schedule an ESS job set in Oracle fusion to run for week days only and exclude Weekends. Content (please ensure you mask any confidential information): H…Sridhar_Rejeti_1423 21 views 2 comments 0 points Most recent by Sridhar_Rejeti_1423 Payables, Payments & Cash Management
-
Aggregate (sum) balance amounts by group in an RTF template (such as a Payslip)I've been asked to update a BI Publisher RTF template to consolidate a list of Payroll Balances by Reporting Name and Hourly Rate. The data in the XML extract appears in…Eric Geddes 474 views 6 comments 0 points Most recent by Himanshu Chavan Reporting and Analytics for HCM -
COUNT function in e-Text Template in BI Publisher with HCM extractSummary COUNT function in e-Text Template in BI Publisher with HCM extractContent I used count function in e-text template ,the count function returns no data, any thing…G Madatala 447 views 8 comments 0 points Most recent by Anupam Rana-Oracle Reporting and Analytics for HCM
-
query to identify the processed and unprocessed payroll transactions for BI reportsVersion (include the version you are using, if applicable): for version "Oracle Fusion Cloud Applications24A (11.13.24.01.0)".Immanuel Aruldoss 56 views 2 comments 0 points Most recent by Eric Geddes Reporting and Analytics for HCM
-
I am not able to get an etext output without Special charactersSummary: I am getting special characters in my etext output. I tried using UTF-8 character set, that still didnt help. I used save as encoding UTF-8 on rtf template. Tha…RohithGundreddy 12 views 0 comments 0 points Started by RohithGundreddy Reporting and Analytics for HCM
-
How to report on "Job Description" from "Job Profile"Summary: I need to report on job description and effective start/end date within each job [model] profile, but i can't seem to find it from BI. I tried to query few tabl…Adil_R 272 views 14 comments 0 points Most recent by Srinivas_Godari Reporting and Analytics for HCM
-
OTBI does not generate all lines.Hi everyone. I'm generating a report in OTBI and not all the lines that should be generated are being returned in the report. Is there a limit to the number of lines tha… -
How a certificate can be changed according to the score in learning cloudSummary: I have a scenario where in client wants 3 diff certificates for a single course. Depending on the score we have achieved for assessment learner should get eithe…
-
how to calculate average percentage of Budget Utilization in workforce compensation module?Summary: My requirement is to find out the average percentage of Budget Utilization in workforce compensation module. How can I derive that? Content (please ensure you m…Pritha 12 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
What table(s) joins the converted work assignment to the pending work assignment?Summary: I am seeking information on what table(s) joins the converted work assignment to the pending work assignment? Use case is that information stored on job offer a…