BI Publisher
Discussion List
-
SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMSSummary: Hi TTeam, Could you please help us on this below SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMS in Specify Cash Positioning and Forecasting …Opkey PA 11 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Reporting and Analytics for ERP -
Payment File formatSummary: Payment File format Content (required): Hi All, We got a requirement from the bank to modify the Payment file format . Currently the format is, R|DEBIT_ACCOUNT_…Venkatesan 31 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Custom Data Model Not Reflecting in Payment File – Fix?Summary: Context: We have set up a transmission configuration to transmit files to an SFTP server. Additionally, we have: Created a Data Model to extract the required fi…Sandeep cheerla 1 view 2 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
BIP Report to list all Custom ReportsSummary BIP Report to list all Custom Reports.Content Ho to fetch list of all custom reports from cloud instance (Oracle Cloud SaaS). I know how to fetch them from BIP A…Amarnath 2.4K views 9 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
SQL query to retrieve employee location country nameSummary: Content (please ensure you mask any confidential information): Hello experts, we need a query to retrieve the employee location country name but below it extrac…Valerio Curzi 633 views 1 comment 0 points Most recent by Vishnu Vardhan Raju Reporting and Analytics for HCM -
SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMSSummary: Hi TTeam, Could you please help us on this below SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMS in Specify Cash Positioning and Forecasting …Opkey PA 11 views 3 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Unable to find validation status in AP_INVOICES_ALLWe are creating a custom report and we need to give invoice validation status as a parameter. I am not able to find anything with validation status. Need some help on it…KabirB 31 views 4 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
How to populate issued by in course completion certificateSummary: We have a seeded report called course completion certificate. Here there is a rtf which contains a field called Issue By field to indicate who is the certificat…
-
We are trying to customise the Standard Receivables Aging by General Ledger Account reportSummary: We are trying to customise the Standard Receivables Aging by General Ledger Account report and from the seeded output, we see that the accounted amounts has bee…
-
XML-22002: (Fatal Error) Error while processing include XSL fileSummary: We are getting the error XML-22002: (Fatal Error) Error while processing include XSL file (xdoxsl:///Custom/Human Capital Management/HR/SUBTEMP.xsb?loc= en-GB) …
-
HCM Position extract from EPBCS not generating records in HCM view extractWe have downloaded the HCM extract from EPBCS and uploaded the extracts to HCM. When we run data extract for Position in HCM, there is no data being generated in HCM. We…
-
Big performance difference between the query in BIP data model and the pure querySummary: The issue below has been observed Performance of a custom BIP started to be extremly degraded post to the upgrade. The BIP used to run in a second, but it start…Sunghpark 31 views 3 comments 0 points Most recent by Akash Katiyar-Oracle Reporting and Analytics for ERP
-
Beginning Balances for a few Entities (Segment1 from GL) is not there in FA_BALANCES_EXTRACT TableBeginning Balances for a few Entities (Segment1 from GL_CODE_COMBINATIONS) is not there in FA_BALANCES_EXTRACT Table when we filter on basis on those entities we aren't …
-
Extra space at the top of the page : RTF TemplateSummary: Having a strange issue with PDF generated form RTF Template. The RTF template has a header. The PDF output when generated has a blank space at the top of the he…Arun Raj 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
BIP report link errors unless "Create Search Index" runs—need guidance on recurring schedule.Summary: Hi Team, We have build a BI Publisher (BIP) report that sends an email to the line manager containing the same observation checklist link that appears in the re… -
Number field not displaying correctly on RTFSummary: I have a RTF created with the BI Publisher Add-in and is sent as a PDF email notification through a bursted BIP report. There is a number field on the RTF, that…
-
Procure-to-Pay RT subject area - approver nameSummary Procure-to-Pay RT subject area - approver nameContent I am attempting to update my existing P-to-P reports to leverage the P-to-P RT subject area; this subject a… -
How to Encrypt and Send BIP report output from oracle HCM cloudSummary: There is a need to Encrypt a BIP report output to 3rd party through SFTP. Please let us know the possibility and how to accomplish it ? Does BIP provide any def…
-
How to zip multiple output files from HCM Extract and FTP to third partySummary: How to zip multiple output files from HCM Extract and FTP to third party Content (please ensure you mask any confidential information): We have a requirement to…
-
SQL query to create list of values for past 24 monthsSummary: I've been searching and attempting to create a List of Values to be used in a Data Model for a report to make the parameter selection dynamic year over year ins… -
Query to get Fusion Workflow ApprovalsHello, Is there a query where i can get all pending approvers for a transaction, not only the current assignee? I was able to identify the current assignee using the bel…Osama_Mo 3.2K views 10 comments 1 point Most recent by Ruma Bhatnagar-Oracle Reporting and Analytics for HCM
-
Connect to PaaS db from BIP to create report from custom tables created in PaaSSummary: Connect to PaaS db from BIP to create report from custom tables created in PaaS Content (please ensure you mask any confidential information): We have a require…Jepson Erattuparmbil 66 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
BIP report to extract all JR approval flow stepsSummary: BIP report to extract all JR approval flow steps Content (please ensure you mask any confidential information): Hello experts, my customer requirement is to ext…
-
How to pass system date in subject line of email notification when scheduling an Ess jobSummary: I am scheduling ESS job set, our requirement is to print system date in email notification subject line and attachment name. How to configure dynamic date (Sysd…VasanthaFusion90 41 views 1 comment 0 points Most recent by VasanthaFusion90 Reporting and Analytics for ERP
-
Feasibility of Sending Observation Checklist Link via Email from BIPSummary: Hi Team, We have created an observation checklist activity within a blended offering. This checklist is triggered to the learner's line manager, and the line ma…
-
Extract future task assignment in transaction approval flowHello experts, I know that we have the ability to query current and past approvers for an approval transaction (hrc_txn_data / fa_fusion_soainfra.WFTASK), but is there a…
-
ReportService API appears to be deprecated or marked as obsolete in the April 25B update.Summary: As part of the April 25B Patch activity, we noticed that the ReportService API (/xmlpserver/services/v2/ReportService?wsdl) deprecated or obsolete?. Could you p…Chaitanya2324 111 views 2 comments 1 point Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP
-
Add custom font to OTBI reportsSummary Can we add custom fonts to OTBI reports?Content I did upload a ttf file and created font mapping in Administration page but the font is not reflected in the OTBI… -
Report that can extract information about the user's active tasksIs there a report that can extract information about the user's active tasks, which are displayed in the task area of each module? A report on the privileges assigned to…
-
OOTB Subject Area and Custom Subject Area crossedIf OOTB Subject Area and Custom Subject Area have crossed, Is there any support to see if this can be done?M.AZUMA 21 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales