BI Publisher
Discussion List
-
Custom Data Model Not Reflecting in Payment File – Fix?Summary: Context: We have set up a transmission configuration to transmit files to an SFTP server. Additionally, we have: Created a Data Model to extract the required fi…Sandeep cheerla 1 view 2 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMSSummary: Hi TTeam, Could you please help us on this below SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMS in Specify Cash Positioning and Forecasting …Opkey PA 11 views 3 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Unable to find validation status in AP_INVOICES_ALLWe are creating a custom report and we need to give invoice validation status as a parameter. I am not able to find anything with validation status. Need some help on it…KabirB 21 views 4 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
SQL query to get Manage Withholding Tax Classifications setup dataSummary: Hi Team, We need a table where the information of Manage Withholding Tax Classifications setup data. The table ZX_ID_TCC_MAPPING_ALL have the classification cod…
-
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 315 views 9 comments 1 point Most recent by S Akhtar Payables, Payments & Cash Management
-
Need to check the default parameter logic for the Supplier Balance Aging Report.Summary: Hi Oracle Community , I need to check the default parameter logic for the Supplier Balance Aging Report, When I submit the report with ledger, business unit and…User_J7ULB 31 views 3 comments 0 points Most recent by ERP.HCM1 Payables, Payments & Cash Management
-
how DOCUMENT_CLOB gets populated in IBY_TRXN_DOCUMENTS table?We have requirements to create custom payment documents. We are reusing ISO20022CGI.xsl file from Disbursement Payment File Formats. The data model has SELECT DOCUMENT_C…KabirB 175 views 5 comments 0 points Most recent by Nallari Archana Payables, Payments & Cash Management
-
Provide the supplier balance aging report logic from backend.Summary: Hi Team, Could you please help us to provide the supplier balance aging report logic from backend. We were not able to see the logic of supplier balance aging r…Arjunayan 21 views 2 comments 0 points Most recent by Arjunayan Payables, Payments & Cash Management
-
How do you manage consecutive check number using Remittance stub?Summary: When you use Remittance Stub and Void by Overflow in "ExternalCheck.rtf" template for PPR in Account Payables, you have check numbers for void check as well as …Yuko Asanuma 32 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Query/tables to find payment approved by final approver approved PPRSummary: Query/tables to find payment approved by final approver approved PPR Content (please ensure you mask any confidential information): Hi All, We got a requirement…
-
Request for SQL Query to Retrieve Cash Balances with Specific ColumnsSummary: Provide a SQL query for Cash Balances to include columns with Legal Entity Name, Entity ID, Bank Account Number, Bank Account Name, Bank Account Type, Currency,…Guthi Mallikarjun 235 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
How to customize ISO20022CGI2019.xslSummary:How can I customize ISO20022CGI2019.xsl? Which fields from which records can I use? Content (please ensure you mask any confidential information): Version (inclu…User_VJR36 21 views 2 comments 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
Need query/table to get accounting status of external transactionsSummary: Need query/table to get know the accounting status of an External Transaction Content (please ensure you mask any confidential information): Version (include th…Dipak Das 11 views 1 comment 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management
-
Oracle Analytics Publisher Desktop Silent Install FailSummary: I have a requirement to install Oracle Analytics Publisher Desktop to client's machines via a silent install. When trying to perform this install with the synta…Johnny'sDaddy 59 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
SUPPLIER BALANCE AGING REPORT Showing invoices in Unallocated AmountSummary: Needs to understand the current logic of this "Supplier Balance Aging Report Content (please ensure you mask any confidential information): The accounting event…
-
How to get Trial balance detailed ReportSummary: Please let me know how to drill down from the Payables Trial Balance Report to view invoices? Content (please ensure you mask any confidential information): Ver…sailesh_cloudare 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Intelligent Payment/ Dynamic Discounting NotificationsHow does the Intelligent Payment/ Dynamic Discounting Notifications get sent out to suppliers on a weekly basis through a scheduled process job?Anushree Chitranshu 11 views 3 comments 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Concatenate elements in eText templateSummary: Concatenate elements in eText Positive Pay template Content (please ensure you mask any confidential information): I am looking to concatenate two data elements…KDR 115 views 3 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Where can I configure date tolerance for PO and AP Invoice matching in Oracle Cloud?Hi everyone, I'm encountering an issue when trying to match a Purchase Order (PO) with an Accounts Payable (AP) Invoice. The error message indicates that "This line has …Engel 51 views 2 comments 0 points Most recent by Abdelaziz Safwat Payables, Payments & Cash Management -
How to enable deep link in payment approval notificationSummary: How to enable deep link in payment approval notification? Content (please ensure you mask any confidential information): Hi all, We got a requirement to show in…Venkatesan 22 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management
-
Payment Process Request Status RTF Templatein Payment Process Request Status RTF Template, Get_Variable working directly without declaring Set_Variable. Anybody experienced same in RTF? If I use Set_Variable syst…KISHAN BUSSA 1 view 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management -
Does Oracle Fusion support Microsoft Unified Printer ServerSummary: Does Oracle Fusion support Microsoft Unified Print Server, Can we connect to a printer which is exposed on Microsoft Unified Server. As the client specifically …
-
How to prevent approval or validation of invoices whose BUs are different between line and headerSummary: I would like to know how I could create a rule to prevent the approval or validation (preferably) of invoices whose Business Unit is different between the Invoi…FilipeFerreira_ 1 view 1 comment 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management
-
How to add Intermediary Bank account field for Customized ISO20022 Payment FormatSummary: Hello, We need a customized ISO20022 Payment format with the intermediary bank account fields. I followed the doc ID How To Add Intermediary Bank Fields for Cus…Mariam Lefranc 91 views 3 comments 0 points Most recent by JANKUR Payables, Payments & Cash Management -
How to print overflow checks on plain paper using different tray's in printer.Summary: Hi Team. We have a requirement to print overflow remittance pages of AP Check on a different paper than the check paper. For example, in the check template, if …Ramprakash09 172 views 4 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Is there any settings for Check Print to print void at the last actual check amount on the 1st page?Summary: Standard check print Report is invoked as part of payment process request whenever payment is done automatically Format Payment Files program trigger and output…Sonal Umesh Jawalkar 191 views 7 comments 0 points Most recent by Yuko Asanuma Payables, Payments & Cash Management
-
How to handle & symbol in payment file xsl templateSummary: Need to replace '&' symbol with 'and' in payee name and address fields. We have triedsrziffdavis 11 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
On Etext template, is it possible to create LOV for reference within the template?Hello, We have a requirement to create a payment file format on Etext template. We have a field that needs to display a 3 character string that will serve as a code equi…Kristelle 11 views 1 comment 0 points Most recent by Lakshmish Rao-Oracle Payables, Payments & Cash Management
-
Address information for SingaporeSummary: HI All Could anyone advice what is the correct navigation for StreetName and Building number in case of Syngapore? I'm trying to create xsl payment file Content…Aleksandra Bykhan 11 views 1 comment 0 points Most recent by Lakshmish Rao-Oracle Payables, Payments & Cash Management -
Query to get tax registration from supplier address levelSummary Tax Registration from Supplier AddressContent Hello I was wondering if you can share with me any SQL to get the Tax Registration at the address Level. I have the…gabriel kinovisques-163562 4.1K views 6 comments 1 point Most recent by Ch M Prasad-Oracle Payables, Payments & Cash Management