BI Publisher
Discussion List
-
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 22 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
-
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 721 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 32 views 0 comments 0 points Most recent 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 27 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 12 views 0 comments 1 point Most recent 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?
-
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 …
-
BI Publisher Service UnavailableWe are getting the message 'Service Unavailable' when attempting to access BI Publisher. All our automated reports are also impacted by this. They are not being sent.
-
Report Data is incorrect because Time zoneHello, we just recently faced an issue related to BI report on absence related data. It will give last one hour updated records of employees absences. (submitted/awaitin…Dara Nagasai 14 views 4 comments 0 points Most recent by Vanitha Kundaram Reporting and Analytics for HCM -
Invoice Payments querySummary: Create New Invoice Payments Reports Content (please ensure you mask any confidential information):I would like to create a new report in Oracle Fusion ERP to qu…RAJAGANAPATHI 187 views 0 comments 0 points Most recent by RAJAGANAPATHI Payables, Payments & Cash Management
-
Create customer statements to fetch open and closed statementsSummary: Hi, The Create Customer Statements (ESS) job currently returns both open and closed statements. Is there a supported way to run it so that it outputs only open …
-
Completion of course notification with link to completion certificate of the courseSummary: Completion of course notification with link to completion certificate of the course Content (please ensure you mask any confidential information): Hello, We hav…
-
Control report-level permissions during migrationSummary: We have a custom folder ("Folder A") with 4 roles assigned: Role A, Role B, Role C, and Role D. When a new report is migrated into this folder, it automatically…
-
Does anyone know what table does the Absence Management Type time attribute belong to?Summary: We currently have Payroll Time Type and Absence Management Type configured for the Time Entry Layout Components in our system. We already found that the HWM_TM_…
-
Send reminders to the employee based bip report burstingSummary: Send reminders to the employee based bip report bursting Content (please ensure you mask any confidential information): Hi Team, I have a requirement. I need to…
-
How to display Success Criteria Text without HTML tags from Transaction tablesSummary: How to display Success Criteria Text without HTML tags from Transaction tables We have a requirement to display the Success Criteria Text in the report as plain…