BI Publisher
Discussion List
-
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 7 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 370 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 710 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 891 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 194 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 10 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 224 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 116 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.1K 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 4 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 47 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… -
Can you explain the purpose of the BIPUBLISHER_V view and how the IAU_AUDITUSER column fits into itSummary: Can you explain the purpose of the BIPUBLISHER_V table and how the IAU_AUDITUSER column fits into it SELECT iau_resource , IAU_TSTZORIGINATING, IAU_INITIATOR , …KHALED IHADDADENE 110 views 3 comments 0 points Most recent by Debby P Reporting and Analytics for ERP
-
Blank page appears end of report in RTF template even though conditional split page is used.We are encountering an issue in a BI Publisher RTF template where an extra blank page is generated at the end of the PDF output. The template uses a conditional page bre…Sai Teja Madishetty 26 views 1 comment 0 points Most recent by Yemi Onigbode Reporting and Analytics for ERP -
Query for Approval DelegationContent Hello, I am looking to build a BIP Report which displays whenever someone has delegated approvals to someone of a lower job level - does anyone know where this i…Elliot Hall-Walker 326 views 4 comments 1 point Most recent by SR_1234 Reporting and Analytics for ERP -
Query to fetch the CARRIER_NAME, DELETE_SOURCES and DELETE_EXCLUSION for Sourcing RulesHi Everyone, Can you please help me with the SQL Query or the Fusion tables/columns required to fetch the following fields for Sourcing Rules( Supply Chain Planning → Ma…Sravanthi0310 11 views 1 comment 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP -
XDO_TEMPLATES_BSummary: I am not able to query XDO_TEMPLATES_B. Getting ORA-00942: table or view does not existhttps://docs.oracle.com/error-help/db/ora-0 Content (please ensure you ma…