BI Publisher
Discussion List
-
payeach invoice alone(Procurement-supplier-profiledetail-py-pa-ps column will stores in which tableSummary: we have this column in poz_supplier_sites_v(pay_site_flag) tables but it is not reflecting accurately can you please suggest us in this case Content (please ens… -
Are there any prebuilt, out-of-the-box dashboards available in Oracle Learning?Please confirm whether Oracle Learning provides any prebuilt, out-of-the-box dashboards? If available, could you share details about the standard dashboards and the key … -
While creating Value set on oracle fusion getting error.The value column is not valid. (FND-2806)Summary: The value column is not valid. (FND-2806) In value set TID_Grade_Value, value column LISTAGG(distinct(prv.value), '; ') WITHIN GROUP(order by prv.value ) "UPGRA…Ashutosh12 1.7K views 6 comments 0 points Most recent by Raghavendra M Reporting and Analytics for HCM -
Reporting Options for Fusion Accounting HubSummary: We have two large custom sub ledgers defined via Fusion Accounting Hub. At the moment we rely on BI Publisher Reports to extract the data on balances and transa… -
Is there a field in otbi for the total invoiced amount against a POSummary: When trying to create an analysis in OTBI for Purchase orders, the Invoiced Amount field just brings back the total invoiced value for ALL invoices, not just th… -
How to use another method of authentication for HTTP Connection in BI AdministrationSummary: We have currently setup an HTTP connection with Basic authentication. But Client is not convenient using Basic auth for REST API call to OIC. OAuth was not an o…Abhilash K - Deloitte USI 21 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Where does the payment acknowledgement email come from and how to customize it?Summary: We recently set up a payment acknowledgment with the bank and have the payment file register with document detail email once the disbursement and acknowledgment…Nikki Reich 24 views 6 comments 0 points Most recent by Nikki Reich Payables, Payments & Cash Management -
How to customized Create Customer Statement Report?I need help in customizing Customer Statement Report. How to create custom ESS job? -
Requirement to update KSeF Collective Payment identifier for Poland. Any API to update payments DFFSummary: We are implementing new requirement of Poland i.e., to store payment identifier at payment level DFF. We have agreed on the below process: 1. AP team creates an…Kesanapalli Maneesha 20 views 0 comments 0 points Started by Kesanapalli Maneesha Payables, Payments & Cash Management -
Front end validations for mandatory fields in ADFDI spreadsheetSummary: ADFDI spreadsheet currently does not perform front end validation for mandatory fields, including descriptive Flexfields marked as required, Validation for mand…Krupa 29 views 3 comments 0 points Most recent by Shaun L-Oracle Payables, Payments & Cash Management -
OTBI send ouput by email as attachmentSummary: On 26C. We developed a custom report and like to schedule it to run and receive the output as an attachment in an email However, I'm not getting any email. Is t…Simon L 8 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Issue with Additional Columns in Disbursement Payment Process Request Status Report FormatsSummary: Hi All, We are facing an issue while customizing the “Disbursement Payment Process Request Status Report Formats” report. We have added some additional columns …Karthikeyan s-Oracle 70 views 7 comments 0 points Most recent by AnkitaSabu Payables, Payments & Cash Management -
RTF Template with the excel output format generating null rows in each excel sheetWe have created a report with RTF template and set the output format to Excel. The excel output has multiple sheets, but there is an empty row in all the excel sheet. We…Minu Priya R 24 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Redwood: Purchase Document E-mail ReportSummary: Redwood: Purchase Document E-mail Report Content (please ensure you mask any confidential information): Hi Team, We are getting new feature in 25D :Redwood: Use…Nidhi Chhajed 34 views 4 comments 0 points Most recent by Nidhi Chhajed Reporting and Analytics for SCM -
Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiSummary Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiple tabsContent Hi Experts, I have a problem. There is a BI R…Aloka Bhattacharya 2.4K views 37 comments 2 points Most recent by Dominique Reporting and Analytics for HCM -
ORA_ELEARNING type: course or offer?Summary: Content (please ensure you mask any confidential information): I create a course and an offer, both of type ORA_ELEARNING. How to tell if these 2 learning items…Stefano_Mazzocca 62 views 8 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Template: BI Publisher Report: Payment Request Import example ?Summary: Template: BI Publisher Report: Payment Request Import example ? Content (please ensure you mask any confidential information): Hello I need to do a mapping to b…martingabriel Kinovisques 15 views 1 comment 0 points Most recent by Devesh Tyagi Payables, Payments & Cash Management -
primary address querySummary: Content (please ensure you mask any confidential information): Is it possible to tell when an address is set as primary? I see both PER_ADDRESSES_F and per_pers…Stefano_Mazzocca 26 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
No certificate lov is appearing while creating any learning item as adminSummary: No certificate option is appearing to select while creating any learning item as admin. However, under Path: shared folder>Human capital management>Learning>Cer… -
Query to get the user login time for last 365 days in fusion HCM ApplicationSummary: we are trying to find out the login timings of a Common user, we use this user for scheduling purposes, need a query to fetch the login timings of this user. Co…Kiran Kumar Alle 39 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Parameters not visible to other users for custom ESS Job in Oracle Cloud FusionHello Team, I have created a custom ESS job in Oracle Cloud Fusion. When I access the job, both the ESS job itself and all of its parameters are visible and functioning … -
BICC Extract Failures with "Error occurs while calling remote service ADFService11G" after 26CUpdateSummary: We have been experiencing intermittent failures with several BICC extracts following the Oracle Fusion Cloud Applications 26C update. The failures started appea… -
Career Site | Reporting on Candidate Consent and Behavioral Data for Non-Essential CookiesHi team! We are currently implementing ORC for a client and we are working on the configuration of the career site cookie consent management. Non-essential cookies on th… -
Putting a user defined validation to check if supplier email remittance is blank in Manage FormatSummary: We have enabled a H2H connection with SCB bank of ISO payment file format. One of the mandatory fields is the supplier email address for remittance purposes. Th…Napat Bhumina M 16 views 1 comment 0 points Most recent by Shiv.Singhal Payables, Payments & Cash Management -
Customize Bill of Lading Report and Packing List ReportSummary: Hello. Has anyone here experienced customizing Bill of Lading Report and Packing List Report to add more fields? How do you get the XML for these two reports an… -
Custom Disbursement Payment File Format Not Appearing in 'Manage Format' SetupDear All, I have successfully customized the Disbursement Payment File Format report: I also added two custom templates: However, nothing appears in the 'Manage Format' …George Mattar 348 views 10 comments 0 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management