BI Publisher
Discussion List
-
The value of the attribute Bank Name isn't valid.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Pazhanivel 67 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Need the exact table in Fusion for the column "STAGE" in the Manage Payment Process Requests screenHi Everyone's I am having difficulty finding the 'Stage' column in the Fusion tables under the navigation: Payables → Payments → Manage Payment Process Requests → Stage …lkarthik-Oracle 35 views 3 comments 0 points Most recent by Purvi -Oracle Payables, Payments & Cash Management -
How to get IDR details for a Payable invoiceSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nepal Bhumireddy 17 views 3 comments 0 points Most recent by Nepal Bhumireddy Payables, Payments & Cash Management
-
How to JOIN AP_CHECKS_ALL table with per_all_people_f or per_all_assignments_m table in Oracle HCM ?Summary: Hi All, I was preparing a report which required all the check payment of US employee. In order to complete this I have to join a table which contains the check …abhjkum-Oracle 75 views 1 comment 0 points Most recent by Kishore S Payables, Payments & Cash Management
-
Setup required to transmit Positive Pay File for payments/checks created via Quick PaymentSummary: Could someone please provide assistance on how to transmit a Positive Pay file to our bank's SFTP if the check payment is made via Quick Payment? Content (pleas…Christian Roxas 167 views 6 comments 0 points Most recent by Christian Roxas Payables, Payments & Cash Management -
How to make 'Routing Attribute 2' field a drop down instead of a free text in the invoice header?Summary: We want to make 'Routing Attribute 2' field a drop down instead of a free text in the invoice header since our invoice approvals are based on this field and mos…AkashAgarwal 36 views 2 comments 0 points Most recent by Harsh Masharu Payables, Payments & Cash Management
-
How can I find AP invoice Accounted by for my custom BI report?Please help with the queryAditi Agrawal2650 18 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Invoice Document RecognitionSummary: When we run the schedule process - Invoice Document Recognition , we just want one column i.e subject. Is there any way or any report available which I can use …Sujatha Kumari 47 views 6 comments 0 points Most recent by Sujatha Kumari Payables, Payments & Cash Management
-
How to import a data from Oracle cloud to OTBISummary: Hi, we try to create a analysis in OTBI using a Payables Invoices - Installments Real Time Subject area, but we didn't get the any results, In ERP we have roles…Alex Pagliarini - Ninecon 15 views 1 comment 0 points Most recent by Abi Osborn Payables, Payments & Cash Management -
sql to use in custom BIP report to restrict data dynamically based on the users data security&accessWe are trying to build an custom BIP report/sql script to restrict data dynamically based on the users roles and their data access in fusion (for example, to query AP in…daniel4u2uk 577 views 11 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Show the postal 4 zip code on AP checkWe need to show the postal 4 zip code (postal code extension) in our AP check template, but the xml is not showing the field (Select document From iby_trxn_documents ord…Alvaro Artavia 44 views 3 comments 2 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Withholding Tax for Offest TaxSummary: Need to apply Withholding Tax on AP Invoice that has a Tax Rate + Offest Tax Rate (Gross Amount = Net Amount). System doesn't consider the offset tax rate for w…
-
Cheque specimen signature to be updatedSummary: Need to update the cheque specimen from one person to other. As the last day is August 29th; the next payment run is scheduled for September 5th so the cheque s…Gifty V 19 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
Audit Receipt Accrual Clearing Balances ReportIn receipt accounting you have this report that can be run from the screen. I have not been able to find a way to do this without exporting the data from the screen. Is …
-
Can we customize the standard report with Internal tables provided by oracle? I found them empty.Summary: CCC-Internal tables provided by oracle do not have the data and unable to verify our customizations Content (please ensure you mask any confidential information…
-
we need a sample payment file for rtgs payment methodwe are implementing payments for customer and they want a payment file which has rtgs payment method so we need a sample payment file for rtgs payment method Thanks, Sai…Sai Divya Kolachana 11 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Static IP for sftp connectionSummary: Do you know if Oracle can use a specific IP address to transfer data to the SFTP server? We have configured a connection to the sftp server via OTBI/BI Publishe…Daniel Sobotka 33 views 1 comment 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management
-
Creation of positive pay files with bank account appending to the file nameSummary: Creation of positive pay files with bank account appending to the file name Content (please ensure you mask any confidential information): Creation of positive …Arun0130 47 views 3 comments 1 point Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
How to check the date when we enabled audit trail in Oracle ?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Has anyone has experience with updating the 1099 NEC Copy B template?We are looking to make some changes to our 1099 NEC Copy B pdf template. Does anyone has some experience editing the pdf template?Jay Ruthiran 6 views 2 comments 0 points Most recent by Jay Ruthiran Payables, Payments & Cash Management
-
SQL Query to get the AP Invoice Validation DateHi, We have a requirement to determine the Invoice validation date . Please help us to get the query for the same. We tried using creation_date of xla_events by joining …Hitha Harikumar 968 views 5 comments 0 points Most recent by Julien_Dubouis Payables, Payments & Cash Management
-
How to burst a standard report attachment run from scheduled process page to a users email?Summary: Our users spend so much time going into the system to download the files they run from the monitor/scheduled process page. We have already customized the Oracle…
-
Need a SQL Query Help To Fetch Non-PO Matched Invoice Lines (Account Payables)Summary: Our requirement is to fetch the Non-PO matched invoices, the query should even exclude Invoice lines which are associated with PO. Only Invoices without PO (at …Jayaram AnuPriya-Oracle 40 views 2 comments 0 points Most recent by Jayaram AnuPriya-Oracle Payables, Payments & Cash Management -
Sql Query to find the approver name for AP invoicesSummary: I am looking to get approver name for AP invoices Content (please ensure you mask any confidential information): Version (include the version you are using, if …Rahul K-Oracle 247 views 1 comment 0 points Most recent by Saurav Sunny Payables, Payments & Cash Management
-
PVO for tax line distributions of an invoice to load data to FAWSummary: we have a requirement to showcase tax line distributions if an invoice in a FAW report. These data is not coming to FAW from ERP through delivered pipelines. Wa…Balachandra reddy 37 views 1 comment 0 points Most recent by Daniela Petria-Oracle Reporting and Analytics for ERP
-
ISO 2022 Payment formatsSummary ISO 2022 Payment formatsContent Hello everyone, I am trying to understand how ISO 2022 payments work. How do we create those payment formats. If anybody has any …Lucky Sharma 65 views 6 comments 0 points Most recent by Lucky Sharma Payables, Payments & Cash Management -
Table Name for Approver's Data of BPM Worklist along with History of Approver'sSummary: Issue : Table Name for Approver's Data of BPM Worklist along with History of Approver's for a Person whose Task are Completed Now We want Table Name's for Appro…Roy Aniket 63 views 1 comment 0 points Most recent by Rama Mohan - Support-Oracle Payables, Payments & Cash Management
-
Different Bank Branch Number and Bank Alternate Branch Name in a single ISO20022 XML FileSummary: Different Bank Branch Number and Bank Alternate Branch Name in a single ISO20022 XML File Content (please ensure you mask any confidential information): We are …Christian Roxas 26 views 2 comments 0 points Most recent by Sunghpark Payables, Payments & Cash Management
-
disable custom BIP report parameter once it's been selectedSummary: Content (please ensure you mask any confidential information): I have a custom BIP report it has parameter (list of value), say Invoice Number from AP table the…Support Team NAKAMOTO 29 views 0 comments 0 points Started by Support Team NAKAMOTO BI Publisher Learning Center