BI Publisher
Discussion List
-
IEX_DUNNING : get_language_from_locale ORA-01403: no data foundSummary: Send Dunning Letters Job is giving above error Content (please ensure you mask any confidential information): Version (include the version you are using, if app…ramesh.daniyala.mcd 80 views 3 comments 0 points Most recent by ramesh.daniyala.mcd Receivables & Collections -
BIP Report: How to set different decimal point based on countrySummary: How to set different decimal point based on country Content (please ensure you mask any confidential information): Is it possible to change the decimal point on…
-
How Can We Link a UCM Content Server Data Set with a Secured SQL Data Set in BI Publisher?Summary: We are unable to link a UCM Content Server-based Data Set with an SQL query-based Data Set for role-based employee filtering. Content (please ensure you mask an…
-
Different dates on production and test environment for invoice templateSummary: We are encountering an issue where in production a request ship date is shown as 10/12 in the invoice template. But in lower environment, it is 10/13 (Seen in t…
-
Report on Time zone Setting in Set PreferencesSummary: Is it possible to pull a report on the time zone setting within Set Preferences > Regional > Time zone Dropdown for a set of users? If it is possible to pull th…Nick Henderson 16 views 2 comments 0 points Most recent by Mohammad Afghanul Reporting and Analytics for HCM -
Bulk report to identify users and roles with access to custom BI Publisher reports.We have over 100+ custom BI Publisher reports across different folders under /Custom . We need an audit extract showing each report’s catalog path, directly assigned and…Sawan Choudhary 72 views 2 comments 1 point Most recent by Malik_Sikandar Reporting and Analytics for ERP
-
Run time issue in the Payroll Costing Results ReportSummary: We are trying to customise the payroll extract called: Payroll Costing Report to include additional columns based on business requirements. However, before proc…
-
OTBI–How to Display Only One Row per Learning Record Number When Multiple Assignment Statuses Exist?Hi Experts, We are developing an OTBI report using the subject area Workforce Learning – Learning Management Real Time. We are facing an issue where the same employee's … -
How retrieve a list of BIP report names and paths that use a specific table name?Summary: How to retrieve a list of BIP report names and paths that use a specific table name? I wanted to know the list of BIP Data models used below benefit tables. Tab…Aditya Jena 76 views 1 comment 0 points Most recent by BrianMakarewicz Reporting and Analytics for HCM -
Learning tables to identify Learning initiavtivesSummary: Hi , We are developing a BI Publisher report to retrieve only Learning Initiatives. We are currently using: WLF_EVENT_ASSIGNMENTS_F WLF_EVENT_ASSIGNMENTS_F_TL W…
-
Unable to View XML Data from Seeded Print Packing Slip Data ModelSummary: Hi Team, I am trying to view the XML data from the seeded Print Packing Slip Report data model in Oracle Fusion. However, when I try to view the data by providi…Pratiksha Sawandkar 34 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for SCM -
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 79 views 2 comments 0 points Most recent by SMNA-DEV Reporting and Analytics for ERP -
Oracle Fusion AR – Invoice Print Templates Based on Transaction TypeSummary: We currently have two Business Units (BUs) in Oracle Fusion Receivables, each with its own invoice print template and scheduled Receivables Transaction Print pr…naren_rh_fin 13 views 2 comments 0 points Most recent by Shiv.Singhal Payables, Payments & Cash Management
-
No data in document of record letter from HCM ExtractSummary: I have followed the instructions to create the document of record letter from HCM Extract. The document of record letter is create but the mail merged fields ar…
-
Custom Approver Logic in BPM – Validating User Email/Access via BIP or Alternative ApproachSummary: In Oracle Fusion BPM, approval routing is typically based on predefined rules such as user, supervisory hierarchy, AOR, or role. However, we have a requirement …
-
Process to identify the list of scheduled reports which are not having bursting logic for RebrandingHi, We are currently undergoing a rebranding initiative and need to update email addresses used in reports. We have already reviewed reports with bursting logic. We now …Pavan_Eswar 37 views 3 comments 1 point Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Query for Third Party payments along with involuntary deduction component referencesSummary: Delivered Third Party Payment Register Report is not fetching unpaid payments in the report along with the status. We need a query to retrieve the unpaid paymen… -
SQL Query to extract username along with roles, data access and security Context in oracle fusion .Summary: I need the table to get security context column values in oracle fusion tables. Currently I am using the table FUN_USER_ROLE_DATA_ASGNMNTS but in this table ins…
-
Tables for Document Type Security Profiles: report on profile-to-document-type assignments(OTBI/BIP)HCM Cloud > Core HR (or Security) Navigation of the setup: My Client Groups > Show More > Security Profiles > Document Type Security Profiles (Tasks: Manage Document Typ…Richa_11-Oracle 50 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Learning Path having optional and required activity when completed by employee twice,how report workSummary: Learning Path having optional and required activities when completed by learner every year ,how report is going to fetch the learner record for each activity pr…
-
Procurement Sourcing Negotiation: Attachment Mismatch Between Application and Table-Level DataSummary: We are able to see one additional attachment for a supplier against one bid in the negotiation at the database table level. However, the same attachment is not …
-
Cash management--> manual reconsultation--> which subject area we can find the transaction sourceSummary: We are looking for the Transaction Source column available under Cash Management → Manual Reconciliation. We are able to find some of the required columns in Ca…
-
HDL Load of Learner Enrollments and Completions for Self-Paced Learning and EventsSummary: The HCM Data Loader (HDL) LearningRecord file we use to load learner enrollments into offerings works as expected. When we use the same file to load learners fo…
-
Sales Order Dispatch WarehouseSummary: Report for the Dispatch Warehouse of a Sales Order Content (please ensure you mask any confidential information): Hi, We have a requirement for audit purposes t…Mamdouh Ahmed 23 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
Generate Report with Timecard ApproverSummary: We need to generate a report with the time card approved date and who approved it. Content (required): I've seen this question asked a few times, but it doesn't…User_2025-01-31-00-25-12-234 497 views 9 comments 0 points Most recent by Ankur003 Reporting and Analytics for HCM -
Visibility on per_person_secured_list_vSummary: Content (please ensure you mask any confidential information): What roles/setup are needed to be able to see rows on per_person_secured_list_v? Version (include…Stefano_Mazzocca 33 views 1 comment 0 points Most recent by Naveen_CCC Reporting and Analytics for HCM -
Fetch Eligibility profiles data in BIP reports.Hello Community, We are creating a eligibility profile report that fetches all parameters used in eligibility profile. Currently we are fetching the data under employmen…Shubham_R 50 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
IEX_DELINQUENCIES_ALL does not appear to have a confirmed standard BICC Extract PVO name.Summary: The underlying table is IEX.IEX_DELINQUENCIES_ALL, which stores customer delinquency transaction data. Recommendation: Please ask Oracle Support to confirm: Whe…
-
BI user licensing consumptionSummary: Can we provision named users with access exclusively to OTBI and BI Publisher for read-only reporting over Oracle Fusion Financials data, without those users co…