BI Publisher
Discussion List
-
BIP report Pivot filter not functioning as expectedSummary: Running an online layout for a pivot date from a data model doesn't properly filter null dates Content (please ensure you mask any confidential information): Fo…Marko Puskac 11 views 2 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP -
bip report to get the approval history and status and also future approversSummary: Hi Experts bip report to get the approval history and status and also future approvers if the task is in progress. Any sample report sql query can you please sh…MudshaikhMub 21 views 5 comments 0 points Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP
-
Extracting from tag using substring and instringMorning all My tag has in the xml has this: I need to extract segment1 which is ST2, segment2 which is A007 and segment3 which is 2147 but into separate columns in my bi…
-
How to track email delivery status for the emails (invoice, dunning) sent to customers?Summary: Oracle Fusion Accounts Receivable (AR) sends high volumes of customer emails daily, such as Invoices, Customer Statements, and Dunning Letters. However, there i…
-
Need to display employee records transferred from Payroll to GLContent Hi All, We transferred the data from Payroll to GL. Now we need to display those records either in OTBI/BIP. Can you suggest do we have any subject area/BIP tabl…
-
[nQSError: 60009] The user request exceeded the maximum query governing execution time.Hi All, We have an OTBI report ,with "payroll-Element Entries history real time" subject area, when user run the report with date parameter they get the following error.…Sushant95-Oracle 161 views 3 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Query to fetch Transaction console entries along with multiple Approver detailsSummary: Need a Query to fetch Transaction console entries along with multiple Approver details Content (please ensure you mask any confidential information): Version (i…NagasaiM135 16 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
New FRS report is not visible for the user in the Financial Reporting CenterSummary: New FRS reports is not visible for the user in the Financial Reporting Center Content (please ensure you mask any confidential information): New FRS reports are…
-
Need a query to get latest activation Date for Supplier Site so we need to restrict a custom reportHi Team, We built a custom report for Supplier and supplier site info and we got a requirement that we need to restrict the supplier sites which got recently activated i…Sarath Lakshman 12 views 7 comments 0 points Most recent by Shyam Patel Reporting and Analytics for SCM
-
Does BIP reports support docuSign?Summary: Content (please ensure you mask any confidential information): In this discussion it seems docuSign is not supported for BIP reports. Can someone from Oracle co…Stefano_Mazzocca 1 view 0 comments 0 points Started by Stefano_Mazzocca Reporting and Analytics for HCM -
Auto Refresh InfotilesSummary: Client would like an invoice “dashboard” experience in Oracle Fusion Cloud that updates in near real time (or auto-refreshes on a set interval) without users ma…
-
Auto Refresh InfotilesSummary: Client would like an invoice “dashboard” experience in Oracle Fusion Cloud that updates in near real time (or auto-refreshes on a set interval) without users ma…
-
How to search for future approvers in an approval process in Oracle HCM Cloud by query?Good morning! How are you? I have a question, exists any VIEW objects or table (Im creating a bi publisher) that I can use to get the information of all the approvers of…
-
Are there User Entity for Individual Compensation Plan In HCM ExtractSummary: Are there User Entity for Individual Compensation Plan In HCM Extract Content (please ensure you mask any confidential information): Version (include the versio… -
Separate Remittance Advice based on custom data modelSummary: Is there a way of customising the disbursement extract associated with the Separate Remittance Advice for cloud customers. Our requirement is to add details to …Tim2021 534 views 5 comments 0 points Most recent by Sai Revanth Payables, Payments & Cash Management
-
Customizing Separate Remittance Advice Subject with dynamic valueSummary: Customizing Separate Remittance Advice Subject Content (please ensure you mask any confidential information): Hi Team we should customize the subject with PAYEE…Luca Nobili PWC 241 views 6 comments 1 point Most recent by Luca Nobili PWC Payables, Payments & Cash Management
-
why is there no EVENT_ID in FA_DEPRN_DETAIL for certain assets for depreciations?Summary: For certain assets, which have depreciation reserve balance and the account as shown in view accounting in Asset Inquiry screen. The Same asset, does not have E…
-
Sending of analysis to managers via agentsSummary Sending of analysis to managers via agentsContent Hi - We have set up a number of Analysis which are currently being sent to different business units / locations…Roy Paolo Paunlagui 74 views 10 comments 0 points Most recent by Vivek Balchandani Reporting and Analytics for HCM
-
BIP report to get the approval status with history and attachments for Leave encashment, salary trasSummary: Hi Experts Could you please help me with the BIP report sql query on how to get the approval status for DOR requests like Leave encashment, salary transfer lett…
-
How to get Branding Image URL for Course created in Oracle Fusion HCMHello Everyone, We are developing a custom report to list courses, and one of the requirements is to display or extract the URL of the uploaded branding image for each c…Sammeta Srividya 1 view 3 comments 0 points Most recent by ShahzaibShaukat Reporting and Analytics for ERP
-
Query to fetch "Issue Description" and "Resolution" for failed transactions.We had a requirement to display issue description and resolution for failed transaction. When we use table hrc_console_fault_details_vl hcfdv(for description and resolut…Nalsoft Pvt Ltd 13 views 2 comments 0 points Most recent by Nalsoft Pvt Ltd Reporting and Analytics for HCM
-
How to burst and deliver a single CSV file to SFTP when no column has a common value for all recordsHi team, I am working on an Oracle HCM Cloud BI Publisher report where the requirement is to: Generate one CSV file Containing all records Deliver the file to SFTP locat…Sammeta Srividya 4 views 2 comments 0 points Most recent by Sammeta Srividya Reporting and Analytics for ERP
-
Query for Transaction Console transactionsSummary: Query for Transaction Console transactions Content (required): I am looking to write a query that contains the below information from the Transaction Console, r…
-
Query to extract attachment URL (i.e. Document of Records; Skill and Qualifications)Summary: Content (required): Hello experts, do you have a query to retrieve the attachment URL? In other words, I need to retrieve the URL for some Document of Records a…Valerio Curzi 1.5K views 11 comments 0 points Most recent by ValentinaG-Oracle Reporting and Analytics for HCM -
Page Customization: Pop up message on clicking Create ItemSummary: Customer have requirement to customize Clicking the Create Item “+” button in the Oracle Expenses module it should display a pop-up with cancel and OK options w…Manjusha ERP Tech09-Oracle 1 view 3 comments 0 points Most recent by Manjusha ERP Tech09-Oracle Expenses
-
Regarding - Alerts Failure during Bulk LoadSummary: We have implemented multiple custom BI Publisher–based alerts that are triggered on specific business scenarios and scoped to particular Business Units. During …
-
Can we add parameters to the Standard ESS Job "Print Commercial Invoice Report"Summary: Hi Team, Business needs a parameter on the report which allow them to change the Title of the Proforma Invoice based on user selection like parameter Document T…
-
how to translate the AR Invoice Line Description to French in BIP Reports in BIP ReportsSummary: The customer has a business requirement to translate the AR Invoice Line Description into French for their reports. Language should be picked dynamically based …ramesh.daniyala.mcd 11 views 0 comments 0 points Started by ramesh.daniyala.mcd Receivables & Collections
-
ORA-01427: single-row subquery returns more than one row ERRORSummary: Have a Payroll Config workbook and returning error. We can't seem to identify the issue. it exists in one of the 3 attached data sets. https://us.v-cdn.net/6034…