To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fSummary List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fusionContent Hi, Is there any way to get the list of all the … -
BIP report output with 0 KB.Summary: We have a custom BIP report with a datamodel. The data could be seen when viewed in the data tab of the DM. When the report was ran in the BIP (using the schedu… -
Moved: Analysis to retrieve total element amount per month and yearly trendThis discussion has been moved. -
ISO Format for the positive pay templateSummary ISO Format for the positive pay templateContent Hello All, We got a requirement for the positive pay in the ISO format but as of now we have only an etext seeded… -
Moved: Pivot using Mulitiple groupsThis discussion has been moved.
-
-
Joining Subledger data with GL dataI need to build a query which joins subledger data table, xla_ae_lines to gl_je_lines. I am attempting this through gl_sl_link_id but the performance is awful, is there …
-
Moved: Supplier Recon reportThis discussion has been moved.
-
how to convert number in words in erpIn BIP report in cloud , we have to print one amount column in words. We have used the condition as below to convert it , but unfortunately it works upto one limit and l…
-
Performance impact while using standard viewsSummary: Is there any performance impact while using the standard views (in a BIP report) listed by Oracle. For eg. using standard view PJF_PROJECTS_ALL_VL, instead of t…
-
Moved: TOOLS > audit reports - ORACLE PLATFORM SS > ADD/REMOVE ROLE MEMBERSHIPThis discussion has been moved.
-
How to add below roles (ServiceDeveloper,BIACM_ADMIN,Image_Role) i don't see in those rolesHow to add below roles (ServiceDeveloper,BIACM_ADMIN,Image_Role) i don't see in those roles
-
Moved: Reporting on Approval Transactions outside HCMThis discussion has been moved. -
Unable to find Award Open and Close date, and Award Approval Date in OTBIHello, I am working on an OTBI report that requires the following fields: Award Approval Date Award Open Date Award Close Date I was unable to locate them in the Procure…
-
Can you use temporary tables in cloud fusion otbi?Summary: Can we use temporary tables in cloud OTBI as a replacement for multiple union select statements Content (please ensure you mask any confidential information): W…
-
How to get the IP address of OTBI to add to a SFTP whitelistI am trying to get my OTBI environments IP address so I can whitelist it on a SFTP site. I found documentation on all the IP address, but I don't know which server I am …
-
Moved: Connect Oracle HCM to AlteryxThis discussion has been moved.
-
How to add multiple formats while submitting ESS job?Hi, We have a requirement to send the output to the customer. We are able to send the output in PDF format without any issue. However; customer is looking for both PDF &…
-
BIP Global Level Function Data not getting included in output after bursting.Summary Aggregate functions data show's up at report level which are involved in GLOBAL Level functions, but the same Data attributes wont show up, if we burst the file.…
-
Unable to view the data in data model with lexical parameterSummary: Unable to view the data in data model with lexical parameter Content (please ensure you mask any confidential information): Hi, We are trying to create a BI rep…
-
What is the best way to prepare a consolidated Trial Balance of two business Units?Summary: What is the best way to prepare a consolidated Trial Balance of two business Units? Content (please ensure you mask any confidential information): There are man…
-
Generate blank BIP reportHi Team, We have a BIP report in Oracle fusion that has a bursting code. This works fine when there is data for report. However, if no data is returned by the underlying…
-
How to join from Subledger Accounting (XLA) to transaction application entity code PJBACCOUNTINGSummary: Hi, How do we join to get transaction details in the subledger application from XLA_TRANSACTION_ENTITIES where SOURCE_APPLICATION_ID = '10036' (Project Accounti… -
How to extact segment 2 from code_Combination_description in my xml fileSummary: How to extact segment 2 from code_Combination_description in my xml file Content (please ensure you mask any confidential information): My xml stores the code c…
-
Customization of 'Print Receivables Transactions' and 'Print Receivables Transactions: Invoices'Summary: Content (please ensure you mask any confidential information): Hi, This is regarding ESS Job 'Print Receivables Transactions' which in turn calls another ESS Jo…
-
Output tab when scheduling a processHello On some standard reports, they don't have Output tab when scheduling the process but some do. Anyone know if we can set the Output tab to display or this is what i…
-
How to go up from JELINE_ROW to CCID_S in my xml on my rtf templateSummary: Going up a level or two of my xml on my rtf template Content (please ensure you mask any confidential information): I have customised the Account Analysis rtf. …
-
Moved: BI Report Migration Not Captured in Audit LogThis discussion has been moved.
-
Subject Area to capture Employee detailsSummary: Content (required): Hi, Can someone please let me know the subject area to be used if the requirement is to capture the username, employee first name, employee …
-
CMK Message Processing RulesSummary: CMK Manage Message Processing Rules Description: We are working on Collaboration Messaging Framework process PO Inbound (EDI 850) to create sales order in Oracl…