BI Publisher
Discussion List
-
TransactionDocumentExtractDm data model used for Disbursement Payment File FormatsHi Guys Does anyone know of the existence of comprehensive documentation around the set of fields that are available to be used in a new "Disbursement Payment File Forma… -
Dynamic Link in the BIP reportSummary: I have to add a dynamic link to the BIP report that would redirect to the absence transaction. Is there a possibility to do this? Content (please ensure you mas…Parul00777777 11 views 4 comments 0 points Most recent by Jehosheba Amruthaluri Reporting and Analytics for ERP
-
How to Schedule a BI Publisher Report with Dynamic time range in parameter Valueshttps://us.v-cdn.net/6034893/uploads/WA7NWICLO5VU/sr3-37375542081.docx Issue Description: We need to view the BIP Reports -'Execution History by User' and 'BIP Reports E…Rajesh Kumar Gunda 152 views 26 comments 6 points Most recent by Kevin M-Oracle Payables, Payments & Cash Management
-
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… -
Need a query to fetch the status of Manage Negotiations pageContent Hello, Can someone please tell me a table to fetch the status of the negotiation on the Manage Negotiations page. Please find the attached image with the require…Sushan Peiris 2.4K views 8 comments 4 points Most recent by Siddarth G L Reporting and Analytics for SCM -
In an rtf template the single cell containing image is stretching to next pageSummary: In an rtf template, the single cell containing image is stretching to next page as it is not having any image to display. Whenever , the xml is generating image…
-
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?
-
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 62 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Oracle criteria to identify BIP reports with specific column in itHi All, We are migrating to V3 Seniority Date from V1 Seniority dates. This migration is impacting our BIP reports which are using ‘ORIGINAL_DATE_OF_HIRE’ column from 'P… -
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 …
-
How to process 1099 DIV, 1099 INT, 1099 K and 1099 S from Oracle FusionSummary: How can we process 1099 DIV, 1099 INT, 1099 K and 1099 S forms from oracle fusion? Content (please ensure you mask any confidential information): Version (inclu…Pranav7607 405 views 10 comments 2 points Most recent by Krishna Kanth Kommuru Payables, Payments & Cash Management
-
YTD Depreciation is not showing correct value in Fixed AssetsHi I am using below tables in my query and i am pulling YTD Depreciation from Fa_Deprn_detail table. it is not pulling the record which has deprn_source_code='B' from th…
-
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 22 views 1 comment 0 points Most recent by Suman Chenumalla-Support-Oracle Performance Management
-
Deep Link for payment view in oracle fusionSummary: Please provide the deep Link for payment view in oracle fusion. Content (please ensure you mask any confidential information): Version (include the version you …User_B1ZBU 1 view 2 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash 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 81 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 31 views 4 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management