Category 129
Discussion List
-
Where can I find the Payment Number for Payables on OTBISummary: I'm trying to pull together a report listing payments made to suppliers and need to include the the Payment Reference Number (i.e. the cheque, payable order (PO… -
IN OTBI How to display the data as per user preferred time zone and dynamically add GMT /- ?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Manoj Vasa 21 views 2 comments 0 points Most recent by Kadiri Prathusha Reporting and Analytics for ERP
-
I did customize a standard notification. But the change i did was not appreadSummary: PO notification Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any…S.A.A Dinoli 21 views 5 comments 0 points Most recent by S.A.A Dinoli Reporting and Analytics for ERP -
Add "Cost Element Type" in OTBI Report "Costing - Period Inventory Valuarion Real Time" subject areaHi, I've created a report in OTBI to detail the On Hand valuation information. We are using the new subjet area "Costing - Period Inventory Valuation Real Time". We need…Sebastián Bach 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How to read a tab delimited data using querySummary: I have a text file which have data separated by tab. I need to split that into multiple columns. How i can write a query to achieve this. any idea please. Conte…
-
Sql query issueHi All, We have a sql query. Now we have a requirement to add a condition so that employees with AEI_ATTRIBUTE4 from PER_ASSIGNMENT_EXTRA_INFO_M table is NULL, should sh…Dona Das-Oracle 21 views 3 comments 0 points Most recent by Dona Das-Oracle Reporting and Analytics for ERP
-
How to enable external directory in Oracle FRS schedulerSummary: How to enable external directory in Oracle FRS scheduler Content (required): We want to be able to send the output of FRS using a batch scheduler on an external…
-
How to create drill down charts in Oracle BI Publisher (BIP) Reports?Summary: How to create an interactive or drill down charts in BIP reports, where clicking on a chart updates the data in other charts and tables? Content (please ensure …
-
In which Subject Area can I found the end date of an account.Hello, I am trying to bring the value of the End date of a GL account in an OTBI report . This value can be inputted in Manage chart of accounts value set values feature…Vlad CONSTANTIN 11 views 2 comments 0 points Most recent by Vlad CONSTANTIN Reporting and Analytics for ERP
-
"Check Digits" on a Supplier Bank Account Record in BIP SQL TABLE locationHi Guys Does anyone know please which BIP table contains the field "Check Digits" for a supplier bank account? I need to get the checkdigits field for a supplier bank ac…
-
Populating xcc_balances table - requesting more informationSummary: Hello, Our BI report which shows the budget amounts for our accounts is missing a certain account for specific periods. It looks like the period names are missi…
-
How to query the emirate in Customer Account Site addressHello, We are currently creating a Customer report, and we need to retrieve the Emirate under the Customer Account site address. From which table and what field can this…Kristelle 11 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
Is is possible to create an audit report that has all FRS BIP and OTBI reports?Summary: Is there a way to get details of report along with the last run date individually (individual report for each areas) for reports & analysis - in OTBI and a Fina…Soare Oldrich Alexandru-Oracle 21 views 4 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Error generating view. Error getting cursor in GenerateHeadSummary: We are stuck with this error: I have executed these processes: Publish Chart of Account Dimension Members and Hierarchies to Balances Cubes Create Rules XML Fil…Bo Tøpgaard 295 views 6 comments 0 points Most recent by Neha D-Oracle Reporting and Analytics for ERP
-
Why do I get an SQL timeout limit error now, after the 23C upgrade?Summary: SQL timeout value limit error Content (required): Hi, We have a custom BI report, with an explicit SQL timeout value limit specified in the datamodel properties… -
XLAFSNAPRPT job nameHi, I need to find the job name (ex: for XLAFSNAPRPT, job name is Create Accounting). Is there any table that store this information or it is only MetaData (xml) ? Thank…M. Tonghioiu 77 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Backend tables or SQL query to know "Manage Enterprise Scheduler Job Definitions"Summary: Hi Team, We are unable to find the tables or SQL query to get the data under the task "Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, S…
-
Is it possible to store both US and Local Legal Entity Identifiers in Oracle?Summary: Our business team would like to know if it's possible to store multiple registration numbers for an Entity in Oracle. Content (please ensure you mask any confid…Tina Valtchev 11 views 1 comment 0 points Most recent by Julien_Dubouis Reporting and Analytics for ERP -
Set BIP folder/report permissions by RoleSummary: I'm trying to set the permissions on a folder in Reports & Analytics based on Application Role. The specific role I want to use doesn't appear in the list of va…Lisa D 31 views 4 comments 1 point Most recent by Antariksh Kar-Oracle Reporting and Analytics for ERP
-
Report to show Document Types enabled for B2B Communication for each Supplier and its Supplier SitesSummary: Under OTBI subject area "Supplier - Supplier Real Time", I am unable to find and add Associated Collaboration Documents for each Supplier Site. I can only add w…Ruthvik Ramesh-IH 13 views 6 comments 0 points Most recent by Ruthvik Ramesh-IH Reporting and Analytics for ERP
-
Lead times reportsSummary: The client is asking me for two reports, and I can't find anything standard. Could you confirm for me? The reports are: Standard report that evaluates the agree…Santiago Fazio 11 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
scheduled proccessess in Fusion: need to fetch data for 2023 yearSummary: I have a request to provide a list of all processes which were executed in the Fusion system in 2023y Cotent (please ensure you mask any confidential informatio…Ann Djiyanova 21 views 4 comments 0 points Most recent by Stephen Westerfield-Oracle Reporting and Analytics for ERP -
OTBI Dashboard not reflecting the analysis dataSummary: When certain parameters are used in a dashboard, a couple columns return null values. The raw analysis does include data for these columns. This just started oc…
-
Error detail information in import journal execution reportSummary: In the process of creating a custom report for import journal execution report, we are unable to fetch the data for error status. We are able to fetch data for …
-
How to set parameter in BICC job payload from SOAP UI to set the extract date ?We are calling BICC job from OIC for a particular PVO ,it gives us incremental data every time. Is there a process to reset it to full extract in every run. -
TOOLS > audit reports - ORACLE PLATFORM SS > ADD/REMOVE ROLE MEMBERSHIPHI THERE am I Missing something? how useless are the reports without a User ID!?!? the reports tells us who removed what role and when but WHO.. SURELY the most importan…
-
Can I change the default attributes of a BICC extraxt file stored in UCM?Summary: I'm creating 2 extracts of BICC sourced from the same PVO for 2 different purposes, this is creating files with the same name. I need to download the files and …Octavio Aguirre 11 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Termination count is not showing correctly in OTBI reportSummary: Termination count is not showing correctly in OTBI report Content (please ensure you mask any confidential information): Hi All, We are developing a HR dashboar…Venkatesan 11 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Is there a definitive date that Financial Reporting Web Studio will be discontinued?We were informed that Financial Reporting Web Studio will be shutting down at some point in 2024. Is that accurate? Is there a date set for discontinuing FRS?Steven Woods 191 views 2 comments 0 points Most recent by Steven Woods Reporting and Analytics for ERP
-
Fin and SCM list views oracle BIPHI Team We need the Secure list views in Oracle ERP SCM and FIN modules as we need to use them in developing the custom BIP's. Regards PraveenPraveen Kumar P 11 views 2 comments 0 points Most recent by Ashish_Jain -Oracle Reporting and Analytics for ERP