BI Publisher
Discussion List
-
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 … -
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 14 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
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 … -
How to create Dependent List of Values parameter in ESS Job with User-defined (SQL) LOV as SourceSummary: I would like to know if it is possible to create a parameter in an ESS Job that is dependent on another LOV parameter that has a User-defined (SQL) LOV Source. … -
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… -
How to Remove Blank Spaces Appearing from Hidden Conditional Tables in RTF TemplateI have an RTF template with 3 separate tables that display conditionally based on a parameter (ITEM, ASSET, WorkOrder). When one table is selected, the other two are hid…Voladri Saikiran 12 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Which exact privilege or duty role allows user to access Security dashboard?Summary: We want to give user access to below seeded reports. Currently "Application Implementation Consultant" gives that access but we cannot assign the role due to ot… -
Error generating view. Error getting cursor in GenerateHeadSummary: We are stuck with this error: I have executed these processes: Publish Chart of Account Dimension Members and Hierarchies to Balances Cubes Create Rules XML Fil…Bo Tøpgaard 378 views 11 comments 0 points Most recent by Yeung Shing Keith Reporting and Analytics for ERP -
Sql query to get PO Change Order line Details.Summary: https://us.v-cdn.net/6034893/uploads/BATNEQXAX0VY/change-order-fields.docx Required sql query to get following PO Change Order line Details. Columns: Attribute …Praneeth Nalluri 732 views 2 comments 0 points Most recent by Sandeep Marka Reporting and Analytics for ERP -
I need to find a way to Audit who deleted a folder in Reports and AnalyticsWe are live on Oracle Fusion, and we have a bunch of Reports and Datamodels in Custom folder in Reports and Analytics. Someone deleted one of the folders and we need to … -
Query to fetch project and Time card entries(OTL)Summary: Hi Team, We need a table where the project number and time card entires details or SQL query Content (please ensure you mask any confidential information): We n…Opkey PA 918 views 5 comments 0 points Most recent by Sathyaseelan Chandran Reporting and Analytics for ERP -
Is there an Oracle standard report that lists the permissions for all folders in the BI Catalog?Summary: Is there an Oracle standard report that lists the permissions for all folders in the BI Catalog? Version : 25D -
Unable to find the table and column in which "Grouped construction in progress" flag at project ExpContent Hi All, I am able to find the "Grouped Construction in Progress" flag at project expenditure level. please find the navigation attached. I'm unable to find the f…User_7IVGK 195 views 7 comments 0 points Most recent by ramesh.daniyala.mcd Reporting and Analytics for ERP -
Can Oracle provide listing of object changes to Journal and transaction Details Report after 25A?Hello, Our auditors are asking why the delivered Journal and Transaction Details report was modified on 4/4/2025. This is a delivered report so our company does not have…Jason Madden 15 views 2 comments 0 points Most recent by Jason Madden Reporting and Analytics for ERP -
How to embed logo or image in email body using email bursting querySummary: Need info on Parameter5 of email bursting query can be included with image file or Logo in it. We want company logo to be added along with email body .Please gu…Ezhil 231 views 5 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
How to download all attachments from a Projects Invoice workflow transactionSummary: How to download all attachments from a Projects Invoice workflow transaction Content (please ensure you mask any confidential information): Approvers are attach… -
Budgetary Control Carry Forward Sample BIP ReportsSummary Sample reports to identify transactions that impact budget account balances, and also facilitate the identification of transactions and balances that need to be …Anne Wong -Oracle 1K views 8 comments 7 points Most recent by Mohamed Elwan Reporting and Analytics for ERP -
Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsSummary Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsContent Adding Project Classification (Class Code) to OTBI report duplicate Costs R…User_2025-01-30-23-00-53-497 117 views 5 comments 1 point Most recent by Rich Merkel Reporting and Analytics for ERP -
Invoking the runReport operation of the ExternalReportWSSService with reportData supported in FusionSummary: Is invoking the runReport operation of the ExternalReportWSSService with reportData as input a supported approach in Oracle Fusion? Content (please ensure you m…Aseef Babujan-Oracle 2 views 1 comment 0 points Most recent by Aseef Babujan-Oracle Reporting and Analytics for ERP -
"HRC_TXN_TAC_HISTORY" - Audit report for corrections to transactionsSummary: We have enabled the editing function within the Transaction Console. Users can now adjust the transactions to make corrections while not yet approved. Is there … -
Method to Bulk Retrieve and Review Job DefinitionsSummary: Method to Bulk Retrieve and Review Job Definitions Content (please ensure you mask any confidential information): Task Name: "Manage Enterprise Scheduler Job De… -
Purchasing Documents Pending ApprovalSummary A Report showing purchasing documents which are currently pending approval and the person they are currently assigned to.Content - If you want a report that simp…Ifeanyi Katchy-Oracle 4.2K views 55 comments 20 points Most recent by Shyam Patel Reporting and Analytics for ERP -
Email Oracle seeded ESS Job:Import Costs: Generate Output Report outputSummary: We have requirement to email output of 'Import Costs: Generate Output Report'. We find it challenging as this is child job for 'Import Costs' . This report 'Imp…Manjusha ERP Tech09-Oracle 5 views 0 comments 0 points Started by Manjusha ERP Tech09-Oracle Reporting and Analytics for ERP -
Suppliers with Duplicate Taxpayer ID Report not Available to RunSummary: No capability to open or schedule the Suppliers with Duplicate Taxpayer ID Report Content (please ensure you mask any confidential information): Our business us…AnuragGandhi 25 views 1 comment 0 points Most recent by AnuragGandhi Reporting and Analytics for ERP -
BI Publisher PCL Printing Issue: Layout Output Appears Scaled DownI would like to ask for your advice regarding the output of a BI Publisher printing. When we register the printer in the ERP and issue the print job using PDF to PCL fil… -
Getting duplicate records from AP subledgerSummary: Getting duplicate records from AP subledger Content (please ensure you mask any confidential information): Hi All, I have a requirement where i need to fetch th…Pritam Das 48 views 10 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP -
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 '… -
Query to get PPR pending approver nameI need to extract data for Payment Process Request ( PPR ) with pending approver name. -
BIP Report Interactive LayoutSummary: We have developed an interactive layout in our report. We are looking to see if we can do below, How to add scroll bars to table data in the layout How to align…Nagarjuna Nudurupati 9 views 0 comments 0 points Started by Nagarjuna Nudurupati Reporting and Analytics for ERP -
Subject area for FND Flex valuesWe have a flex set defiend with values for categories. This flex field is used as source on invoice as DFF. Payable Subject area is used to design a report and we are us…