BI Publisher
Discussion List
-
Looking for advice regarding creation of a report to load details into Costing for PersonsSummary: We currently have a report in place which gets run daily to load information via HDL to load into the Costing for Persons. It has been made aware the report is … -
Send copy/information of Printed invoices to specific recipient within the organisationContent When printing invoices and sending them through email we have a requirement for also notifying or sending the same invoice to a specific person within the organi…Stefan pettersson 186 views 2 comments 1 point Most recent by Hemal Maniar Receivables & Collections
-
Banco de Chile Electronic Payment File FormatHi, Can anybody share here "Banco de Chile Electronic Payment File Format"?CA Nirmal Choudhary 11 views 2 comments 0 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management -
eText BIP Template inserting blank row at top of output fileSummary: eText BIP Template inserting blank row at top of output file Content (please ensure you mask any confidential information): Hello, We have a BIP eText template …
-
Way to hide hyperlink on Workflow Notification / BIP RTF template based on Security Role?Summary: My customer wants to have me hide a "View Attachments" hyperlink on a DoR notification (BI Pub - RTF template) based on specific AoR role. I don't see how to pi…
-
BI Publisher Desktop 64 Template stop working and Publisher Menu does not show in MS WordSummary: BI Publisher Desktop 64 Template stop working and Publisher Menu does not show in MS Word Content (please ensure you mask any confidential information): BIPubli…FCL_coop_AS 201 views 13 comments 2 points Most recent by FCL_coop_AS Reporting and Analytics for HCM
-
"View image" navigationWe updated the HST & GST number in the system by end dating the existing one's and created newer ones the problem we are facing now is that when we click on "View image"…Sha Ahmed 11 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
Can conditional formatting be applied to the total cell in BIP pivot layout?Summary: Can conditional formatting be applied to the total cell in BIP pivot layout? Content (please ensure you mask any confidential information): Hi Experts, I could …Volodymyr Faranosov 1 view 1 comment 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Chart of Accounts Hierarchy Sort Order Field NameSummary: I'm building a custom BIP data model and report and I'm looking for the User-Defined hierarchy Sort Order field name info (table, field) schema = FUSION Content…Emile Helegbe 53 views 3 comments 0 points Most recent by Emile Helegbe General Ledger & Intercompany
-
I have created one BIP report, Output is .csv file. I am getting String values in Double Quote.Summary: I have created one BIP report, Output is .csv file. I am getting String values in Double Quote. I want to have the values without double quotes. I have tried it…VaibhavChavan20_ 111 views 3 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
How can we fetch the pdf output of the Journal Details Report using OICSummary: We are trying to send the pdf output of Journal Details report(report which gives detailed summary of FBDI load) using OIC. And as this ESS job output doesn't g…Abhinav Patil-Oracle 51 views 3 comments 0 points Most recent by Abhinav Patil-Oracle General Ledger & Intercompany
-
Customer Statement Report – Grouping Transactions by Site Name PrefixSummary: Hi Team, We have a requirement in the customer statement where we need to group all transactions based on the site name prefix FIN/PDR. Currently, the report is…Raman_Balasubramaniam 21 views 1 comment 0 points Most recent by Jigyansa-Oracle Receivables & Collections
-
Need query to get the list of all privileges for a given roleSummary: Need query to get the list of all privileges for a given role Content (required): Navigation: Tools > SecurityConsole > Roles If I query a role name, I am getti…Jaeyshree Kumaran Kalpana 8.1K views 17 comments 2 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
The supervisor hierarchy should be displayed in the report as a graphical representation.Summary: The supervisor hierarchy should be displayed in the report as a graphical representation. Content (please ensure you mask any confidential information): Require…
-
unable to query the rejected transaction details from the approval related tablesContent Hi All, We have a requirement to report on the approval transactions (approved/rejected) and we have built the query based on hrc_txn_fnd_bpm_task_vl and hcm_fus…Sricharan Monigari 394 views 5 comments 2 points Most recent by User_DTPT3 Reporting and Analytics for HCM -
How to output GL Amount for two months with parameter?I need to output GL amount for two months with BIP. There should be one parameter for setting Period. Then I need to output GL Amount for the month set by the parameter …Ayumi 1 view 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
We are not able to see the Retainage column in the seeded XML Separate Remittance Advice ReportSummary: Please let me know how we can include the retainage column XML tag in the seeded Separate Remittance Advice Report Content (please ensure you mask any confident…Karnati Saisree 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Need query to get Employee contribution and pretax deduction information of person Result?Summary: Hi Team, I need BI Report query for Employee contribution and pretax deduction information from Fusion Content (please ensure you mask any confidential informat…Ratan Nahak-Oracle 31 views 0 comments 0 points Most recent by Ratan Nahak-Oracle Reporting and Analytics for HCM
-
About the table having Segment HyerarchyI want to use information about Segment Hyerarchy in GL with BIP but I am not sure which table I should refer to. If you know, please let me know.
-
Need inputs to handle NULL values in OTBISummary: Need inputs to handle NULL values in OTBI Content (required): In case if an employee doesn't have Visa permit record then we are getting value as 00--0 in the O…
-
ISO20022 Format failing in CGI ValidationSummary: We use BMO Harris as our bank and we are trying automate Wire Payments. Bank supports ISO2022 Format, so we are trying to use ISO2022 format to send disbursemen…Sabarish Reddy Ganda 51 views 5 comments 0 points Most recent by Radhika Agarwal Sundarlal Payables, Payments & Cash Management
-
Is it possible to send two attachments PDF & XML Print Receivables Transaction?Summary: We have created an additional XML template for one of our clients and are currently using a UNION in the Bursting query to attach two files (PDF and XML) to the…Yahya Khan 24 views 1 comment 0 points Most recent by Mallik Durgumpudi-Oracle Receivables & Collections -
Can we customize the GL Journals seeded report to add a bursting query to send its output to ucmSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Abhinav Patil-Oracle 3 views 2 comments 0 points Most recent by Abhinav Patil-Oracle General Ledger & Intercompany
-
sql query or table name for Manage Account RulesSummary: Hi team, We need a table name or SQL query to get fields for the values type and values under the setup Manage Account Rules Content (please ensure you mask any…
-
Getting error ORA-00918: column ambiguously defined while adding table to seeded reportThere was an error rendering this rich post. -
Hide Data Models from BI Author and BI Consumer Roles - Access Impact?Summary: Content (please ensure you mask any confidential information): We want to remove the BI Author and BI Consumer roles from any folders that just contain data mod…Rory Mullin 32 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to get count in pivot table in rtf templateHow to get count in pivot table in rtf templateLakshmiVanarasi 13 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to have a fixed table for stub before check regardless of the number of invoicesSummary: We have a business requirement to create a custom in-house check wherein the remittance table is causing the check to shift and overflow to the 2nd page. We nee…slopez 21 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP