OTBI
Discussion List
-
accounting asset inquirySummary: Hello everyone, I am making a report from which I need to obtain the following value from the box in red. I can't find the table in which I can locate those val… -
QUERY PURCHASE ORDERS WITH RECEIPTSHello everyone, I require a query for a report in OTBI that allows me to reach those values (those in the red box) when I pass the purchase order number as a parameter.
-
Need to build report between Task and Call Report (created via Task Page)Summary: Created a Task > open Task Detail > Action > Create Call Report. So now we have Task and its linked call report. Now we want to create a BI Report which should …AMIT KUMAR YADAV 41 views 9 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
Report data size exceeds the maximum limit (524288000 bytes). Stopped processing.Summary: We were given a SQL query to pull journal entries for our auditors and it worked successfully for FY22. We tried to run the report again for 2023 and received t…hannah_barry 7.8K views 7 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
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 42 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Work Order(WO): Requisition is approved without approval.Summary Work Order(WO): Requisition is approved without approval.Content Hi all, Work Order(WO): Requisition is approved without approval. Thanks, Dev Thota. Version 19B -
How to develop a BIP / OTBI report to fetch details from VBCS pageSummary: Hi Team, We have a customized VBCS page for Inventory transactions. Our requirement is to develop a BIP / OTBI report to fetch details from the VBCS page. Is it…Dhilip Kumar P. 41 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
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 11 views 3 comments 0 points Most recent by ADOLFO GARCIA BARBA-Oracle Payables, Payments & Cash Management
-
Created a BIP report from subject area Payables-Payments Disbursement Real to concatenate columnsSummary: Created a BI publisher report using Subject area from Payables. There is no option to concatenate two or more columns. I need to concatenate the payee address f…PSehgal2388 11 views 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP
-
Report to get employee's default expense accountSummary: Hi, Can you please suggest if OTBI report is possible to develop to get employee's default expense account? If Not can you please share any SQL query which can …Ninja 919 views 3 comments 0 points Most recent by Aravindkumar Shah Reporting and Analytics for ERP -
Consolidated List of OTBI and BI Publisher Reports Posted (14 April 2015)Content The following is the list of published OTBI and BI Publisher reports between 10 December 2014 and 10 February 2015: * OTBI: Employee Salary and Performance Ratin…Julian Challenger-Oracle 298 views 3 comments 3 points Most recent by Ms_Oracle Reporting and Analytics for HCM -
OTBI Vacancy ReportSummary: Is there a way to report using Subject Area(s) all current employees and any requisitions and vacancies so we have one entire list? For example a report that sh…JHaden3 162 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…
-
How to configure Web Service Data Source Options in OTMSummary: I want to use Web service as a Data source in OTBI Content (please ensure you mask any confidential information): Hello, I am trying to paste the WSDL URL from … -
Veteran StatusSummary PER_PEOPLE_LEGISLATIVE_F ;PER_PERSON_LEGISLATIVE_DATA_LEG_DDF'Content Can someone please help on attribute mapping from the application screen(i.e Armed Forces S…User_2025-01-29-01-31-31-940 451 views 5 comments 0 points Most recent by User_UAM4F Reporting and Analytics for HCM -
Can you please help me to find parent reports for the below OTBI child reports?Can you please help me to find parent reports for the below OTBI child reports? Past Due Fulfillment Lines Report Sales Order E-mail Sales Order Line Status Update Sales…User_SIV20 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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…Arsen Guevara-CITCO 73 views 4 comments 0 points Most recent by JohnG Reporting and Analytics for ERP -
How to get original or first requisition approved dateHi! I need to get the first or original requisition approval date for a report. How do I get it? The field Requisition Approval Date shows the latest/recent approval dat…Jose Renato Salvador 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Create an OTBI report for quantitative questions in an EvaluationSummary: Content (please ensure you mask any confidential information): We use Sildo to gather feedback after Instructor Led training sessions. This is far from automate… -
Where is the Assignment Start Date in Learning Records Real Time subject area?I have an assignment that I can see in the UI has a start date of next year. This assignment is a result of a retraining cycle - a course they take yearly. In the Learni… -
Query to get sales order line level revision detailsSummary: Query to get sales order line level revision details Content (please ensure you mask any confidential information): Query to get sales order line level revision…
-
Is it possible to report on Number of Positions requested, approved, rejected, pending?Summary: I have a requirement to design a Dashboard designed to track the overall timeline to 'Hire an new employee' from the time the initial position is requested/amen…Antonio Moldovan 31 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…Sushan Peiris 1.2K views 2 comments 4 points Most recent by Shishir Dhone Reporting and Analytics for SCM
-
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…