BI Publisher
Discussion List
-
customize standard reportSummary: Hello everyone, Can you tell me how I can find out which standard report is associated with this view in the purchasing module > purchase requisitions? I've tri… -
BIP Output file is not moving to FTP ServerSummary: BIP Output file is not moving to FTP Server Content (please ensure you mask any confidential information): Hi Team, Greetings! We have observed that the file SF…Parag Hiremath 105 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to dynamic format currency amounts in an RTF template (ref. Doc ID 1588933.1)?Summary: Hello, I have the following challenge that we need to format certain currency fields in an RTF (invoice) template regarding certain conditions WITHIN the templa…Frank.Steinjan 75 views 6 comments 1 point Most recent by Frank.Steinjan Reporting and Analytics for ERP -
PVO that has attribute columns in per_location_details_fSummary: We are on FDI 25.2—looking for a PVO which has the attribute columns in the per_location_details_f table in Fusion. Content (please ensure you mask any confiden… -
Does Interactive Budget Control Analysis Report has a dependency on the ORA_BUDGET_MANAGER_JOB?We have copied seeded Budget Control Analysis Report under custom folder due to client's requirement and have created a custom budget manager role. We have just copied t… -
Is there any table available where we can get status of email sent via burstingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Aditi Agrawal2650 33 views 5 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Where can we get the History of the Position for a report.Summary: I am trying to do a report for Position Details and trying to find the 'History' changes which can be found in the Position "Details" page just below the "Grade… -
'Time type' field column mapping from which table to fetch itSummary: Hi All, We are creating one report to get the employee overtime unpaid overtime details. we are looking for 'Time type' field column mapping from which table to… -
How to add dependent Parameter in Custom ESS job setSummary: Content (please ensure you mask any confidential information): Hi, We have created a custom ESS Job set which has three jobs in serial: FA Exception Report (Job… -
Adding Attachments to Extensible Work Order Traveler ReportSummary: We have a requirement to customize the Work Order Traveler report and hence were thinking we can use the 'Extensible Work Order Traveler Report'. But when we tr…Deepthi Suravaram 165 views 20 comments 0 points Most recent by Sumit Patil Reporting and Analytics for SCM -
Time card details query in Fusion OTLSummary: Hi All, We are creating one report to get the Time card details. we are looking for 'Time type' and 'Override dept costing' fields. We couldn't able to find the…Sai Krishna Chelikani 4.7K views 7 comments 0 points Most recent by Sri N Reporting and Analytics for HCM -
Help on Defining the LOV in BIP Excel TemplateHi Team, We have requirement to define a Person Name List of value in BIP excel template . Report will be run by Manager. Based on manager scope list of person Name need… -
Is there a query that returns all valid grades ever associated with a position with eff datesWe found an issue on Positions where Valid Grades, previously deleted via HDL, are returning as a valid grade in the UI when any change is made on the Position itself. W…desirae_coleman 12 views 0 comments 0 points Started by desirae_coleman Reporting and Analytics for HCM -
Historic values for pay_bank_accounts tableSummary: Historic values for pay_bank_accounts table Content (please ensure you mask any confidential information): This table has MASKED_IBAN field but when I change it…Stefano_Mazzocca 11 views 0 comments 0 points Started by Stefano_Mazzocca Reporting and Analytics for HCM -
PDF and doc / docx document types not supported as attachments to Expense ReportsSummary The expense report printed from the system using “Print Preview with Attachments” shows blank pages in place of the so called “unsupported” attachment formats (P… -
Custom BIP report for Accounts payable trial balanceSummary: I am developing a Custom BIP report for Accounts payable trial balance. Here the paramters are legal entity, as on date and business unit. When I am trying to p… -
How can we query the error message in BI Server's Report Job History?Summary: Error Log Report that will display the error message like in the Report Job History Content (required): Hi, We wanted to create a custom report that will output…Kristelle 408 views 16 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Is there any SQL to help me identify missing Associations in a Taxable Benefits Calculation CardHi, We have started Payrolling Benefits this tax year and have identified an issue where a Calculation Component, along with the Calculation Component Details have been … -
Identification of missing associations on Calculation CardsSummary: Identification of missing associations on Calculation Cards Content (required): Hello Experts, Can you please suggest if Identification of missing associations … -
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 226 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 487 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…