BI Publisher
Discussion List
-
HCM Audit Table Differences - Do the audit tables keep deleted rows and the regular table does not?I want to understand the difference of contents between a "regular" table and an "audit table" that has an "_" underscore at the end of the name. I am calling PER_ALL_AS… -
How to get the approval history for Claims?Hello. I am trying to build a custom report that would get the approval history for claims (approvers, latest date of submission, etc.). Does anyone have any idea on wha…missy_21 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Import Error BICC JobsSummary: Hello Team, we are getting an error when importing the BICC Jobs from UAT to PROD and it is erroring with attached error. Tried manual creation and it is workin…PrasadN 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Does anybody know why fields are not available to be shown on template for data modelSummary: Does anybody know why the data model may be correctly reading my 2 fields (source_document_id, txn_qty) but they are not listed in fields available in current d…MichaelV823 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Lexical parameter values for Movement Request Pick Slip Report data model changesSummary: We are working on the SQL query for Oracle Seeded Data Model - Movement Request Pick Slip Report Data Model where it shows some lexical parameters and asks to p…Suyog Dhongade 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Unable to see data in "VOIDED_BY" and "VOIDED_DATETIME" in ANC_PER_ACRL_ENTRY_DTLS tableSummary: Unable to see data in "VOIDED_BY" and "VOIDED_DATETIME" in ANC_PER_ACRL_ENTRY_DTLS table Content (please ensure you mask any confidential information): We are a…
-
OTBI Report 8.4 RCE Anexo 11 – No Invoices DisplayedI am experiencing an issue with the OTBI report “8.4 RCE Anexo 11 – Replaces Proposal” under Oracle Fusion Cloud Financials. When I run the report for the September acco…Milagros MR 41 views 5 comments 2 points Most recent by Prateek Agasti Reporting and Analytics for ERP -
Customizing the standard Negotiation Award Decision Notification doesn't work after upgradeSummary: I customized the standard Negotiation Award Decision Notification by: Adding new columns to the data model and using them in the layout. Adding new sections and…Nermin Khaled-Oracle 21 views 0 comments 0 points Started by Nermin Khaled-Oracle Reporting and Analytics for ERP -
Need table name storing reporting period and status after "Finalize Transactions for Tax".We need to retrieve the final reporting status and reporting period in Oracle Fusion tables after running the "Finalize Transactions for Tax Reporting" ESS job. This ESS…
-
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 35 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 21 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 65 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 1.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 247 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. 536 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 …