OTBI
Discussion List
-
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 56 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 35 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 13 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 12 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 52 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 104 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 46 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 31 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 33 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 69 views 2 comments 0 points Most recent by Rory Mullin Payables, Payments & Cash Management
-
Convert OTBI number format in exponential format to Number formatSummary: Hi Community, for one of our integration, We create one OTBI report and exported to excel, we entered data for few columns in that excel and convert it to csv f…Subhash M V 33 views 2 comments 0 points Most recent by Subhash M V Payables, Payments & Cash Management
-
How to import a data from Oracle cloud to OTBISummary: Hi, we try to create a analysis in OTBI using a Payables Invoices - Installments Real Time Subject area, but we didn't get the any results, In ERP we have roles…Alex Pagliarini - Ninecon 12 views 1 comment 0 points Most recent by Abi Osborn Payables, Payments & Cash Management -
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…
-
OTBI conditionis there any way to put a condition in OTBI report to multiply the invoice amount by -1 if the invoice type is a prepaymentUser_1GTKA 12 views 2 comments 0 points Most recent by Pradeep1947 Payables, Payments & Cash Management
-
Mass upload invoices via spreadsheetSummary: Mass upload invoices via spreadsheet Content (please ensure you mask any confidential information): Is there a template available to mass upload invoices at onc…CraigX 21 views 4 comments 0 points Most recent by Alex D-Oracle Payables, Payments & Cash Management
-
AP Inquiry RoleSummary: I don't want to give ap manager role access to one of the user what privilege's I need to give to the user so that user can see the payables dashboard report (O…Pooja_123 33 views 4 comments 0 points Most recent by Pooja_123 Payables, Payments & Cash Management
-
Invoice Lines with yellow exclamation markHi All, The Invoice lines have a yellow exclamation mark, with type Item and red box against Amount column. We are unable to find the error message it shows needs revali…Swapnil Kashid 11 views 2 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management -
Is Project Number for AP available in General Ledger or Subledger Accounting Subject AreaGood Day Experts, Is project number field for AP available in General Ledger or Subledger Accounting Real Time subject area? Just like the PO Number for AP where I can g…JMLMIII 1 view 1 comment 0 points Most recent by Dustin Grabowski-Oracle Payables, Payments & Cash Management
-
How to burst a standard report attachment run from scheduled process page to a users email?Summary: Our users spend so much time going into the system to download the files they run from the monitor/scheduled process page. We have already customized the Oracle…
-
Oracle Fusion to customize format payment data modelSummary: Hello everyone. For implementation on a client, a new custom check format needs to be created. It is necessary to add some fields that are not shown in the xml.…Juan López 142 views 2 comments 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
Invoice Approval Deep LinkSummary: Invoice Approval Deep Link Content (please ensure you mask any confidential information): Hello, Do you know if there is a deep link that can be used to approve…Irina Erhan 114 views 11 comments 0 points Most recent by Alon Hadar Tamir Payables, Payments & Cash Management
-
Upload mt942 file format importing bank statements in Oracle Fusion??Summary: Upload mt942 file format importing bank statements in Oracle Fusion Simple question If we can to upload this file format MT942 ??? Now we need to implment the 2…Christian Leon 69 views 2 comments 0 points Most recent by Christian Leon Payables, Payments & Cash Management
-
Not receiving email notifications for Invoice approvalsSummary Not receiving email notifications for Invoice approvalsContent Hi All, Not receiving email notifications for Invoice approvals Thanks, Dev Thota. Version 20CDevendra Thota 47 views 3 comments 3 points Most recent by Unnati Mandhare Payables, Payments & Cash Management
-
Supplier Invoice Attachment Downloadable Link in BIP Reports to User with No AP AccessHi All, We have a client requirement where limited Users can have AP Access (Edit and View) but there n number of Users(Purchase Requisition Requester) will be running t…Abhijeet Tamoli 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Projects and Accrue at Period EndMorning all, I'm working on a client where we have configured Accrue at Period End but need to get accrual info into Projects (without switching to Accrue at Period End)…