BI Publisher
Discussion List
-
How do you manage consecutive check number using Remittance stub?Summary: When you use Remittance Stub and Void by Overflow in "ExternalCheck.rtf" template for PPR in Account Payables, you have check numbers for void check as well as …Yuko Asanuma 51 views 2 comments 0 points Most recent by Nandyala Harish Reddy Payables, Payments & Cash Management -
Create 'Buyer Assignment Rules' ReportGood Day Experts, Is there a way to create a report to show details and information for Buyer Assignment Rules? Screenshot below is the view from Fusion Application. Col… -
German Characters are displayed as Junk.Summary German Characters are displayed as Junk.Content Hi All, We do have a Custom BIP Report to send the extract to External System. When we submitted the report manua…Uvaraja-Oracle 46 views 1 comment 0 points Most recent by UchihaItachi Reporting and Analytics for ERP -
table/view to list all users with assigned role namesSummary: table/view to list all users with assigned role names Content (please ensure you mask any confidential information): I am looking for an Oracle Table/View name …Naved Khan 1.3K views 6 comments 0 points Most recent by Dai Huynh Minh Reporting and Analytics for HCM -
Date filter in rtf templateSummary: Hi All, Good Day! The template is in RTF . need to see the output in excel. Can anyone help on this ! Content (please ensure you mask any confidential informati… -
Restrict user to go to Analytics pageIs there a way to restrict user to access to Reports & Analytics page. From Structure i have disable the Report & analytics page from Navigator and springboard. But we a…Sourabh Patial 91 views 9 comments 0 points Most recent by Sourabh Patial Reporting and Analytics for HCM -
Not able to customize Print Commercial Documents ReportSummary: Not able to customize Print Commercial Documents Report Report Path :Shared Folders/Custom/Financials/ Transaction Tax/Poland Report : Print Commercial Document… -
Dynamic Link in the BIP reportSummary: I have to add a dynamic link to the BIP report that would redirect to the absence transaction. Is there a possibility to do this? Content (please ensure you mas…Parul00777777 11 views 4 comments 0 points Most recent by Jehosheba Amruthaluri Reporting and Analytics for ERP -
How to Schedule a BI Publisher Report with Dynamic time range in parameter Valueshttps://us.v-cdn.net/6034893/uploads/WA7NWICLO5VU/sr3-37375542081.docx Issue Description: We need to view the BIP Reports -'Execution History by User' and 'BIP Reports E…Rajesh Kumar Gunda 161 views 26 comments 6 points Most recent by Kevin M-Oracle Payables, Payments & Cash Management -
How to Query Reported Time for Specific Payroll Time Types Based on Time CategorySummary: I'm trying to query reported time entries for specific Payroll Time Types that belong to a particular Time Category — in my case, the category is called "**** T… -
OTBI – Extract Unposted General Ledger BalancesHello Team, I checked all the OTBI reports related General Ledger data and realized that there is no report to extract unposted balances. Could anyone please advise? -
BI Report to extract daily rates for a specific date rangeSummary: BI Report to extract daily rates for a specific date range Content (please ensure you mask any confidential information): Hi All, I have a requirement to extrac… -
Query to fetch the list of recommended courses again each employeeshi Team, Can anyone share a query to fetch the list of recommended courses against each employees? Thanks, Vinod -
<Line 3, Column 94>: XML-22002: (Fatal Error) Error while processing include XSL file..Summary: Hi, I have created BIP report which have main template and created one more bip report which have sub-template as I need to show the 2 layouts according to inpu…ManishaPatil 72 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Oracle criteria to identify BIP reports with specific column in itHi All, We are migrating to V3 Seniority Date from V1 Seniority dates. This migration is impacting our BIP reports which are using ‘ORIGINAL_DATE_OF_HIRE’ column from 'P… -
Fetching Tax Lines Based on AP Distribution Lines and Ship To LocationSummary: I'm trying to determine the correct, delivered method for linking AP_INVOICE_DISTRIBUTIONS_ALL with ZX_LINES in order to retrieve tax amounts at the individual … -
BI report for Enrollment Lifecycle details and dateCan we pull a BI report for Enrollment Lifecycle details and date(when user's status is moved from NotStarted to InProgress) from Learn course details -
Edit template and add new column in the existing templateHi We have an existing date model with 20 columns and all are selected in the report template. I have added one more column in the DM as per requirement but am not able … -
Child data groups XML tags are not generating in HCM Extract while email burstingSummary: We have created the HCM extract with multiple data groups with email bursting delivery option. After submitting the Extract just Parent data group tags are prin… -
How do I create an aged report for open transfer orders in OTBISummary: I am trying to create an OTBI Analysis for Open Transfer Orders. We would like to see a count by destination, date, cost of inventory item and possibly the GL A… -
Difference between 2 dates - BI PublisherSummary: Hello, I'm trying to get the difference between 2 dates in BIP data model. The difference should present number of days between cmp.DATE_FROM and cmp.LAST_UPDAT… -
SCM INT Process Work Order Details (ASN) Oracle to Third PartySummary: outbound integration report from Oracle to Third Party Content (please ensure you mask any confidential information): Hi Team, Need information on creating outb… -
In Job Details need Travel Required fieldSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
SQL to fetch the Target Proficiency field in the Performance DocumentHello Experts, I am currently creating a report for Core Competencies, and I am having a hard time searching for this specific field in the performance document page Doe…Joliver Caangay 21 views 1 comment 0 points Most recent by Suman Chenumalla-Support-Oracle Performance Management -
Deep Link for payment view in oracle fusionSummary: Please provide the deep Link for payment view in oracle fusion. Content (please ensure you mask any confidential information): Version (include the version you …User_B1ZBU 1 view 2 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management -
Issues with Decoding Large XML in adhocschedule Column for ESS Jobs inFUSION_ORA_ESS.REQUEST_HISTORYIssues with decoding large XML in the adhocschedule column for ESS jobs in FUSION_ORA_ESS.REQUEST_HISTORY. We have created a SR with Oracle. They recommended creating a …Rajesh Kumar Gunda 81 views 7 comments 5 points Most recent by Glen Ryen Payables, Payments & Cash Management -
Send Separate Remittance Advice RTF CustomizationSummary: We have customized RTF template for sending remittance information to the Supplier. We are pulling PO number from the invoice line level along with payment info…Rajesh Kumar Gunda 11 views 1 comment 0 points Most recent by Rajesh Kumar Gunda Payables, Payments & Cash Management