BI Publisher
Discussion List
-
In what subject area can i find the XML delivery related fieldsSummary: On the manage transaction page, I see two fields related to electronic invoicing / XML devlivery Ready for XML Delivery XML Delivery Status XML Delivery Error M… -
Displaying PO Line and Receipt Number in Asset After PO Receipt Mass AdditionWe have a requirement to track purchase orders in detail, including the PO receipt, from the mass addition asset process. We executed the standard program "Transfer Rece… -
Journals for mexico reportI am trying to run Journals for Mexico report . every time i run the report it is STATUS shows retrying. it is not producing any output. Can anyone tell me in the parame…
-
Unable to fetch accounting information from asset transactions screenHi, We have a requirement to fetch accounting information for an asset transaction for a particular class. We need to understand the links in between to create a BI repo… -
How to create one report that shows users, roles, and privileges on those roles?Summary: I need to create one report that shows all users and assignment info, the security roles on their accounts, and the privileges associated with each role. Does a…jpar 252 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Export to XLSX and avoid limitation for 65k rowsSummary: Content (please ensure you mask any confidential information): Hi there, I use Learning reports in Fusion. When I export a BI report that has more than 65K rows…Bobby Jourdan 152 views 12 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Need sql for all Content including Catalog Item the Content is tied to from Learning moduleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Sivaram Injeti 31 views 3 comments 0 points Most recent by Sivaram Injeti Reporting and Analytics for HCM
-
Receivables - Customer Real Time OTBI is not showing any report dataSummary: We have an OTBI report where we are using Receivables - Customer Real Time subject Area. When I run the report, its not showing any data. I have BI admin, Accou…
-
Error: This folder is read only. You cannot create a Data Model here.Summary Error: This folder is read only. You cannot create a Data Model here.Content When saving a BI Publisher data model in a particular folder I get this error: This …Ruzwan Akram 488 views 10 comments 0 points Most recent by John Guner Reporting and Analytics for HCM
-
Retrieve Department Hierarchy per User Assignment (with Effective Date)Summary: Hi everyone, I'm wondering if anyone has a query that returns the organizational department structure for users based on their assignment, while properly consid… -
How to send formatted Payment Files from Oracle Cloud to a SFTP-server automaticallySummary: How to send formatted Payment Files from Oracle Cloud to an external SFTP-server automatically? Content (please ensure you mask any confidential information): H…Marcus S. 280 views 12 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
Repeat section in RTF and add total on each pageI have the following two tables in an RTF document: The first table displays data from the DM Header. The second table displays data from the DM Lines. The client has re…
-
is it possible to translate tags in OTBI in arabicSummary: I am developing a BI report in arabic, but the data I want to print through Tags (dynamically) in report such as Legal Entity Name, Legal Entity address, Bank n…
-
Default first name for DFF value using SQL querySummary: Hi Team, We have a requirement to default the person name or first name on DFF filed using SQL query. By default the DFF value should be the person name who is …
-
Can anyone suggest me how can I pull Requisition Hierarchy in Report in fusion HCMSummary: I want to capture all approver in the report. Can anyone suggest me how can I move. Content (please ensure you mask any confidential information): Version (incl…
-
Flexibility of Separate Remittance Advice Email BodyContent (please ensure you mask any confidential information): Currently, our client would like to have an email body to an SRA if the delivery method is 'Email with .pd…Christian Roxas 11 views 3 comments 0 points Most recent by Christian Roxas Payables, Payments & Cash Management -
Participant Feedback Report RequestSummary: Does anyone have a good way to report on 360 participant feedback within a performance document? We've tried to use the Workforce Performance - Performance Rati…Anton Rzhanov 41 views 3 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BIP Report Query to Fetch Participant (Matrix Manager ) as Reviewer in Perfofmance DocumentSummary: Can anybody Please share the query to Fetch details of Participant Name as Matrix Manager as Reviewer along with Review Period and Performance Documents in Perf…MilanMohanty 121 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
HSBC Pain.001.001.03Summary: We are implementing payments in Fusion cloud with HSBC as our bank. Bank has specific requirement to have the oracle payment file in 'pain.001.001.02' or 'pain.…
-
bursting is not workingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Unable to view the Export option while accessing the OTBI report via Performance TileSummary: Hi. I think I have a similar issue to https://community.oracle.com/customerconnect/discussion/561120/unable-to-view-the-export-option-while-accessing-the-otbi-r… -
I embedded a BIP report in front end. But refresh button is causing problem.I embedded a BIP report in front end. But refresh button is causing problem. First I have to click apply and then refresh button (green higlighted) then only report is a…
-
What are the Scheduled Process Tables that could connect to the business unitI'm trying to get the connection of the tables uses to store the scheduled process and join it to the table of business unitShe_1080 31 views 1 comment 0 points Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP
-
How to generate the BIP report with the user time zone rather than the server time zone?Summary: Our reports are generated in UTC time zone, especially when it comes to Exit reports the LWD & the submitted dates are not matching because of time zone differe…Elavarasan S 114 views 2 comments 0 points Most recent by Elavarasan S Reporting and Analytics for HCM -
Custom report Layout/Template not showing for a user for Accrual Reconciliation ReportSummary: Custom report Layout/Template not showing for a user for Accrual Reconciliation Report Content (please ensure you mask any confidential information): We previou…
-
Is it possible to report on default validity rules of courses?Summary: Is it possible, using BI Publisher or OTBI, to report on courses Default Assignment Rules (specifically the fields: Validity Period Starts/Validity Period Optio…
-
How to fetch current incumbent name for a Position_code/position idSummary: Please Help! Please share your insights ASAP! I need help in fetching current incumbent name tagged to a position code. I wrote the query like this : SELECT DIS…
-
Bursting Issue in Balance Forward Billing ReportSummary: We are encountering an issue with bursting in the customized Balance Forward Billing seeded report. Content (please ensure you mask any confidential information…
-
Reporting employee access to dataHello Experts, It was rise as a demand the possibility to have a report on what employee has access of country data, i was trying to use per_person_secured_list_v and pe…Lucas B Maciel 21 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM