BI Publisher
Discussion List
-
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 30 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 72 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…
-
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 10 views 1 comment 0 points Most recent by Naveen_CCC Reporting and Analytics for HCM -
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 32 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 42 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 18 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 493 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 29 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 54 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… -
What is the back end column where component values of a worksheet plan are storedSummary: In what back end tables-columns are the values of columns: "Budget Percentage - Employee - Component 2" , "Percentage of Eligible Salary - Component 2" and "Bud…Abishek R 28 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to implement Segment Value Data Security in BI Publisher ReportContent Hi All, Can someone provide insights on how to implement implement Segment Value Data Security (SVS) in BI Publisher Report. We have a requirement to create BIP …Himanshu245 398 views 4 comments 1 point Most recent by Kalyani-Oracle Reporting and Analytics for ERP
-
implement Segment Value Data Security (SVS) in BI Publisher ReportHi All, Could someone provide insights on how to implement Segment Value Data Security (SVS) in a BI Publisher Report on the GL budget balance table? We have a requireme…Veeragopathi 149 views 4 comments 0 points Most recent by Kalyani-Oracle General Ledger & Intercompany
-
How to enable SVS Security in Custom BIP ReportSummary: General Ledger SVS by Business Function is enabled. User ABC cannot select account starting with 101in Create Journal or the standard report’s Account parameter…
-
Customize Bill of Lading Report and Packing List ReportSummary: Hello. Has anyone here experienced customizing Bill of Lading Report and Packing List Report to add more fields? How do you get the XML for these two reports an… -
Customize Bill of Lading Report and Packing List ReportSummary: Hello. Has anyone here experienced customizing Bill of Lading Report and Packing List Report to add more fields? How do you get the XML for these two reports an…
-
Create Customer Statement (Statement Generation report) — invoice-detail section renders empty despiSummary: The statement PDF generates successfully and the statement summary sections (header, transaction table, aging buckets) render correctly with accurate data. Howe…