Reporting
Discussion List
-
OTBI - View employee hierarchy vs manager hierarchySummary: I am trying to write an analysis in OTBI which would provide a managers Level 2,3,4,5 Department vs an employee's Level 2,3,4,5 Department. I want to ensure tha…Scott_Turner_ 42 views 0 comments 0 points Started by Scott_Turner_ Payables, Payments & Cash Management -
how to purge data files from ucm server for Import Payables programSummary: We have around 2000 datafiles appearing in datafiles Lov while submitting Load Interface File for Import program. Attaching the screenshot where the datafiles c…Sachin Kr Singh 21 views 2 comments 0 points Most recent by Sachin Kr Singh Payables, Payments & Cash Management -
Table to extract taxpayer id details for suppliers of individual typeSummary: Table to extract taxpayer id details for suppliers of individual type Content (required): Table to extract taxpayer id details for suppliers of individual type.…Vinothini 701 views 1 comment 0 points Most recent by SankarBalu Payables, Payments & Cash Management -
Rehire can't run OTBI report, but net new user account with same access canSummary: We have a rehire who can't run an OTBI report we built, but the same net new user account with the exact same roles and data access can. Content (required): Has… -
Do we have any report what are the employee expense invoices applied against the Employee advancesSummary: Do we have any report what are the employee expense invoices applied against the Employee advances Content (required): Business wanted to see which are the expe…Sangireddy-Oracle 1 view 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
Adding page break to etext templateSummary: We have an etext template that we need to have a page break to. It appears that we can do this with xml, but we currently don't have any XML in our template. Is… -
Netting Settlement Letter doesn't show Payables transactionsSummary: When executing a Netting settlement and downloading the Netting Settlement Letter, the payables transactions section is not showing the information of the invoi…FiorellaLamas 11 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
How to setup an AP Payment term 95% inmmediate 5% on hold ?Summary: How to setup an AP Payment term 95% inmmediate 5% on hold ? Content (required): Hello I have a business requirement for one supplier 95% is due inmmediate and 5…Cesar Saveedra 21 views 2 comments 0 points Most recent by Cesar Saveedra Payables, Payments & Cash Management
-
Do we have any tax related report which shows data in functional currencies in Fusion?Summary: Our expectation is all the AP, AR or Other Tax related Transaction in Functional Currencies Report. Content (required): We have financial tax register report bu…VijayDXC 11 views 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
How to track changes in Approval limits in BPMSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Table that holds US 1099 payment related info.Summary: Content (required): Hi All, We are building a custom report on top of "US 1099 Report", that report the payments made to a vendor who is covered under federal r…Srikanth_K 11 views 1 comment 0 points Most recent by Sandeep Nayak-Oracle Payables, Payments & Cash Management
-
Include project details AP Payment CheckSummary: In 'Disbursement Payment File Formats' oracle Seeded XML file I did not see AP invoice project details, if invoice is mapped to any project details. How to map …Narendra Prasad Golla 21 views 1 comment 0 points Most recent by Narendra Prasad Golla Payables, Payments & Cash Management
-
Logic behind the comparison filter for invoice numbers, AR and APFor an integration and extension we are designing, we need to have a clear understanding of the logic used by the same system when the user uses the following filters fo…
-
Table details for Setup: Payment process ProfileSummary: Table details for Setup: Payment process Profile Content (required): We need table details, which stores Default Payment Document for Payment Process Profile Cr…Nishanth B Jain 73 views 5 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management -
Configuration Required to Generate SEPA Payment File on ScheduleSummary: Configuration Required to Generate SEPA Payment File on Schedule Content (required): Hello All, We have a requirement to generate and export SEPA payment file e…Bernard T 21 views 2 comments 0 points Most recent by Bernard T Payables, Payments & Cash Management
-
How To Successfully Customize the "Disbursement Payment Process Request Status Report Formats"Summary: We are turning on payment approvals but the approvers do not like the seeded layout of the Disbursement Payment Process Request Status Report. I was attempting …Brian Burns 398 views 4 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
How to Generate XML and Modify the Payment Process Request Status ReportSummary: I am trying to customize the payment process request status report but am unable to generate an xml of the report in order to either make a new layout or edit t…Brian Burns 301 views 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
Does Oracle provides any option to sign the JPK file (trusted eSignature) for Poland ?Summary: Client requirement is to have the JPK signed by the designated signature. Content (required): Client requirement is to have the JPK signed by the designated sig… -
Closing Available Balance in Bank StatementSummary: Content (required): Hi, Can someone kindly explain to me how the Closing Available balance in Bank Statement is derived as shown in the screenshot below? Versio…Sheneli98 32 views 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
Check amount in words with centsContent Hi All, We have a requirement to print check amount in below format ONE THOUSAND FIVE HUNDRED USD AND 00/100 Currently xml generated from PPR is having format li…Nishanth B Jain 138 views 7 comments 1 point Most recent by SrinathD Payables, Payments & Cash Management
-
How to Check and Extend Maximum Character Limit of Line Description in Report OutputSummary: Hi, We are having Line Description of 310 Characters in Payables Payment. While Checking in Standard or Custom Journal Report output we can see description with…Nirav Vekaria 567 views 2 comments 0 points Most recent by Nirav Vekaria Payables, Payments & Cash Management -
Multi-Period Accounting ReportsSummary Looking for reports linked to multi-period accountingContent Hi All, We want to use multi-period accounting but before we do so we wanted to ensure that we can g…User_2025-02-04-19-45-49-438 122 views 8 comments 2 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management -
How to prevent payment amount replication on Payment Details Report-multiple invoices incl in pymtSummary: Payment Details Report is duplicating Payment Amount when more than 1 invoice was included in payment. Is there a way to prevent this from happening? Or add a c…
-
How to track audit history on Transaction Tables like Invoices, PaymentsSummary: We have observed a few instances where in some invoices, payment records in base tables is showing up last updated by value as certain individuals who are not s…Sadhu12 297 views 2 comments 1 point Most recent by Jeff Hare CPA CISA CIA Payables, Payments & Cash Management
-
How to get invoice accounting lines' class.Summary: Writing a SQL report to get invoice line's class and we are unsure how to get that and what table(s) that data may need to be joined from in order to get it. Co…User_2025-03-07-19-21-21-977 216 views 2 comments 0 points Most recent by User_2025-03-07-19-21-21-977 Payables, Payments & Cash Management
-
How to sum a variable in XSL template?Summary: I'm unable to a sum a variable data in XSL template. Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code…SireeshaJaladi 101 views 0 comments 0 points Started by SireeshaJaladi Reporting and Analytics for ERP
-
I would like to know if Cloud has any invoice group reportSummary: I would like to know if Cloud has any invoice group reports, including the invoice group's total count and amount. Content (required): Version (include the vers…Dorothy Lee 31 views 0 comments 0 points Started by Dorothy Lee Payables, Payments & Cash Management
-
QR invoicing and connection to ZATCASummary: Dear All, Accounts receivable invoices must have a QR code. Content (required): We are using e-invoicing and must implement QR invoicing and connection to ZATCA…Elia Chrabieh 211 views 3 comments 7 points Most recent by Mujahid Ali Payables, Payments & Cash Management