OTBI
Discussion List
-
Negative Vendor_Id values in AP_INVOICE_ALL TableSummary: We can see -ve vendor id's in AP_INVOICES_ALL table which are not available in POZ_SUPPLIERS table at all. We understand that this is expected behavior in scena…PradeepKrSingh 4 views 1 comment 0 points Most recent by SankarBalu Payables, Payments & Cash Management -
Update Separate Remittance Format RTFSummary: We would like to add the bank account account name and bank account alternate name from the supplier banking information in the separate remittance RTF. There i…Clare Paone 25 views 3 comments 0 points Most recent by Nipun_Garg Payables, Payments & Cash Management
-
OTBI-Cannot find "Structured Payment Reference" field in Cash Management - Bank Statements Real TimeSummary: I'm trying to create a report based on bank statement line items. The one field I cannot seem to find is the "Structured Payment Reference" (see attached). Are …
-
Requires to have a Cash Flow Report?Hi, We require to have a cash flow report, appreciate if you can provide any existing reports or subject areas which can be used in creating the report, and any inputs y…Janitha Perera 10 views 0 comments 0 points Started by Janitha Perera Payables, Payments & Cash Management
-
Supplier Analysis Prompt not displaying from ReportsSummary: I created Supplier ACH Verification Analysis with prompt for user to select Supplier Name prior to displaying results, however when user opens analysis from Rep…Eybrown 8 views 1 comment 0 points Most recent by Veronique Gagnon Payables, Payments & Cash Management
-
Actionable Dashboard for ApprovalSummary: To approve bulk invoice all columns are not available in the worklist where the approver can view the columns and select and approve. So can we create a actiona…Jagjit Singh Arora 2 views 0 comments 0 points Started by Jagjit Singh Arora Payables, Payments & Cash Management
-
Request for Documentation on Fields Match for XML Document in IBY_TRXN_DOCUMENTS TableSummary: Hello, My team I are working on an H2H implementation for a client using the Oracle ERP Cloud system. As part of this implementation, I need to understand the s…Arturo Contreras 70 views 2 comments 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management -
Report Payables withholding tax and accountsSummary: Hello, We would like to know if there is a report to support the Payables withholding tax invoices and Tax Accounts Content (please ensure you mask any confiden…AN_ 18 views 2 comments 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
-
Create Deep Link for receipt attachment in the Oracle Fusin OTBI Expense ReportSummary: One of our customers is expecting us to add Receipt attachment Deep link to the Oracle Fusin OTBI Expense Report Content (please ensure you mask any confidentia…Shashikanth Kumar P-Oracle 53 views 2 comments 0 points Most recent by Shashikanth Kumar P-Oracle Payables, Payments & Cash Management
-
IDR: Report to pull Invoice Account Coding HistorySummary: We would like to track account coding history as part of the invoice for reference and audit purposes. What is the best way to accomplish that? Content (require…Judy Hamner 29 views 1 comment 3 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Can we create a rule to auto reject the invoices if particular account is found?We have a requirement to not allow the invoices (PO, non PO, boundary apps invoices) to be charged to 1***** account. This account can be used in other subledgers so we …KanikaMahajan 17 views 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
create AP Invoice custom Inquiry role without using AP_MANAGE_PAYABLES_INVOICES_ACTIVITIES_PRIVSummary: can we create role for AP invoice Inquiry and view report access without using AP_MANAGE_PAYABLES_INVOICES_ACTIVITIES_PRIV" which Allows access to Oracle Fusion…manoj.kumar4 34 views 2 comments 0 points Most recent by Kopalli Narasimham Payables, Payments & Cash Management
-
Holds, Approval and Due payables infotile displaying data for all available BUsSummary Holds, Approval and Due payables infotile displaying data for all available BUsContent Team, User can able to see all available BUs information on the Holds, App…Surya01 37 views 5 comments 0 points Most recent by Arvi Dinavahi-Oracle Payables, Payments & Cash Management -
Payables OTBI Subject Area - Account Coding Intiated DateHi All, We are developing an AP KPI dashboard using OTBI . Wanted to check if the following field available in Payables OTBI subject area? 1. Invoice Account Coding Init…Devashish Saun 11 views 0 comments 0 points Started by Devashish Saun Payables, Payments & Cash Management -
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_ 35 views 0 comments 0 points Started by Scott_Turner_ Payables, Payments & Cash Management
-
What Are the roles to access all subject area for C - Level UsersSummary: Content (required): As a best practices what are the recommended out of the box role for C Level Uses (CEO, CFO), We except these users to have access in all su…Rimaad ImamBaccus 7 views 0 comments 0 points Started by Rimaad ImamBaccus 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 27 views 2 comments 0 points Most recent by Sachin Kr Singh Payables, Payments & Cash Management -
Read only user unable to open standard dashboard report. how to get required privilege for report.Summary: We have Auditors user having read only role access and also given standard dashboard report access but report not opening. Content (required): for e.g standard …
-
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… -
In OTBI trying to pull Natural Account preSummary: We are creating OTBI report by combining the subject areas - 1. Payables Invoice - Transaction Real time and 2. Payables Payment Disbursements real time. We are…
-
Invoice attachments URL link in AP Invoice reportSummary: User wants to have a URL link in AP Invoice report so that they can click the URL and see the invoice attachments. Content (required): User is not having the ac…Jaik 44 views 1 comment 1 point Most recent by Bogdan Nita-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 899 views 4 comments 1 point Most recent by Mohamed Faramawy dev.-Oracle Payables, Payments & Cash Management
-
Need Payable Invoice DeeplinkSummary: Need to know which Payable Invoice deeplink can be used in OTBI to show AP invoices related to POs Content (required): Version (include the version you are usin…Arunima Pandey 3 views 0 comments 0 points Started by Arunima Pandey Payables, Payments & Cash Management
-
The column "Accounting Status" on Manage Invoice screen is which table information?Summary: From which table can I get the "Partially accounted" in the attached image? Content (required): PATH :: HOME>Invoices>Task:Manage Invoices I want to get the val…REI TSUKAHAR-Oracle 64 views 5 comments 0 points Most recent by Sandeep Nayak-Oracle Payables, Payments & Cash Management
-
How to Create a Grand Total Column in OTBI ReportSummary: We created a Payment advise report using the Payables Subject area, but the customer wants us to create a Grand Total column to Sum up all the columns, please h…Chukwuemeka Aniukwu 363 views 4 comments 0 points Most recent by Connie Finck Payables, Payments & Cash Management
-
Setting custom check format for APSummary: I am setting up custom AP check format first time. Need to know the steps, any document showing steps. Content (required): I need to add custom layout for AP ch…
-
Webservice or REST API to fetch Data from OTBI Seeded ReportSummary: We are in need of a Webservice or REST API to fetch data from OTBI Report Content (required): We are trying to get data from seeded OTBI Report through webservi…
-
OTBI Report for Current Invoice ApproverSummary: I am trying to build an OTBI report that shows invoices that are pending approval along with the name of the current approver. For the most part, I have been ab…
-
AP Invoice Account Coding initiation dateSummary: which fusion table will have information of AP invoice Accounting Code, Initiation Date to write a SQL query Content (required): AP Invoice Account Coding initi…Harish Pati 83 views 1 comment 0 points Most recent by Meghana Gaddam-Oracle 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 51 views 0 comments 0 points Started by SireeshaJaladi Payables, Payments & Cash Management