BI Publisher
Discussion List
-
Query in BIP report not showing result, what can I do to make it work? (SQL included)Summary: Content (required): Hi, I have created a report containing the receipts made for the selected time period. The report is showing the result when I limit the per…Mariyam129 41 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM -
How to update subject line for mail notification in Invoice ApprovalSummary: We have a requirement to include cost center details in the subject line of invoice approval mail notification. Is it possible? do we have a document for that? …Surya08 41 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Permissions for Customized Seeded ReportsSummary: When we're going to customize a seeded report, shall we retain the permission that has been set up in the customized folder? For example: Job Offer seeded repor… -
PGPSummary: Hello, all the times we need to configure PGP the system need to receive the file send us the PGP. Now we are facing a new situation where we need to send to th…Nicola Petri 11 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Unable to find Organization goals Check Box in HCM tables.Summary: Dear , I want to know in oracle fusion which table I can find "Share this goal with your organization" .I was searched all goals tables but not found in table T…challa praveen 33 views 2 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM
-
which table can store the bip report permissions detailsHi All, Could you please let me know ,which table can store the bip report permissions details. Thanks For Your Help!! RavindraRavindr-Oracle 51 views 3 comments 0 points Most recent by Gayathri K M-Oracle Reporting and Analytics for HCM
-
Need SQL query to get absence leave requests which are in denied status.Summary: Hi Team, Can we have a SQL query to get absence leave requests which are in denied status. Thanks, Madhuri.Madhuri Brammadevara 371 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Is it possible to FTP the Create customer statement report output?Hi, We have client requirement to send the Create customer statement report output to FTP location when delivery flag for a customer is PRINT. I have modified the bursti…Babasaheb Bhujbal 82 views 3 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
How to get the list of users who has downloaded a specific report in HCM Shared folderSummary: To get the list of users along with time, who has downloaded a report from HCM Folder Navigation : Shared folder --> Pick any report --> Open the report --> Exp…Siva Sankari N 63 views 3 comments 1 point Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Associate a pre-existing instructor with all his/her personal data (ID card, CV) to multiple coursesHello everyone, I'd like to associate a pre-existing instructor with all his/her personal data (ID card, CV) to multiple courses, without the needs to upload the same da… -
Pricing List ReportHi, I am looking to create BI publisher report on Pricing List. If you can share the query and RTF template if any available please do share ThanksMohammed Rafi 31 views 2 comments 1 point Most recent by Mohammed Rafi Reporting and Analytics for ERP -
query to pull Reporting information calculation cardSummary: query to pull Reporting information calculation card Content (required): Hi All, Greetings! We are looking for a query to pull Reporting information calculation…Parag Hiremath 3.6K views 8 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Oracle Recruiting Cloud (ORC) Requisition Submission events history trackingSummary: IRC_SUBMISSIONS table holds a snapshot of a last step in process but a complete history of submission processing events is required. Content (required): Is it p…Valeriy Gorbunov 141 views 3 comments 0 points Most recent by Deepa Venkatesan Reporting and Analytics for HCM
-
Combining Oracle HCM Source and data from Microsoft Excel file sourceSummary: Combining Oracle HCM Source and data from Microsoft Excel file source Content (required): We have created a report where we have defined a data model with a joi…Vasanthakumar Ravi 111 views 7 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Management hierarchy setup does not work in absence approval processDear Oracle community, We created an approval rule in the transaction console and set the management hierarchy the following way (see screenshot 1), as we want the line …
-
Planning App not visibleSummary: Planning App not visible Content (required): Hi experts, we are trying to deep dive learning planning & budgeting features but we do not are able to see the Pla…
-
Query to fetch List of OTBI usersHi Team, We do have a requirement to Create a report for List of users having OTBI access. Regards, RamuVadde Ramu 61 views 3 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for ERP
-
How to find from which system or ip submitted a bip reportSummary: can we check from which system or ip a bip report got triggered? we are using a generic login shared across all developers and testers Content (required): can w…Lavakumar 11 views 1 comment 0 points Most recent by Dharmendra Shukla Reporting and Analytics for ERP
-
BIP Report - Dynamic Password Protection For Excel OutputSummary: Is it possible to protect the BIP Report excel output file with Dynamic password? Content (required): Hi Team, I am looking for dynamic password protection for …Sudarshan Uppara 154 views 6 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Obtain the number of SQL executions or the number of executions of the BIP itselfSummary: I want to create a query to extract the number of data model runs or BIP reports run in ERP's BI publisher. Content (required): The objective is to extract the …YUTA TOGASHI-Oracle 41 views 3 comments 0 points Most recent by YUTA TOGASHI-Oracle Reporting and Analytics for ERP
-
BIP Data Model with an Excel Data sourceSummary: I have a BIP data model with an HCM SQL data set/source and an Excel data set/source, which pulls the required data successfully. However, when I refresh the ex…Paul Morrissey 71 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Security feature for AR invoice print options available in view image button of transactionsWe have enabled password protection on AR invoice. When we using download button to save the AR invoice security feature is working as expected, But some of user using s…Siva Gollapalle 51 views 7 comments 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
SQL query need to be debugSummary: Hi all, The Query which I run is showing the field names and the data is not populating. please help me to debug the error. Content (required): Outer joins need…RamkumarKadhiravan 11 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM -
Activities of an offering is not shown in backend tablesSummary: There are 2 offerings in a course that we have made and the activities of one of the offering is shown in the backend tables but the activities of the other off…
-
I am getting exception error for a scheduled report through bursting for an OTBI querySummary: Scheduled an OTBI report through bursting but getting an exception error. Content (required): Job processor caused exception [INSTANCE_ID=bip.bi_server1] [INSTA…Srini Padmanabhan 214 views 13 comments 0 points Most recent by Supriyaa Damodaraswamy Reporting and Analytics for HCM
-
Is there any report that can be produced indicating when a user logs in using a password or SSO?Summary: Is there any report that can be produced indicating when a user logs in using a password or SSO in fusion? Content (required): Report/SQL Version (include the v…Fazal Subhan 21 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
UNable to query fusion_mds.mds_pathsSummary: UNable to query fusion_mds.mds_paths Content (required): Hi Team, There is insufficient privilege error received when we try to run query against table fusion_m…Parag Hiremath 44 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BI Publisher version controlSummary: Version control repository for BI Publisher Code Content (required): We would like to know how we can achieve version control for BI Publisher reports and metad…Ram Shankar 111 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
How to use better the indexes on the Oracle HCM cloud tables for efficient SQL writing?Summary: Oracle HCM OBI tables list has list of indexes on each table. Can you please explain what is the significance of those indexes and how to make use of them for m…Amit Patil 132 views 2 comments 0 points Most recent by User_2025-07-18-00-53-38-974 Reporting and Analytics for HCM -
Add external content and modify some part of the original oneHi, We would like to add external content (e.g, from Linkedin Learning) and modify some part of the original one, for example, the description. Is it possible to do it? …