OTBI
Discussion List
-
Code Combination ID field from Payable Invoices-Transaction Real Time subject Area for Invoice LineSummary: Distribution tab details are not available for an Interfaced Invoice prior to validating the invoice in Oracle fusion. We are trying to create an OTBI to displa…Sifat Shaikh 15 views 0 comments 0 points Started by Sifat Shaikh 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 409 views 6 comments 0 points Most recent by MarkGauthier Payables, Payments & Cash Management
-
How to make US1099 report to be emailed to Vendor?Summary: Content (please ensure you mask any confidential information): Is there a way to email US 1099 to the email addresses on file? User has run this in excel and .p…User_4DSFF 13 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Check format using oraMICR fontSummary: Check format using oraMICR font Content (please ensure you mask any confidential information): Hello, I am implementing a check format for JP Morgan's payables …MARIANA25 46 views 4 comments 0 points Most recent by JustinLitalien 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 123 views 3 comments 0 points Most recent by Baskar.Chakravarthi Payables, Payments & Cash Management
-
Table details to get Business unit for a tax code definedSummary: We need table or query to fetch business unit name for the given tax rate code. Content (required): Version (include the version you are using, if applicable): …Nishanth B Jain 111 views 3 comments 0 points Most recent by User_HIPON Payables, Payments & Cash Management
-
User facing Issue while saving OTBI reportSummary: The user is getting the following error while saving an OTBI report: Catalog object privilege validation failed for user to path . You do not currently have suf…
-
How to report on the last person who updated an invoice prior to it being validated?Summary: Have a need to report on AP clerk invoice count metrics and would like to know of a field other than Last Updated By to determine who was responsible for proces…
-
Is there any report for Remittance Advice Delivery Email ID by supplier siteSummary: Report for remittance advice delivery email ID by BU Content (please ensure you mask any confidential information): Hi Team We required to update and add more e…JL-JL 23 views 3 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Supplier Internal Profile changes table details that includes the New Bank details before Approval.Summary: Hi All, When user do changes in the bank account of supplier and internal profile change request submitted to approver. Approver can see Only the last 4 digits …
-
Customizing Payables Withholding Tax ReportSummary: I am looking to customize the Payables Withholding Tax report by adding another column to it. Whenever the report is moved to a different folder it flags the er…
-
How can we get the Posted Revaluation amount calulation on Daily basis not period?Summary: Bank customer and daily running the revaluation and wants to see the posted revaluation amounts for each foreign currency and revaluation rate. Content (please …Eswarvoona-Oracle 14 views 1 comment 0 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany
-
Regarding the security role required to access OTBIDespite assigning the AP role to the user, the AP OTBI is not displayed. It is likely related to security roles. Could you please tell me the security role required to a…yuyano-Oracle 31 views 3 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management
-
How to create a report in OTBI of Manage Payment Process Requests informationSummary: The customer needs to have the information regarding the related invoices in a payment batch. Content (please ensure you mask any confidential information): I a…SERGIO BARRETO 31 views 2 comments 0 points Most recent by SERGIO BARRETO Payables, Payments & Cash Management
-
The document column in table IBY_TRXN_DOCUMENTS is not displaying correctlySummary: The document column in table IBY_TRXN_DOCUMENTS is not displaying correctly in a way that allows us to see the hierarchy of each payment detail by payee, payer,…Dahlia Gaggan 19 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Subtotal is not calculated correcting for one of the custom calculated measure in the OTBI reportSummary: I have created a custom OTBI report DPO (Days Payables Outstanding) to look at the average days to pay vendor. The last column is a calculated measure based on …
-
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 21 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
OTBI Unable to get the Payment Process Profile TemplateSummary: I need to create an OTBI Payment Report and include the PPP Template "Name", and I am unable to find it. I check in the "Payable Payment - Disinterment Real Tim…Pablo Schenquerman 11 views 3 comments 0 points Most recent by ADOLFO GARCIA BARBA-Oracle Payables, Payments & Cash Management
-
What is subject area and column that store AP Invoice Account Coding approval historySummary: Hi Team, We have built OTBI Report to get AP invoice details, but unable to find subject area and column which stores AP Invoice Account Coding approval history…
-
OTBI AP Invoice real time is not bringing information when it is the second subject areaSummary: I tried to merge 2 subject areas (Fixed asset and Payables transaction real time). The Fixed Asset information is bringing the right data, but when added the se…Pablo Schenquerman 17 views 1 comment 0 points Most recent by James McBride Payables, Payments & Cash Management
-
Payables Subject Area - what is the field to pull the comments at header levelI'm trying to create an OTBI payables report that pulls the data located in the comments field box, at the header invoice level. Where do I find it?Melissa Chan 43 views 4 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management
-
Notes on Payables Invoices in OTBI Subject AreasWe have received a request from the business to include manually entered notes against Payables invoices in certain existing OTBI reports. After reviewing all the Payabl…Simon Wall 61 views 2 comments 0 points Most recent by Swapnil Kashid 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 34 views 8 comments 0 points Most recent by Adman1234 Payables, Payments & Cash Management
-
Invoice Lines DFFSummary: Invoice Lines DFF Content (please ensure you mask any confidential information): Can invoice lines DFF that are displayed under "Details" be shown on the invoic…
-
My approved invoices OTBI reportHow do I default in an OTBI report invoice approver to be the User running the report? Or at least have in the drop down list only value available my name (the name of t…Julia Kang 36 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
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
-
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 12 views 2 comments 0 points Most recent by Rory Mullin Payables, Payments & Cash Management