Category 129
Discussion List
-
OTBI reportOTBI reportVineet Srivastava Graviton 21 views 1 comment 0 points Most recent by Erick.B Reporting and Analytics for ERP -
PVO SubledgerJournalTransactionEntityExtractPVO and SubledgerApplicationExtractPVO generating blankSummary: PVO SubledgerJournalTransactionEntityExtractPVO and SubledgerApplicationExtractPVO generating blank files even after reseting to full extract Content (please en…
-
BIP SFTP Bursting vs BIP SOAP API calloutSummary: Advantages of BIP API download option (for data reports) Vs BIP report sent to SFTP channel Content (please ensure you mask any confidential information): We us…Abdullah Munaz 47 views 2 comments 0 points Most recent by Akash Katiyar-Oracle Reporting and Analytics for ERP
-
SQL query to display Purchase Category hierarchySummary: SQL query to display Purchase Category hierarchy Content (required): For anyone who might find this useful, I've written a SQL to pull the Purchase Category hie… -
Convert this filter to SQLSummary: Convert this filter to SQL does not function Content (please ensure you mask any confidential information): I try to using 'Convert this filter to SQL' function…
-
Logged in User display on OTBI reportHi Team, Both below do not generate the logged-on user at filter condition on OTBI once moved into 24A even if a person's security profile is active on view employee's o…GopalS 241 views 1 comment 0 points Most recent by Catalina Soare-Oracle BI Publisher Learning Center
-
Report not displaying Barcode when executed from ESS jobSummary: Report not displaying Barcode when executed from ESS job Content (please ensure you mask any confidential information): We have customized the Receipt Traveler …
-
Import Oracle Fusion Data Extensions for Transactional Business Intelligence having an impact.Summary: There's an issue with HCM Reports having said that some columns were not available and the root cause of it was when Import Oracle Fusion Data Extensions for Tr… -
Using rest api in fusion BI publisher data modelSummary: Is there any way to use rest api fusion BI publisher data model, I need to consume external data source and create a report in oracle fusion Content (required):…ShivaShiva 1.5K views 6 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Asset cost and reserve detail ReportSummary: I am currently working on a custom report where I need to include asset cost, reserve details, and a summary report. However, I am unsure about how to obtain th…Regina_P-Oracle 111 views 2 comments 0 points Most recent by arpit_paliwal Reporting and Analytics for ERP
-
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 31 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 67 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 11 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 31 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 251 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 331 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 23 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