Category 129
Discussion List
-
BIP Joining GL with PJF_PROJECTS_ALL_BI'm trying to join PJF_PROJECTS_ALL_B with this query so that I can add segment1 from the table to this GL report. Does anyone have any insight for easiest way to achiev… -
Required a field name and Table name for Manage Payment MethodsSummary: Hi Team, We need backend tables and a column for the field "Automatically assign payment method to all payees" under Usage rule → Manage Payment Methods. I coul…Opkey PA 32 views 1 comment 0 points Most recent by Krishna Pulicherla-Oracle Payables, Payments & Cash Management
-
Custom Job Set not showing for one userSummary: We have created job sets in a lower environment and the users that need to access it are able to with the exception of our Director of Projects. She is still no…Damien Curtis 69 views 5 comments 0 points Most recent by ChaitanyaBarge Reporting and Analytics for ERP
-
Percentage formula doesn't work for expandable columns.In the "Financial Reporting Center" section by opening the "Workspace for Financial Reports" several reports have been configured. I have an issue... In column A (as an …Michele Ferro-Oracle 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
How to pass last 2 quarters as period parameters in General Ledger-Transactional Balances Real TimeHow to pass last 2 quarters as period parameters in General Ledger-Transactional Balances Real Time We are trying to create a Analysis report based on General Ledger-Tra…Pradeep Kumar Reddy V 1 view 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
How to restrict User From Submitting Create Accounting for a Certain SubledgerSummary: How to restrict User From Submitting Create Accounting for a Certain Subledger Content (please ensure you mask any confidential information): Hi All, We have a …
-
Table to get the field of Condiion under Manage Chart of Accounts MappingsSummary: We need a table and column where the Condition field information stored for the setup "Manage Chart of Accounts Mappings". Attached the screenshot with highlite…
-
how add user variable to report header #2Summary: I need to add user variables into a report header. Is there any way to do this? What is shown below doesn't work. -
how add user variable to report headerIs there any way to put a user variable into the header of a report?
-
Table or Query for Condition column for Separate Remittance Advice in Manage Payment Process ProfileSummary: Hi Team, We need a table or query to get Condition fied under the Separate Remittance Advice in the setup Manage Payment Process Profile. We gone through these …Opkey PA 12 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Is it possible to add Approve and Reject buttons in payment process request tabSummary: Is it possible to add Approve and Reject buttons in payment process request tab in payables dashboard Content (please ensure you mask any confidential informati…Venkatesan 1 view 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
How to create a Fusion Data Intelligence DV Report using OTBI Fusion TableI have an OTBI BIP Report which is sourced from Data model using OTBI Fusion database tables. I need to recreate the report under FDI DV. I am not sure how to find same …
-
Supplier Registration DFFs after Next-Gen Supplier Self-service Registration ImplementedSummary: After implementing the Security Policies against Value-sets linked to Supplier Registration Descriptive Flexfields, these flexfields are no longer available in …
-
AP invoice approval workflowSummary: Hi Team, We have below requirement for Manual AP Invoice Approval, can somebody please tell us how can we acheive this. There are 31 department so based on depa…Asif Sayyed 37 views 2 comments 0 points Most recent by Asif Sayyed Payables, Payments & Cash Management
-
How to Fix Height of table In An RTF TemplateSummary: Hi Team ,Can anyone tell me how to Fix Height of table In An RTF Template. Example: If table has 1 or 10 invoice the height of table should be same. I have chec…Nidhi Chhajed 252 views 3 comments 0 points Most recent by Leeni Samuel Reporting and Analytics for ERP
-
How to send an ESS job output on email?Summary: Need to send an ESS job output (ex: .pdf) on email, to certain people Content (required): Needed functionality: send ESS job output on email. Tried from: Schedu…Elena Tudor 1.4K views 6 comments 0 points Most recent by Aravind_Kumar_A Reporting and Analytics for ERP -
How to add Hyperlink to BI Excel template fieldSummary: We have a requirement to show Oracle AR Invoice Page and when click on Invoice Number in BI Excel template. Excel template has list of Invoice Numbers and its d…SireeshaJaladi 341 views 5 comments 0 points Most recent by SatheeshSamy-Oracle Reporting and Analytics for ERP
-
How to schedule FRS reports in Fusion FinancialsSummary: I need to run an FRS report in Fusion Financials using scheduling. In EPM the process would be to create a batch and then add the batch to the schedule. In Fusi…
-
Which Table Stores Final Shipment Forecast Amount per Item in Manage Demand?Summary: I’m currently developing a report and struggling to find the table that contains the Final Shipment Forecast amount from Manage Demand. Has anyone encountered a…Dinar 24 views 3 comments 0 points Most recent by NinaLyubenova-Oracle Supply Chain Planning and Collaboration
-
Scheduling "report" based on column with user emailSummary: I developed an SQL report on OTBI and an EXCEL output should be delivered to corresponding users. There is a column containing email address of the user and use…Rojhat Sinan Balka 1 view 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP
-
Tables to get Multiperiod Accounting Invoices With Amortization ScheduleSummary: Tables to get Multiperiod Accounting Invoices With Amortization Schedule Content (please ensure you mask any confidential information): Hi All, Is there any tab…Venkatesan 44 views 1 comment 0 points Most recent by Daniela Petria-Oracle Subledger Accounting & Accounting Hub
-
How to fetch only current/latest updated eff data from EGO_ITEM_EFF_B table?Hi, We need to extract current item eff data. We are using EGO_ITEM_EFF_B for fetching the same. But this table is fetching all the values updated for effs till date. Bu…Gaurav Patil 57 views 2 comments 0 points Most recent by Gaurav Patil Reporting and Analytics for ERP
-
OTBI Report for General Ledger - Journals Real Time Not Displaying Correct AmountsSummary: Entered Credit & Debit Amounts and Accounted Credit & Debit Amounts are not displayed correctly in the OTBI Analysis using the General Ledger - Journals Real-Ti… -
List of Special character which cannot be loaded through FBDI file.Summary: We have around 50 Inbound integration from various sources for GL, AP, AR, PO, Receipts. We have observed that if special characters are present in the file lik…Rohan Rajmane-Oracle 181 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Can you run a process and have the report/file generated from the process sent to a set folder?Hi Everyone, Is it possible to have a process run adhoc or scheduled and when the process finishes the report output is sent to a file/folder location? For example, if o…
-
Browser is getting automatically refreshing when scheduling ESS job set in Oracle cloud ERPSummary: Hi All, I hope everyone is going well!. I need some help in resolving the ESS job set related problem. I have created the ESS job set with 10 Ess jobs inside of…VasanthaFusion90 13 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Creating a Headerless CSV File Using eText TemplateSummary: We are planning to develop a report in BI Publisher that generates a CSV file without column headers. Our understanding is that in order to exclude the header, …Jimin Park 85 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to use number format of process options of ess job in the BI publisher concerned ?Hi, how to format amounts of my custom BI Publisher depending on Number Format of my custom ESS job (defined for this custom report), submitted to Scheduled Processes ?LaurentDup 1 view 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
error using data mode property: Optimize Query ExecutionSummary: Hello everyone, a few days ago I experienced a new situation. I have a report that extracts a large amount of data (over 100,000). I tried to optimize the execu…Ayala01 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Query to Find Privillages under Role and its Inherited RolesSummary: Need query to get privileges assigned under Role and its inherited Roles. Content (please ensure you mask any confidential information): Tried Below query but l…Nishanth B Jain 297 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP