BI Publisher
Discussion List
-
REST API for Receivable Invoices (CM/DM/ONACC)Summary: Hi Team I am looking for API to get the details of Credit Memo, Debit Memo and On Account Invoices. I am not able to get those data when using /resources/latest…sailesh_cloudare 91 views 3 comments 0 points Most recent by Daniel S.-Oracle Receivables & Collections -
Why to use e-text format in BIP report when we can use default csv formatSummary: Why to use e-text format in BIP report when we can use default csv format Content (required): Why to use e-text format in BIP report when we can use default csv…ShitalRamteke 11 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
Is it possible to trigger Notifications while adding or replying to comments in learning community.Summary: Need to Trigger Notification to community learners when there is any comments or reply added into the learning community portal. is there any seeded functionali… -
How to View BIP Report Output in CSV Without Creating a LayoutSummary: Default the output of BIP Report to csv without having to setup a layout Content (required): In order to set the Default Format of a BIP report to csv you must …Rory Mullin 341 views 3 comments 0 points Most recent by Rory Mullin Reporting and Analytics for ERP -
How to calculate number of periods based on the start date & end date of a GL PeriodSummary: Hello experts, I have a requirement to calculate the number of periods for a particular Invoice Multiperiod Accounting dates mapped to. For example, if the mult…Satyavrat_Savarn 72 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Fusion OTBI - Structure and Components Real TimeSummary Fusion OTBI - Structure and Components Real Time subject areaContent HI I am trying to do an OTBI Analysis with Structure and Components Real Time subject area t…Angel Espadafor 118 views 3 comments 3 points Most recent by tapan.nayyar Reporting and Analytics for SCM -
Print Preview can not be customized to show approverSummary: When I try to modify the "Printable Expense Report Template" as described here: https://docs.oracle.com/en/cloud/saas/financials/23c/faiex/modify-the-printable-…Anders W. Langholm 1 view 0 comments 0 points Started by Anders W. Langholm Reporting and Analytics for ERP -
Print Preview can not be customized to show approverSummary: When I try to modify the "Printable Expense Report Template" as described here: https://docs.oracle.com/en/cloud/saas/financials/23c/faiex/modify-the-printable-… -
From what basis data's are populating to AR_STATEMENT_DELIVERY TableSummary: From what basis data's are populating to AR_STATEMENT_DELIVERY Table Content (required): Version (include the version you are using, if applicable): Code Snippe…CJPandian 61 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
Need suggestions / opinions for sending termed records for xx days in reports and extracts.Summary: Hi Experts, we have a requirement to send all active records and termed records that were termed in the last 10 days. please note this is problem encountered pr…Jithin Mathews 21 views 4 comments 0 points Most recent by Jithin Mathews Reporting and Analytics for HCM -
PPM: Data Security in Custom I Publisher ReportSummary: We need some sort of Data Security to be handled in Custom BI Publisher Reports related to Projects module. We are looking for options related to the seeded Sec…Balachander G-Oracle 161 views 2 comments 0 points Most recent by David Wright - More4apps Reporting and Analytics for ERP -
Sending fails when encrypted PDF is being sentHello, I've to send a PDF file format with pgp encryption to SFTP server. I already uploaded the pgp key in BIP. When testing the file's sending, I am getting an error m… -
Goal Task detailsHi, Which Table or subject area contains goal task details? Regards, NivyaNivya Mathire 32 views 5 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Facing the issue in below BI report query error is single row subquery returns more than one rowSummary: HI Team, We have report I'm facing the issue when i run the report or scheduled the report i'm getting below error but I'm unable to find the issue ? ERROR : OR…AjayKumar Maddipati 41 views 7 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
How t get login detail report in oracle fusionSummary: Content (required): Dear All How we can generate login report in oracle fusion for all the users , with Date , Time , user Name etc.. Version (include the versi…Shameer Muhammed P M 212 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
Data issue- OTBI AnalysisSummary: We have an OTBI analysis to capture benefit details and I noticed that it's providing information for one legal entity although are three legal entities added i…Ayesha Iroshani 41 views 13 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM -
Oracle BI analysis - Relative deep links in interaction actionsSummary: Relative deep links in interaction actions Content (required): We are trying to add relative deep links to a big number of performance counter tiles. How can we… -
BI Publisher RTF template with Excel output merging rowsSummary: I have a HCM Extract which outputs as Excel via an RTF template. However on the output it is merging 3 rows for each row of data (see below screenshot). Does an… -
Custom SQL reports don't return data in another language anymoreSummary: Four users with the same security roles and Area of responsibility ran a report. 2 English-speaking users saw data, while the 2 French-speaking users no longer … -
The BIP Excel layout returns no dataSummary: I downloaded a data sample from the data model, added the fields to Excel (creating a XDO_Metadata sheet). The template with the sample data looks fine: But whe… -
Evaluation Report is not shown Answer Text and Comments attached to AnswersSummary: I created an Evaluation Report with following details like Question Text, Answer Text, Response List ShortText, Response Status using Learning Managment Real Ti… -
How can a User view scheduled OTBI reports monthly?Summary: I removed the BI Author & BI Administrator role from a custom role for a user - leaving only the BI Consumer role within this custom role. User is not able to v…Akbar Ahmed 51 views 2 comments 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP -
How to identify a merged person record in the Oracle Fusion HCM Cloud databaseSummary: When querying the database for person records, I want to exclude merged records from the output. How do I identify merged records in the table? Content (require… -
Filter that will capture future date assignmentsSummary I created a report that is capturing Action Type: Terminate Work Relationship.I need to filter the report to only show scheduled terminations for a specific mont…User_2025-01-25-00-37-41-739 68 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
People review meeting How to identify the Metting submitted by HR or manager, Whic table we can see?Summary: i have created one people review meeting. i have added 2 employees' population and 2 reviewers' manager. i have logged in as 1 manager and submitted the meeting…challa praveen 21 views 0 comments 0 points Started by challa praveen Reporting and Analytics for HCM -
Capture the Course and Offering StatusSummary: I need to capture course status and offering status. I have a requirement where I need to capture course status and offering status of the relevant course. Cont…Sanduni Pathirathne 11 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM -
Need a query which show all pending transactionSummary: Hi Everyone, I need a query in which we can show all pending, stuck transactions along with the person's name and approvers' information. Like, the document pro… -
Custom fields in Customized report not displayed in XML when report is run but appears in Data ModelSummary: Hi Team, We have customized the Journal approval workflow notification in Oracle Fusion to add custom fields and logic. The customizations for Journal Headers d…Abhilash K - Deloitte USI 65 views 0 comments 1 point Started by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Include project details AP Payment CheckSummary: In 'Disbursement Payment File Formats' oracle Seeded XML file I did not see AP invoice project details, if invoice is mapped to any project details. How to map …Narendra Prasad Golla 21 views 1 comment 0 points Most recent by Narendra Prasad Golla Payables, Payments & Cash Management -
How to encode etext output file from UTF-8 to ANSI in OracleSummary: We have custom etext payment file for Citi Bank EFT. the output of Etext file is .txt and it is encoded in UTF-8 by default. how can i convert this text file fr…SireeshaJaladi 366 views 0 comments 0 points Started by SireeshaJaladi Reporting and Analytics for ERP