BI Publisher
Discussion List
-
How to Query Reported Time for Specific Payroll Time Types Based on Time CategorySummary: I'm trying to query reported time entries for specific Payroll Time Types that belong to a particular Time Category — in my case, the category is called "**** T… -
OTBI – Extract Unposted General Ledger BalancesHello Team, I checked all the OTBI reports related General Ledger data and realized that there is no report to extract unposted balances. Could anyone please advise?George Mattar 3 views 0 comments 0 points Most recent by George Mattar General Ledger & Intercompany -
BI Report to extract daily rates for a specific date rangeSummary: BI Report to extract daily rates for a specific date range Content (please ensure you mask any confidential information): Hi All, I have a requirement to extrac…
-
Query to fetch the list of recommended courses again each employeeshi Team, Can anyone share a query to fetch the list of recommended courses against each employees? Thanks, Vinod -
<Line 3, Column 94>: XML-22002: (Fatal Error) Error while processing include XSL file..Summary: Hi, I have created BIP report which have main template and created one more bip report which have sub-template as I need to show the 2 layouts according to inpu…ManishaPatil 91 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Fetching Tax Lines Based on AP Distribution Lines and Ship To LocationSummary: I'm trying to determine the correct, delivered method for linking AP_INVOICE_DISTRIBUTIONS_ALL with ZX_LINES in order to retrieve tax amounts at the individual …
-
BI report for Enrollment Lifecycle details and dateCan we pull a BI report for Enrollment Lifecycle details and date(when user's status is moved from NotStarted to InProgress) from Learn course details
-
Edit template and add new column in the existing templateHi We have an existing date model with 20 columns and all are selected in the report template. I have added one more column in the DM as per requirement but am not able …
-
Child data groups XML tags are not generating in HCM Extract while email burstingSummary: We have created the HCM extract with multiple data groups with email bursting delivery option. After submitting the Extract just Parent data group tags are prin…
-
How do I create an aged report for open transfer orders in OTBISummary: I am trying to create an OTBI Analysis for Open Transfer Orders. We would like to see a count by destination, date, cost of inventory item and possibly the GL A…
-
Difference between 2 dates - BI PublisherSummary: Hello, I'm trying to get the difference between 2 dates in BIP data model. The difference should present number of days between cmp.DATE_FROM and cmp.LAST_UPDAT… -
SCM INT Process Work Order Details (ASN) Oracle to Third PartySummary: outbound integration report from Oracle to Third Party Content (please ensure you mask any confidential information): Hi Team, Need information on creating outb…
-
In Job Details need Travel Required fieldSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
SQL to fetch the Target Proficiency field in the Performance DocumentHello Experts, I am currently creating a report for Core Competencies, and I am having a hard time searching for this specific field in the performance document page Doe…Joliver Caangay 21 views 1 comment 0 points Most recent by Suman Chenumalla-Support-Oracle Performance Management
-
Issues with Decoding Large XML in adhocschedule Column for ESS Jobs inFUSION_ORA_ESS.REQUEST_HISTORYIssues with decoding large XML in the adhocschedule column for ESS jobs in FUSION_ORA_ESS.REQUEST_HISTORY. We have created a SR with Oracle. They recommended creating a …Rajesh Kumar Gunda 83 views 7 comments 5 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Send Separate Remittance Advice RTF CustomizationSummary: We have customized RTF template for sending remittance information to the Supplier. We are pulling PO number from the invoice line level along with payment info…Rajesh Kumar Gunda 11 views 1 comment 0 points Most recent by Rajesh Kumar Gunda Payables, Payments & Cash Management
-
How to add oracle cloud url in RTF templateSummary: Am trying to add login url( oracle cloud url) from ask_deployed_domains table. when we click on link it is throwing error. {COLUMN_NAME} using this in address o…
-
Need to display UTR number in supplier payment page against each payment Num from cash management.After importing MT940 into oracle fusion, The UTR number populated in additional information in cash management. Now we need to display the UTR number in invoice payment…Kolikonda 37 views 4 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management
-
Fusion table for Employee Vacation and Delegation rulesWe want to develop a custom BI Report for Employee Vacation and Delegation rules. However, we are currently facing some challenges in identifying the correct tables that…Srikanth Nakka 167 views 2 comments 0 points Most recent by Eric-Oracle Reporting and Analytics for HCM
-
OTBI report prompt to display only direct reports for Line managersSummary: We have created an OTBI report using the subject area - 'Workforce Learning - Learning Management Real time'. We have created a prompt which displays all the Em…Sovan Mishra-Oracle 570 views 10 comments 0 points Most recent by Lakshmi Neelima Gollapalli Reporting and Analytics for HCM
-
I am looking for a report to validate or find missing goals in PerformanceSummary: I am looking for a report where it has Employee number, Name, Performance Document Name, Goal Period Name, manager, and Goals Status(Has goals or No goals ) Con… -
Saved but not submitted Promotability assessment questionnaire responses from Talent assessmentWe are trying to report on 'saved but not yet submitted' Talent Assessment Manager evaluation responses, using multiple avenues but not getting intended results. Subject…
-
Hitting the standard template in the 'View Image' of AR Invoice transactions.Hi Team, The custom template for the Print Receivables Transactions job is defined, but when clicking View Image in Receivables, the report defaults to the standard temp…Nirosha Yelicherla 209 views 4 comments 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
How to translate amount into wordsSummary: (1) In Fusion BIP Report, how to translate the USD amount into English words? for example, 0.11 needs to translated as 'Zero and eleven USD'. I have tried tried…
-
Unable to show the image file from UCM server in BIP report in pdf output (in html its comming )Summary: We are storing signatures in Document of records and we need to pull these signatures in the report output which is in pdf format. Content (please ensure you ma…
-
How to Remove Blank Spaces Appearing from Hidden Conditional Tables in RTF TemplateI have an RTF template with 3 separate tables that display conditionally based on a parameter (ITEM, ASSET, WorkOrder). When one table is selected, the other two are hid…Voladri Saikiran 59 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Which exact privilege or duty role allows user to access Security dashboard?Summary: We want to give user access to below seeded reports. Currently "Application Implementation Consultant" gives that access but we cannot assign the role due to ot…