BI Publisher
Discussion List
-
How to count the number of pages per supplier in a report using RTF.Content (please ensure you mask any confidential information): I am creating reports using BIP (BI Publisher), and I use RTF templates for the layout. The report outputs…yokokawa 73 views 2 comments 0 points Most recent by Takaomi_Kamakura-Oracle Reporting and Analytics for ERP -
Custom Fonts Not Reflected in PDF Output – BI Publisher RTF Template (OLC Certification)Hi All, In the OLC module, our client provides certifications with text styled in custom fonts. I have uploaded an RTF template in BI Publisher and exported it to PDF fo…
-
Query to make audit on Document of RecordsSummary: Content (please ensure you mask any confidential information): Hello experts, is there a way to track who loaded document of record type and attachments, when t…Valerio Curzi 41 views 2 comments 1 point Most recent by Diane Stuart Reporting and Analytics for HCM -
CIP asset AdjustmentSummary: Hello, Could you please suggest the correct approach to adjust or remove the cost for a CIP asset in Oracle Fusion Assets? We are encountering the following err…
-
What are the criteria for an AR invoice to appear on the Manage Revenue Adjustments screen in FusionHi All, We are planning to develop a BI Publisher (BIP) report based on the invoices that appear on the Manage Revenue Adjustments screen in Oracle Fusion Cloud. Could s… -
How to find the Report path with the report nameSummary: I have the report received to one of the recipient. The recipient request to add another person name to the report scheduling. I do not have the information whe…
-
How can we track which users have executed an Oracle Fusion BI Publisher report from the catalogSummary: We want see the Report details who ran from catalog. is there any tables which stores that info to extract. Content (please ensure you mask any confidential inf…Sreekanth Kandula 31 views 7 comments 0 points Most recent by Sreekanth Kandula Reporting and Analytics for HCM
-
Fusion BIP Print Receivables Transactions with swiss QR bill / swiss QR codeSummary: We are searching for a Oracle Fusion Cloud working process on how to create and include a swiss QR bill (payment and receipt part) into the Print Receivables Tr…
-
Fixed Asset approval status datasource in OTBISummary: Do we have OTBI subject area to create list of unapproved assets? A customer is creating OTBI report to extract unapproval asset list. If not is there any equiv…
-
Retrieve User ListSummary: I would like to create a BIP report to retrieve a list of user information. Content (please ensure you mask any confidential information): Please let me know wh…higuchi 24 views 8 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Query to fetch Cost Center Details which are not mapped at Department LevelSummary: i need a query to fetch all cost center which are not mapped to the department. If anyone have SQL query please help me. Version (include the version you are us…
-
Changes to expense approval template does not reflect after 24hoursHi all, We have a requirement to modify expense approval template to add the account number to show up on the email notifications. To achieve this, I have modified the '…
-
bi publisher with xml parameterSummary: Hello community, I have the following requirement: From OIC, I need to send data to a BI publisher so that it can return a PDF file containing the data I send. … -
Any Roadmap for Oracle Cloud Financial Redwood?Summary: Hi All, Is there any road map for redwood implementation for Oracle Cloud Financial, what all new features will be added and what will be time line. If any one …Tauseef_Akram909 33 views 1 comment 4 points Most recent by Dawn Cawston - CPS Reporting and Analytics for ERP
-
BIP report Pivot filter not functioning as expectedSummary: Running an online layout for a pivot date from a data model doesn't properly filter null dates Content (please ensure you mask any confidential information): Fo…Marko Puskac 11 views 2 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
bip report to get the approval history and status and also future approversSummary: Hi Experts bip report to get the approval history and status and also future approvers if the task is in progress. Any sample report sql query can you please sh…MudshaikhMub 23 views 5 comments 0 points Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP
-
Extracting from tag using substring and instringMorning all My tag has in the xml has this: I need to extract segment1 which is ST2, segment2 which is A007 and segment3 which is 2147 but into separate columns in my bi…
-
Need to display employee records transferred from Payroll to GLContent Hi All, We transferred the data from Payroll to GL. Now we need to display those records either in OTBI/BIP. Can you suggest do we have any subject area/BIP tabl…
-
[nQSError: 60009] The user request exceeded the maximum query governing execution time.Hi All, We have an OTBI report ,with "payroll-Element Entries history real time" subject area, when user run the report with date parameter they get the following error.…Sushant95-Oracle 185 views 3 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Query to fetch Transaction console entries along with multiple Approver detailsSummary: Need a Query to fetch Transaction console entries along with multiple Approver details Content (please ensure you mask any confidential information): Version (i…NagasaiM135 22 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Need a query to get latest activation Date for Supplier Site so we need to restrict a custom reportHi Team, We built a custom report for Supplier and supplier site info and we got a requirement that we need to restrict the supplier sites which got recently activated i…Sarath Lakshman 11 views 7 comments 0 points Most recent by Shyam Patel Reporting and Analytics for SCM
-
Does BIP reports support docuSign?Summary: Content (please ensure you mask any confidential information): In this discussion it seems docuSign is not supported for BIP reports. Can someone from Oracle co…Stefano_Mazzocca 1 view 0 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Auto Refresh InfotilesSummary: Client would like an invoice “dashboard” experience in Oracle Fusion Cloud that updates in near real time (or auto-refreshes on a set interval) without users ma…
-
Auto Refresh InfotilesSummary: Client would like an invoice “dashboard” experience in Oracle Fusion Cloud that updates in near real time (or auto-refreshes on a set interval) without users ma…
-
How to search for future approvers in an approval process in Oracle HCM Cloud by query?Good morning! How are you? I have a question, exists any VIEW objects or table (Im creating a bi publisher) that I can use to get the information of all the approvers of…
-
Are there User Entity for Individual Compensation Plan In HCM ExtractSummary: Are there User Entity for Individual Compensation Plan In HCM Extract Content (please ensure you mask any confidential information): Version (include the versio…Ketan-Oracle 11 views 0 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM -
Separate Remittance Advice based on custom data modelSummary: Is there a way of customising the disbursement extract associated with the Separate Remittance Advice for cloud customers. Our requirement is to add details to …Tim2021 551 views 5 comments 0 points Most recent by Sai Revanth Payables, Payments & Cash Management
-
Customizing Separate Remittance Advice Subject with dynamic valueSummary: Customizing Separate Remittance Advice Subject Content (please ensure you mask any confidential information): Hi Team we should customize the subject with PAYEE…Luca Nobili PWC 251 views 6 comments 1 point Most recent by Luca Nobili PWC Payables, Payments & Cash Management
-
why is there no EVENT_ID in FA_DEPRN_DETAIL for certain assets for depreciations?Summary: For certain assets, which have depreciation reserve balance and the account as shown in view accounting in Asset Inquiry screen. The Same asset, does not have E…