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
-
Accounts Receivable Reconciliation ReportContent Hello, I am looking to build a reconciliation focusing on the Accounts receivable transactions, I want to show the number of Accounts Receivable transactions tha… -
Business Date calculation in BI PublisherSummary Business Date calculation in BI PublisherContent Hi, We have a requirement to populate settlement date in 'Disbursement Payment file' with following logic in BIP…
-
Fetch Data from Last run dateSummary Only get updates and creates after the previous run of the reportContent This is something I know can be done in hcm extract but I would like to knoe if at all i…Prateek Parasar - GTUK, ACE Pro 426 views 5 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro -
Prompt Variables Not Being PassedSummary Selections from Prompt variables are not passedContent I have a custom Subject Area/data set derived from a logical SQL query joining the existing subject areas,…
-
Logical SQL Error - OTBISummary When attempting to create a new Analysis using simple Logical SQLContent I am attempting to create a new analysis using the logical SQL below; however, whenever …
-
OTBI: Receivables - Transactions Real Time Subject AreaSummary OTBI: Receivables - Transactions Real Time Subject Area don't show collectionsContent I am trying to develop a report on this subject area to show the customer a…
-
PO and Invoice Amount - OTBISummary Need to show PO and Invoice Amount in a reportContent Hello - I have a requirement to show the Invoice Amount and PO Approved amount in the same report. I can se…
-
Convert SYSDATE to Mon-YY format in oracleSummary Convert SYSDATE to Mon-YY format in oracleContent Hi , Can you please suggest how to convert SYSDATE to Mon-YY format. Version 19B
-
OTBI-Parameter-DependentSummary OTBI-Parameter-DependentContent All-> Can we show the parameter values based on another parameter from OTBI? Example: Subject Area: General Ledger - Journals Rea…
-
Who can edit the report?Summary Who can edit the report?Content Can any user edit the OTBI reports or is that something that only the owner of the reports (for example : FASETUP) can edit the r…
-
OTBI Project Reporting - ForecastsSummary Unable to locate any measures that relate to past versions of forecasts in OTBIContent Hi, I am in then process of building an in-year expenditure/budget/forecas…
-
Manager Email AddressSummary I need to know how to add a field which includes manager's email addressesContent Using the Expense - Expense Transactions Real Time subject area, I need to add …
-
Schedule and distribute a report to specific usersSummary Schedule and distribute a report to specific usersContent Hello Friends, I need to schedule and distribute a report to specific users. I clicked the "More" optio…
-
Drill Down Facility in Reporting and AnalyticsContent Drill Down Facility required in Reporting and Analytics. can you please guide me about this task. -
PO interface error table getting auto purgeSummary after import PO ESS , Error table is not having error recordsContent Step 1 : Loading Data into interface table Step 2 : Calling Import PO program Step3 : Import… -
Process name not filled for bip job in 'scheduled processes'Summary Process name not filled for bip job report in 'scheduled processes'Content Hello, When we schedule bip report (manually or via web services), a process is execut…
-
Fusion table which store all Data Model SQL?Content Hi, Can anyone share Fusion table(s) which stores SQL's of all data models? Thanks, Rinku
-
Deep Link for AR Invoice creationSummary Deep Link for AR Invoice creationContent We were going through document 'Drill down from OTBI adhoc reports to Receivables' and there is Deep link for AR invoice…
-
How to create receivables invoice line apiContent Dear All, I want to create a receivable invoice line api. But i cant find a sample for that. i followed link which is mentioned in below but in this link i cant … -
Is that any possiblity to i will update me Oracle cloud tables dataContent Dear , Is that any possibility to update Oracle cloud tables data. or can i connect oracle database into sql developer in which i can update query. Thanks
-
How to generate and view the trace file for a BIP Report submitted thru ESS Job Scheduler.Summary How to generate and view the trace file for a BIP Report submitted thru ESS Job Scheduler.Content Can anyone guide us on how to generate and view the DB trace fi… -
How to have dashboard at My dashboard specific to userSummary How to have dashboard at My dashboard specific to userContent Users can be from different departments, we want to have user specific dashboard at My dashboard li…
-
Non - standard SQL data model bind to different templatesSummary Non - standard SQL data model bind to different templatesContent Hi there I was wondering if it was possible to bind a non-standard SQL query parameter to a Repo…
-
OTBI Create Analysis with columns for different account balancesSummary Making Account a Column with Account ValueContent Hello, Is it possible to create this type of report in OTBI (I'm not having any luck)? Balancing Segment accoun… -
Fusion Cloud AnalyticsSummary Fusion Cloud AnalyticsContent Hi -> Any one please let me know details about Oracle Cloud Analytics? Thanks,
-
Missing FolderSummary i missing custome folderContent Please help me to found my custom folder under share folder in custom Thanks -
Custom Groups in BIPSummary Need to create custom grouping of Accounts in BIPContent Hello - I have a requirement to show selected account attribute values from Account dimension in an expe…
-
Permissions or custom roles to view only OTBI or BIP reportsSummary I need to enable a SCM roles users to just display custom financial reports which created by using BI publisher or OTBI.Content I need to enable a SCM roles user…
-
Aging ReportSummary i'm not able to genrate back dated aging report in account recivableContent not be able to generate back dated ageing reports
-
OTBI HOW TO TURN MEASURE COLUMN INTO YTDSummary OTBI HOW TO TURN MEASURE COLUMN INTO YTDContent Hi Xavier, As per the below the YTD amount gets calculated from 1/Jan to till date. However we have requirment to…