BI Publisher
Discussion List
-
Error on Payables Payment Register Data ModelSummary: Error on Payables Payment Register Data Model Content (please ensure you mask any confidential information): We have customized the seeded report/data model for… -
Payment Process Request Status Report: Supplier Bank Account not populatedSummary: Hi, In the Seeded Payment Process Request Status Report , Supplier Bank Account is not populated although the supplier bank account is present on the invoice in…Shashank Shekhar 1 view 3 comments 0 points Most recent by AvinashRN Payables, Payments & Cash Management
-
Fusion Ap Invoice Workflow TablesHello Support, We have a requirement to get and build a report of the data stored in WF_NOTIFICATIONS tables of Oracle EBS system to Oracle Fusion System. In EBS we have…Nalsoft Pvt Ltd 71 views 2 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management
-
Linking ce_statement_lines and ap_checks_allSummary: Hi all, I can't find a way to link the tables: ce_statement_lines and ap_checks_all. Is there any intermediate table to link these? Or any way to link bank stat…Sheik Shameem 42 views 4 comments 0 points Most recent by Sheik Shameem Payables, Payments & Cash Management -
Can we exclude Public Holidays when scheduling processesSummary: Our client has a requirement to exclude weekends and public holidays when scheduling, for some of the finance processes. We are able to see an option to exclude…Snehal H 33 views 5 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
What are the setups/steps needed to enable to print the checks in local language?We have a requirement from the Canada, that has to print the checks in their local language (Canadian French). Could you please provide the steps that need to enable in …Raju Thadakala_1234 35 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
SQL query to retrieve the canceled invoices amount as per the date for AP aging report.((select sum(aia1.CANCELLED_AMOUNT) from ap_invoices_all aia1 where 1=1 and aia1.APPROVAL_STATUS = 'CANCELLED' and aia1.invoice_id = aia.invoice_id AND :as_of_date < aia…Vikas V. Kamat 379 views 4 comments 0 points Most recent by Vikas V. Kamat Payables, Payments & Cash Management
-
Process Payment Files > ISO 20022 SEPA > Credit Transfer Messages > Predefined BI Publisher TemplateSummary: Process Payment Files > ISO 20022 SEPA > Credit Transfer Messages > Predefined BI Publisher Templates Content (required): Hello All, Regarding the ISO 20022 SEP…
-
In standard - Disbursement Payment File Formats report need xml /data model.Summary: User wants to see approval History details in Standard Disbursement Payment File Formats report. There is no data model available . Kindly provide the xml / dat…Naggrajan 31 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How do we encrypt the Payables Payment Connection Credentials in the ERP database?Summary: How do we encrypt the Payables Payment Connection Credentials in the ERP database? They are encrypted on the screen but not in the ERP database tables which pos…CarmenR. 21 views 1 comment 0 points Most recent by Daniela Petria-Oracle Payables, Payments & Cash Management
-
Derive Logo on Payment File Format by Legal EntitySummary: Content (please ensure you mask any confidential information): Does anyone know the logic to derive a logo on a rtf payment file format by legal entity? For exa…Rory Mullin 11 views 2 comments 0 points Most recent by Rory Mullin Payables, Payments & Cash Management
-
Edit Bank Account Transfer XML PAIN 001 formatSummary: We are in the process of implementing bank account transfers and our bank is requesting the details in PAIN 001 XML format. Need help to get the XML format to e…Wilson Chelakadan 11 views 1 comment 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
Supplier Legal name change after few months in production and with existing open transactionsSummary Supplier Legal name change after few months in production and with existing open transactionsContent What is the best practice to handle the situation in Cloud i…Sam Samaddar 52 views 8 comments 0 points Most recent by Adman1234 Payables, Payments & Cash Management
-
Can we download AP invoice attchement for BU / period of timeSummary: Can we download AP invoice attchement for BU / period of time Content (please ensure you mask any confidential information): Can we download AP invoice attcheme… -
Regarding "SEPA Credit Transfer Initiation" paymentHello gurus, Good day! 1. I would need the original copy of "ABBL XML FORMAT" the xsl template for the "SEPA Credit Transfer Initiation (with unstructured remittance det…viji_r 31 views 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
How to fetch "Check Payment Status" and "Check Issued State" in HCM for US Payroll ?Summary Hi All, Kindly help me to fetch the details of the Check payment as in HCM. As I required a few below columns: Check Payment Status: What is the current status o…abhjkum-Oracle 14 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Check Printing IssueSummary: Overflow in Check Printing Content (please ensure you mask any confidential information): We have to customize the out of the Box Check Printing report. Above t…KetanDoshi 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
which table and column the 'Stage' field is fetched from in the 'Manage Payment Process Requests' ?From which table and column the 'Stage' field is fetched from in the 'Manage Payment Process Requests' screen in Oracle Fusion Payables as attached?Nirosha Yelicherla 61 views 4 comments 0 points Most recent by lkarthik-Oracle Payables, Payments & Cash Management
-
Payables Trial Balance Report ESS Job Template changeSummary: Hi, User requested to create a template change for Payables Trial Balance Report, the ESS job. As this is an oracle developed report you cant make a template ch…aireyevan 31 views 3 comments 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management
-
Will Oracle provide NAUPA Reporting format for unclaimed property filings to State?Summary: State of Illinois requires electronic reporting for the unclaimed escheatment property. Will Oracle Fusion create a reporting format in later releases to accomo…LE 16 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
ap_holds_all.last_updated_by as "HOLD_RELEASED_BY"This is related to the AP Invoice tax hold release. We are looking for the table details where the hold released by name will be captured for the AP Invoice. Currently w…POOJAJSINGH 21 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Query Invoice Group via BI ReportSummary: Content (please ensure you mask any confidential information): Is the business object Invoice Group available as column in one of the AP tables? Its available f…Rory Mullin 94 views 2 comments 0 points Most recent by Rory Mullin Payables, Payments & Cash Management
-
Deep link to Invoice attachment in Approval Email Notification is not workingSummary: We are trying to add a link to the Invoice attachments in the PPR approval notification. But the link is not working and an additional URL of the instance is ap…Karishma Mungara-Oracle 91 views 2 comments 0 points Most recent by Mak Sahil-Oracle Payables, Payments & Cash Management
-
Query to get Approver Details of Ad-hoc payment in Cash managementSummary: Need Query or Joins to get Approver Details of Ad-hoc payments in Cash Management Content (please ensure you mask any confidential information): Hello Experts, …Nalsoft Pvt Ltd 111 views 1 comment 0 points Most recent by Vishal Sharma ORACLE-Oracle Payables, Payments & Cash Management
-
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 23 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 31 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 11 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 42 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 121 views 6 comments 0 points Most recent by Christian Roxas Payables, Payments & Cash Management