BI Publisher
Discussion List
-
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 23 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 350 views 9 comments 2 points Most recent by S Akhtar Payables, Payments & Cash Management
-
Need to check the default parameter logic for the Supplier Balance Aging Report.There was an error rendering this rich post.User_J7ULB 37 views 3 comments 0 points Most recent by ERP.HCM1 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 40 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 40 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…
-
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 23 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 14 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 80 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 12 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 12 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 187 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 54 views 2 comments 0 points Most recent by Abdelaziz Safwat 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 2 views 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_ 5 views 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 92 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 228 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?https://us.v-cdn.net/6034893/uploads/SCS5OZ390XA1/standard-form-feed-check-28stub-after-payment-29-sample-output.pdf https://us.v-cdn.net/6034893/uploads/RFCMWOEBX7WY/st…Sonal Umesh Jawalkar 210 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 16 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.2K views 6 comments 1 point Most recent by Ch M Prasad-Oracle Payables, Payments & Cash Management
-
How is the data in the DOCUMENT column of IBY_TRXN_DOCUMENTS generated?Summary: How is the data in the DOCUMENT column of IBY_TRXN_DOCUMENTS generated? Content (please ensure you mask any confidential information): Version (include the vers…User_VJR36 22 views 1 comment 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management
-
What is SrcDescriptiveFlexField?We are using the standard Oracle data model TransactionDocumentExtractDm to review Payment files for XML and standard remittance template building but are not sure what …Cam Mistry 21 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
invoice approval report with signatures of all approversHi, Business requirement is to create a payable invoice pdf template with signatures of all approvers. Currently we are having signatures on PO pdf output but only of la…Rahim Azam Butt 3 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Automatic Report Printing PaymentsDear All, I have successfully customized two BI reports using my own data model and RTF template—one for cash payments and the other for check payments. I need to config…George Mattar 1 view 1 comment 0 points Most recent by Priyanka Gunasekaran-Oracle Payables, Payments & Cash Management