BI Publisher
Discussion List
-
CertificatesSummary: How to create own certificates in Oracle Learning Cloud and tie them with course outcomes? Content (please ensure you mask any confidential information): We hav… -
Virus scanner not reachable error when unarchive reportSummary: Virus scanner not reachable error when unarchive report Content (please ensure you mask any confidential information): My Client Groups > Reports and Analytics …Junade_Shujaat 114 views 2 comments 0 points Most recent by Junade_Shujaat Reporting and Analytics for HCM -
How to handle null values while Summing in RTF TemplateSummary How to handle null values while Summing in RTF TemplateContent Hi Team, Please advise with syntax for to handle null values while Summing values in RTF Template …User_2025-01-29-00-33-34-534 1.1K views 4 comments 0 points Most recent by User_NPE6A Reporting and Analytics for HCM -
How to get Request Id for Import Journals ESS Job using ImportBulkData Operation using REST API?I am invoking the importBulkData(Operation) REST API to run the Import Journals job for loading journal FBDI files. While I can retrieve the Request Id of the "Load Inte…Srinath Anbarasu 453 views 5 comments 0 points Most recent by Raluca Chivu-Oracle General Ledger & Intercompany
-
Purchase Order PDF report issueHi Team, We have customization in Purchase Order PDF report by adding customer logo and also setup the confirmation in configure procurement Functional business unit tas…Chanikya Neelam-Oracle 11 views 6 comments 0 points Most recent by Chanikya Neelam-Oracle Reporting and Analytics for ERP
-
Separate Remittance Advice sent as Email - formatting of email bodySummary: How can I generate the SRA in email with the formatting in place? Content (required): We have created a custom Separate Remittance Advice (SRA) format. When the…Niall McColl 143 views 3 comments 0 points Most recent by Bhawna Payables, Payments & Cash Management -
how to enable emailing for T4 Year End Report for canadahas anyone done this before, can you please share the steps ? We tried doing it in a similar fashion like Payslip emailing but incase of T4 the custom report never gets …
-
Customer registration number is not display in printed INVSummary: Customer registration number is not display in printed INV Content (please ensure you mask any confidential information): In the previous month, the "CUST_TAX_R…
-
How to Reset the BICC Extract To last run Date via APISummary: Hi Team, we have requirement to reset to the BICC extract to last run date based on any failures. Can some one please let me know if this is possible via any AP…
-
For the customized Print receivable transaction report, the ess job fails with errorSummary: As part of the Run , our Print Receivable Transaction Report job is failing and the ESS log message provides us the below error message AR_ESS_PLSQL_WRAPPER_PKG…
-
Required Table or SQL query to get Criteria under Manage Statement Groups in Workforce compensationSummary: Hi, We are stuck to get the details for Criteria details under Manage Statement Groups in Workforce compensation plan in Compensation Module. Please help us to …Opkey PA 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BI publisher: EText Condition Fails with Slanted Apostrophe in XML TagsSummary: I'm encountering an issue where my EText template condition does not work as expected due to a mismatch between straight single quote and slanted apostrophe in …Sudeepto 24 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Project Comments in query output FormattingSummary: User created a comment on Project level (might have been copy pasted from some other source), when a sql is written to extract the information, it has all sorts…
-
Looking for a Custom Audit report showing old and new valuesClient is looking for a custom audit report build through BI which shows the old and new values.Meenakshi K 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiSummary Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiple tabsContent Hi Experts, I have a problem. There is a BI R…Aloka Bhattacharya 2.1K views 26 comments 1 point Most recent by User_C767R Reporting and Analytics for HCM -
Trial Balance Report data model errorHi, I'm trying to customize 'Trial Balance Report'. When I run TrialBalanceDm with relevant parameters, its throwing below error. ORA-20101: ORA-06512: at "FUSION.GL_TRI…Manavalan 304 views 5 comments 0 points Most recent by Lasantha Ranjana Bandara Payables, Payments & Cash Management
-
How can I edit parameter in standard ESS job?Summary: I want to edit (hide/remove/default to a specific value) the parameters of a standard ESS job. Please share steps to do it Content (required): Version (include …Priyal Pareek 716 views 3 comments 0 points Most recent by Sameer_Jain Reporting and Analytics for ERP
-
Mass addition approval notification is not showing details of assets in the groupSummary: We are uploading multiple assets with ADFDi. When the approver is getting the approval notification part of mass approval, he is able to see only the total amou…
-
Transaction being created while BIP report is runningSummary: We have created a custom BIP, the report takes 15 minutes to completed, while the report is running the users create additional transactions which were not ther…
-
how to create subtotals in excell template for bipI had a requirement to create subtotals for each individual invoice_numbers , when i try to do sum function or subtotal selection it is not giving subtotal for each indi…Voladri Saikiran 31 views 0 comments 0 points Started by Voladri Saikiran Reporting and Analytics for ERP
-
How to get current timezone as of date in server variable CURRENT_DATE_REP_OTBISummary: How to get current time zone as of date in server variable CURRENT_DATE_REP_OTBI. I am trying to get the correct metrics on the headcount dashboard and what i o…Revanth.Rondla 21 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL query or Table for Dynamic Columns data under Configure Assignment Segments in CompensationSummary: Hi, We could not find the tables name or query for Dynamic Columns data under Configure Assignment Segments in Worforce Compensation plan What is the table name…Opkey PA 22 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Feasibility of Daily Trial Balance ReportOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): ADCORP Description (Required): We hav…Muralidhar.Gandrakota-Oracle 11 views 0 comments 1 point Started by Muralidhar.Gandrakota-Oracle Receivables & Collections
-
fbdi "CustomerImport" for adding sites to an existing customerWe need to use the FBDI to add some sites to an existing customer, how can we use the CustomerImport for that requirement?
-
Unable to Retrieve Qualified Entitlements Plan Details Using OTBISummary: Unable to Retrieve Qualified Entitlements Plan Details Using OTBI Content (please ensure you mask any confidential information): Hi Experts, We have a requireme…Vasanthakumar Ravi 11 views 0 comments 0 points Started by Vasanthakumar Ravi Reporting and Analytics for HCM -
How to suppress credit memo for print email but Invoices should be allowed?Summary: Content (please ensure you mask any confidential information): We need an ability where Credit memo should be suppressed/restricted for print email to the custo…
-
What table contains the AP invoice source distribution transaction line number details?I'm trying to build a BIP report that contains the AP invoice source distribution transaction line number details, as shown in the screenshot below. What BIP table conta…
-
After 25A, customers whose profile is set to XML invoice delivery method are not searchableSince 25A, we can’t search for customers in the From/To Customer fields of custom ESS jobs, even though we use the same CustomerAccountVO and CustomerVVO LOVs as the see…
-
Reporting on Payment ApprovalsSummary BI Publisher or OTBI Report to extract Payment ApprovalsContent Hi Community Are there are any BI Publisher or OTBI Reports available to report on Payment Approv…Kunal Daya-175386 199 views 5 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
BIP検索条件についてSummary: Could you please tell me how to specify multiple search conditions for BIP? Content (please ensure you mask any confidential information): In the search screen …