Reporting and Analytics for ERP
Discussion List
-
Assets - The following segment labels have misspelled BI Object Name setSummary: Hi What are correct spelled BI Object Name set for Assets. I have hit the following error: Regards, Bo Content (please ensure you mask any confidential informat… -
What is the best BICC PVO that matches to HR_LOCATIONS_ALL?Summary: Need BICC PVO that best aligns with on-prem table HR_LOCATIONS_ALL. I've looked at the most recent lineage mapping spreadsheet and the closest one I see is: Con…
-
EGP_EXPLOSIONS_V loads nothing, component tables do.Content Hi. I'm querying the view EGP_EXPLOSIONS_V and loads nothing. I queried its individual tables and DO load data: * egp_system_items_b_v * egp_structures_b B, * eg…
-
System Accounts from per_usersSummary How to identify system accounts like FUSION_APPS_SEARCH_APPID from per_usersContent Hi Is there a way to query and get a list of system accounts like FUSION_APPS…
-
Can an OTBI report have a sub-total lines?Summary: I have created an LD Schedule OTBI report where I need to insert a sub-total by Employee the percentage of effort. Can someone share how I can add that in the A… -
query of Negotiation modifications IP addressSummary: Need to report on Negotiation's modifications IP address Content (please ensure you mask any confidential information): Hi All, I would like to know, is it poss…
-
PVO for tax line distributions of an invoice to load data to FAWSummary: we have a requirement to showcase tax line distributions if an invoice in a FAW report. These data is not coming to FAW from ERP through delivered pipelines. Wa…
-
When passing a parameter to OTBI analysis in Page Composer it is not filtering as expectedDescription: I am trying to do page customization using the page composer for the "BPA Change Order Approval Notification” where I want to add one BI Analysis Dashboard …
-
How to Reduce Sftp Bursting completion times.Hi Team, We would like to inquire if there are any options to reduce SFTP bursting completion times. Currently, we are trying to place 10K files into an SFTP folder usin…
-
Data Security is not working in OTBI when we combine 2 Subject AreasSummary: We have segment value security enabled in the ERP Cloud and when we create OTBI Analysis using the General Ledger - Journals area or Subledger Journals area alo…
-
INV_MATERIAL_TXNSSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Essbase Cube, Report distribution, Oracle Fusion SaaS environmentWe are currently in Patch 24A getting ready to go to Patch 24B. We have Smart View and have build FRS WEB reports that users can run out of Financial Reporting Center. W…
-
Set default value for LOV to NULLI have a BIP report with multiple LOV parameters. When data-model/report is opened all LOV parameters are set to ALL by default, I need these parameters to be set to NUL…
-
How to schedule a custom weekly GL report, which includes date parameter of "PostedDate-7"Summary: Custom GL Report which needs to run at 12:05 AM weekly on Tues night and include data only from the previous week. If PostedDate = Aug 6, the report should incl…
-
Why is the content server not opening correct document for maintenance work definition attachment?Summary: In the Manage Maintenance Work Definitions screen, each maintenance work definition code has an operation with an attachment. This is the .txt file that contain…
-
Recommended approach for data warehouse extract from Fusion FinancialsSummary: We have implemented Oracle Cloud/Fusion Payables and Procurement modules. We have built custom data models and reports to extract data from Fusion and deliver t… -
How can we obtain XML to build our reportSummary: We are trying to create a custom report that pulls data from an approval flow. In the previous SR it was recommended that the information is stored in XML. We a…
-
Best approach to create a report templateHi everyone, I’m seeking advice on the best approach to create a report template with the following requirements (Bi Pulisher report): Year-to-Date (YTD) totals Subtotal…
-
How can I grant "GL users" access to the seeded "Payables Trial Balance Report"?We have a requirement in which "GL users" can generate the seeded "Payables Trial Balance Report" on their own to expedite their tasks. How can we configure this in Orac… -
ERP Sofware Version and NameSummary: I need to include the ERP application name and version in a custom report. Does anyone know if this information can be queried? Specifically, I'm looking for th…
-
Why does tax_amt_funcl_curr field table zx_lines not match the amount FIELD in INVOICESSummary: Shouldn't tax_amt_funcl_curr field from table zx_lines match the amount in invoice- View accounting match. we are noticing few cents off for philippines tax_amt…
-
OTBI -Costing Receipt Accounting Real Time - Cost Source ReferenceSummary: OTBI -Costing Receipt Accounting Real Time - Cost Source Reference We would like to have the information as per the attached print screen Which is the cost elem…
-
CUPS Server Printer Setup in ERP BIPSummary: Hi Team, we have below requirement and need to understand. Can some one please help on this. The print server has been installed in Azure with the CUPS service …
-
Digital Signature showing invalid for Adobe Acrobat ReaderSummary: Digital signature showing invalid when viewed in Adobe Acrobat Reader Content (please ensure you mask any confidential information): Digital Signature showing i…
-
previous parameter coming in the View attribute column of the next parameterSummary: Previous parameter names come in the View attribute column of the next parameter , Attached screen shot shows the issue Content (pl ease ensure you mask any con…
-
ESS Job to default the output to Email address when submitting the job on demandSummary: Hello ! We have a BI report as an ESS Job, the requirement is to default the email address and the subject and the BI report output (XLS) in this case needs to … -
How to retrieve Custom Child Object and Custom Field in BI PublisherSummary: Hi, Would like to check how do I retrieve Custom Child Object and Custom Fields in BI Publisher? For example, under the SCM»Innovation Management»Proposal - I h… -
Does the purpose of Cloud Collections related columns in AR Payment Schedule align with EBS R12Summary: We have a custom report running in EBS R12 that we are looking to port to erpCloud. The R12 report references columns: AR_PAYMENT_SCHEDULES_ALL.STAGED_DUNNING_L…
-
Unable to access OTBI dashboard for Procurement - PurchasingSummary: An user can not access to a dashboard for Procurement - Purchasing on OTBI, the user has assigned the purchase analysis role Other user with te same role can ac…