BI Publisher
Discussion List
-
Can attachment query within bursting be updated to get attachments from OM or SMC modulesSummary: We have a business case where attachments from Order or subscription need to be sent along with invoice copies. While this is achievable by manually going and a… -
Not able to create a PO adding Header level DFF and line level DFF in that single payloadAble to create a PO in a single payload having headers, lines, schedules and distributions. However not able to create a PO adding Header level DFF and line level DFF in… -
Why the ESS job log or output file is not visible in UCM?Hi Team, I have a BIP report based - ESS Job I was able to view the log and output from scheduled process. I was able to get the UCMID, and Title of the log and output f…Sridhar Gupta Yerram-Oracle 51 views 1 comment 0 points Most recent by Sridhar Gupta Yerram-Oracle Expenses
-
Can we customize Print Receivables Transactions report Bursting query from emai To FTP/SFTP ?Summary: Client requirement is to receive AR transaction PDF to FTP location rather sending it via email so want to customize Print Receivables Transactions Bursting que…RupaliGahalot 321 views 16 comments 0 points Most recent by Ranga Swamy Ediga Reporting and Analytics for ERP
-
Need to fetch the Content ID of HCM ExtractSummary: We have requirement to fetch the Content ID of HCM Extract through BI report. Any one have idea how we can fetch Content Id. Content (please ensure you mask any…Alpesh Sanghvi 3 views 0 comments 0 points Started by Alpesh Sanghvi Reporting and Analytics for HCM
-
Table for Time Type in TimecardWe have a requirement to fetch the time type from timecard. pay_payroll_time_type from hwm_tm_rep_m_ptt_atrbs_v is not returning any value. Could someone guide me on thi…
-
Format Payment File -ORA-64451: Conversion of special character to escaped character failed error?Summary: Hello, has anyone received the error above when attempting to run Format Payment Files? If so, have you developed approaches to either proactively prevent the i…
-
Table name or column name to fetch the approver name for Expense ReportsSummary: Hi Team, We have a requirement to fetch the Approver name for the pending approval expense reports as part of custom report development. Please let us know if t…
-
Looking for Table for Issue Description & Resolution in Transaction ConsoleSummary: Hi Team, I am looking for the table which store the 'Issue Description' & 'Resolution' details captures. I have tried in this table "HRC_CONSOLE_FAULT_DETAILS_V…Mohan Murali P-Oracle 291 views 13 comments 0 points Most recent by Venkat5678 Reporting and Analytics for HCM
-
Adding BIP report to OTBI dashboardSummary: I am adding BIP report to OTBI dashboard. The BIP report runs fine individually, but when I add it to a dashboard and preview the dashboard. Nothing shows up. P…
-
Need BI Report to get total Payout amounts per plan components in SalesSummary: Hi Experts, We are looking for BI Report to get total Payout amounts per plan components, the sum needs to group by based on Plan Name , Component Name, Perform…Rama123-Oracle 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
customize standard reportSummary: Hello everyone, Can you tell me how I can find out which standard report is associated with this view in the purchasing module > purchase requisitions? I've tri… -
BIP Output file is not moving to FTP ServerSummary: BIP Output file is not moving to FTP Server Content (please ensure you mask any confidential information): Hi Team, Greetings! We have observed that the file SF…Parag Hiremath 101 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to dynamic format currency amounts in an RTF template (ref. Doc ID 1588933.1)?Summary: Hello, I have the following challenge that we need to format certain currency fields in an RTF (invoice) template regarding certain conditions WITHIN the templa…Frank.Steinjan 71 views 6 comments 1 point Most recent by Frank.Steinjan Reporting and Analytics for ERP
-
PVO that has attribute columns in per_location_details_fSummary: We are on FDI 25.2—looking for a PVO which has the attribute columns in the per_location_details_f table in Fusion. Content (please ensure you mask any confiden…
-
Does Interactive Budget Control Analysis Report has a dependency on the ORA_BUDGET_MANAGER_JOB?We have copied seeded Budget Control Analysis Report under custom folder due to client's requirement and have created a custom budget manager role. We have just copied t…
-
Is there any table available where we can get status of email sent via burstingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Aditi Agrawal2650 31 views 5 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
'Time type' field column mapping from which table to fetch itSummary: Hi All, We are creating one report to get the employee overtime unpaid overtime details. we are looking for 'Time type' field column mapping from which table to…
-
How to add dependent Parameter in Custom ESS job setSummary: Content (please ensure you mask any confidential information): Hi, We have created a custom ESS Job set which has three jobs in serial: FA Exception Report (Job…
-
Adding Attachments to Extensible Work Order Traveler ReportSummary: We have a requirement to customize the Work Order Traveler report and hence were thinking we can use the 'Extensible Work Order Traveler Report'. But when we tr…Deepthi Suravaram 161 views 20 comments 0 points Most recent by Sumit Patil Reporting and Analytics for SCM
-
Time card details query in Fusion OTLSummary: Hi All, We are creating one report to get the Time card details. we are looking for 'Time type' and 'Override dept costing' fields. We couldn't able to find the…Sai Krishna Chelikani 4.9K views 7 comments 0 points Most recent by Sri N Reporting and Analytics for HCM
-
Help on Defining the LOV in BIP Excel TemplateHi Team, We have requirement to define a Person Name List of value in BIP excel template . Report will be run by Manager. Based on manager scope list of person Name need… -
Is there a query that returns all valid grades ever associated with a position with eff datesWe found an issue on Positions where Valid Grades, previously deleted via HDL, are returning as a valid grade in the UI when any change is made on the Position itself. W…desirae_coleman 15 views 0 comments 0 points Started by desirae_coleman Reporting and Analytics for HCM
-
Historic values for pay_bank_accounts tableSummary: Historic values for pay_bank_accounts table Content (please ensure you mask any confidential information): This table has MASKED_IBAN field but when I change it…Stefano_Mazzocca 11 views 0 comments 0 points Started by Stefano_Mazzocca Reporting and Analytics for HCM -
PDF and doc / docx document types not supported as attachments to Expense ReportsSummary The expense report printed from the system using “Print Preview with Attachments” shows blank pages in place of the so called “unsupported” attachment formats (P…
-
Custom BIP report for Accounts payable trial balanceSummary: I am developing a Custom BIP report for Accounts payable trial balance. Here the paramters are legal entity, as on date and business unit. When I am trying to p…
-
How can we query the error message in BI Server's Report Job History?Summary: Error Log Report that will display the error message like in the Report Job History Content (required): Hi, We wanted to create a custom report that will output…Kristelle 406 views 16 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Is there any SQL to help me identify missing Associations in a Taxable Benefits Calculation CardHi, We have started Payrolling Benefits this tax year and have identified an issue where a Calculation Component, along with the Calculation Component Details have been …
-
Identification of missing associations on Calculation CardsSummary: Identification of missing associations on Calculation Cards Content (required): Hello Experts, Can you please suggest if Identification of missing associations …