BI Publisher
Discussion List
-
Date parameter is throwing an errorSummary: A date value is stored in the screen_entry_value field. I created two date parameters (p_week_start, p_week_end). I am trying to use the screen_entry_value in m…Consultant Ian 41 views 7 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
What would cause a journal batch to go from STATUS_VERIFIED='Y' to STATUS_VERIFIED='N'Hi Guys We have a BIP report based on journal batches/headers/lines developed by an outside consultancy that has the filter below on it: GJB.STATUS_VERIFIED='Y' All good… -
REST API to extract database tableSummary: Hi Community, I’m exploring if REST APIs can be used to fetch all data from a table, similar to query like SELECT * FROM PO_HEADERS_ALL I came across that REST …
-
New Saudi Symbol CurrencySummary: Add new Saudi Riyal Symbol Content (please ensure you mask any confidential information): Saudi Arabia is starting to use a new symbol for the currency SAR, how…Mostafa AboElhassan 203 views 5 comments 0 points Most recent by Rami Kalasli Reporting and Analytics for ERP
-
packages for extending attributesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Raj Koppanathi 1 view 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Can we set up the course completion certificate, for specific courses .Summary: Can we set up the course completion certificate in a way where, the employee is awarded the certificate for specific courses . Content (please ensure you mask a…
-
How to auto-increment the accounting period on Trial balance report in BIPSummary: We have General Ledger Trial Balance in BIP and every month, end user needs to change the accounting period. Is there a way to auto-increment the accounting per…TBIRD1 11 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Unable to pull unencrypted bank account details through view iby_ext_bank_accounts_vWe need to share the unencrypted unmasked Bank Account data of certain suppliers. But when we use the View IBY_EXT_BANK_ACCOUNTS_V to get the CLEAR_BANK_ACCOUNT_NUMBER f…AbdulBasith 132 views 3 comments 0 points Most recent by Srinivas Nimmalapudi-Oracle Payables, Payments & Cash Management
-
Facing issue in RTF template(This exists with maximum width.)Summary: Trying to add two new extra fields in the existing RTF template is giving an error. (Error: This exceeds the maximum width.) Content (please ensure you mask any…Gunal Baskar 891 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Need help SQL to pull Previous work schedules and present Work schedules of employeesSummary: I am currently working on a project that requires retrieving both the previous and current work schedules for employees from our database. I would appreciate yo…
-
make etext template Tab delimitedSummary I need to make a report tab delimited, however I cannot seem to accomplish with etext template.Content I found this, but can't seem to apply it. I guess I am not…
-
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 185 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 51 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 8K 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 395 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