BI Publisher
Discussion List
-
Work Email is visible but Personal Email is blank for specific usersHi, We are experiencing an issue in Oracle HCM where a report that includes both Work Email and Personal Email behaves differently depending on the user running it. When… -
Help with Extracting L1/L2/L3 Managers in ReportsHi, We’re working on extracting L1/L2/L3 manager hierarchy using the standard logic (e.g., PER_MANAGER_HRCHY_DN). In most cases, the extraction works fine — but in speci…
-
How to identify the tables updated by transaction in Fusion HCM?Summary: Hi Team, Is there a way we can identify the backend tables affected by a transaction done in application. For example Hiring an employee, in this case how to id…
-
Required table for Quick move action for Candidate Selection Process Configuration in ORCSummary: Required a table or SQL query where the information of Quick move action stored for the HCM-ORC setup Candidate Selection Process Configuration. Attached screen…
-
To fetch all the approval group details for a journal.Hi, I am working on a GL workflow BIP report where I need to fetch ApprovalGroup Details like ApprovalGroupName, Approval Sequence, Approval Comments for a journal. Plea…
-
Email Bursting Fails in Oracle Fusion UAT Instance – Missing SMTP ConfigurationHello Everyone, We are currently performing UAT testing for our Oracle Fusion HCM BI Publisher bursting reports, which send email notifications to users. The same report…
-
Link Customer to supplier on Oracle FusionSummary: Hello, We would like to know if there is any configuration or setup in Oracle Fusion that allows linking a supplier account to a corresponding customer account.… -
User Adoption ReportHi, Has anyone implemented "User Adoption Report" in Oracle Fusion using Doc ID "Security Reports in Fusion Application (Doc ID 2210883.1)". After enabling the profile, …pradeep chandrasekaran 33 views 1 comment 0 points Most recent by Jun Ye-Support-Oracle Applications Security
-
How to Associate RTF template with Data Model and configure E-Signature Validation.Summary: Hello All, Need support on below requirement. Kindly share if you have any reference. I am trying to the Fleet Safety acknowledgment document with an electronic…RamkumarKadhiravan 26 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Connect to OAC via a REST serviceHello.I wanted to ask about a feature I need to create for my company.In this case, I need to download CSV files from OAC. I have some reports that were provided to me, …wilberth Canales Romero 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How can i move the flexfields , question library , templates and questionnairesSummary: Im looking for different ways we can move the flexfields , question library , templates and questionnaires from one instance to another instance Content (please…
-
MSC_SYSTEM_ITEMS vs. EGP_SYSTEM_ITEMS_BI have a need to cross reference MSC_SYSTEM_ITEMS and EGP_SYSTEM_ITEMS_B to abstract away query complexity for certain users. This is a Data Warehousing scenario. How ca…Cameron Campbell 63 views 4 comments 0 points Most recent by Cameron Campbell Reporting and Analytics for SCM
-
ytd payroll balance values using pay_run_balancesSummary: How to fetch the Ytd balance value of the Gross Pay,Net and Employee tax deductions using pay_run_balances table Content (please ensure you mask any confidentia…susmita 1K views 2 comments 0 points Most recent by Bhagya Kalla Payroll and Global Payroll Interface (GPI)
-
Is there any way to integrate BI Publisher bursting with Fusion’s notification frameworkSummary: We currently use BI Publisher bursting to send report outputs via email to users. This works fine, but we also want the same notification to appear in Oracle Fu…
-
Report data size exceeds the maximum limit (524288000 bytes). Stopped processing.Summary: Hi Team, In a custom BI report, when we schedule it for a large dataset (which typically runs for about 20 minutes) with the output format set to Excel (.xlsx),…AatifSiddiqui 171 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
Network configuration and printer settings when printing directly from ERPWhen using the AP module to run PPR to make payments, is it possible to select a printer (TROY) connected to a PC terminal by cable and print checks directly from the ER…
-
Print Receivable Transaction to print invoices taking more than 20min for one transactionsSummary: Hi All, We are currently using the “Print Receivable Transaction” to print invoices. However, it is taking more than 20 minutes to print a single invoice, even …Vnr Karthikeya-Oracle 1 view 0 comments 0 points Started by Vnr Karthikeya-Oracle Receivables & Collections
-
Suppliers are not receiving Remittance AdvisesSummary: For some reason, none of our suppliers are receiving any Remittance Advises. The configuration on disbursements options, Payment process profiles, and supplier …Murali M. 527 views 17 comments 0 points Most recent by Thriveni Gudipati Payables, Payments & Cash Management
-
HCM Extract for assignment changes only generating previous sequenced rowSummary: I've created a HCM Extract that pulls assignment details for employees, including past, present, and future assignments. The only filtering criterion I use is t…
-
Encrypt the request and response of Oracle fusion SaaS webservicesWe would like to encrypt the data traffic between external service and Oracle SaaS SOAP services eg BIP webservices. Did anyone work on this data security scenario ? If …
-
We Need a table for the Configure Worksheet Display -Detail Table in Workforce compensation planSummary: Hi, We Need a table for the below highlighted fields under the Configure Worksheet Display -Detail Table in Workforce compensation plan Content (please ensure y…
-
Display Latest Approver in Custom Payables InfoletSummary: Hi All, Currently, I have created a custom Payables Infolet, in which I added the "Approval Status" and "Approver" information. However, the application display…Ucup Maulana 31 views 1 comment 0 points Most recent by Cosmin Nadolu-Oracle Payables, Payments & Cash Management
-
Customize Receivables Aging by General Ledger Account ReportSummary: Hi, We want to customize the "Receivables Aging by General Ledger Account Report" for a specific GL Account. We know how to customize/ extend a seeded ESS BIP r…Gireesha Pinnagoda 210 views 5 comments 0 points Most recent by Arijit_1606 Receivables & Collections
-
journals accounting date tableDear All, Can anyone tell me where's the accounting date of the journal is stocked? I queried date_created column in the GL_JE_HEADERS table, but I noticed that I am obt…George Mattar 400 views 4 comments 0 points Most recent by Sridhar_Rejeti_1423 General Ledger & Intercompany
-
BIP report use '_vl' view cannot switch language by user language preferenceUse '_vl' view to extract data in BIP report, but it didn't display in correct language based on user's BIP preference session language. Given that, I selected :xdo_user…Skye Liu 33 views 4 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Report Output data getting spit in two rows in excel file due to line breakageSummary: We have an OTBI report based on an Analysis where the Data Model is also using Analysis. In the data, there are line breaks within certain fields. When exportin…Nikhil Kubba 128 views 5 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
Bursting files by department code in .csv formatSummary: Bursting files by department code in .csv format is running into error. Content (required): I'm using this query to burst files by Bursting Key = department cod…Aloka Bhattacharya 760 views 8 comments 0 points Most recent by Hemanth Kumar Reddy Reporting and Analytics for HCM