Category 129
Discussion List
-
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 14 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 15 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 198 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 14 views 2 comments 0 points Most recent by Ashish_Jain -Oracle Reporting and Analytics for ERP
-
Help in connecting the table FND_FLEX_VALUES_VL with one of the HR tables in HCM.Summary: Greetings, i need some help in connecting the table FND_FLEX_VALUES_VL with one of the HR tables in HCM. Content (please ensure you mask any confidential inform…
-
Role/Privelege for Explain Plan from SQL Query on data modelOne of our Reporting analyst user is getting an error that occurs when attempting to generate an Explain Plan from a SQL query on his reports. "Error Msg = ORA-01039: in…Vijay Ramani VJ 123 views 4 comments 0 points Most recent by Vijay Ramani VJ Reporting and Analytics for ERP
-
Line Number and RA Document Line Number has different values in rcv_shipment_linesSummary: Line Number and RA Document Line Number has different values in rcv_shipment_lines Content (please ensure you mask any confidential information): Hello, We are …
-
How to query the latest pdf contract from purchase agreements after a change orderSummary: Content (please ensure you mask any confidential information): Hi Everyone, I currently have a query where I am selecting the Contract Number, Description, Star…Steph96 13 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Dashboard access and rolesSummary: To start with, big thanks to all who reply. So went live with Fusion on January 2024. I have put together a dashboard using "Receiving - Purchase Receipts Real …Than0s 38 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Calling Sub template -IssueSummary: calling Subtemplate from main template is working fine for one user and is giving error from another user. Content (required): We have created a custom job to r…
-
how to link to tables AP_INVOICES_ALL and POZ_SUPPLIER_REGISTRATIONS ?????Summary: i try to create bi publisher report ( report aging supplier ) i want to select supplier name and supplier number how i can ? Content (please ensure you mask any…User_L42D8 50 views 5 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
How to Stop Duplication of Billed Amount in AnalysisSummary: I am attempting to build a report which will combine corporate card data and expenses data. The goal is to track corporate card transactions to the expense repo…Ashley Dore 18 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Missing PJF Tables/Views (i.e PJF_TASKS_V) In BICC PVO Data Lineage RepositorySummary: Hi Team, We need to extract data from Oracle and send it to our downstream systems. We're using BICC for this data extraction process. Our current challenge is …
-
Advanced Search hyperlink within LOV for VBCS screenSummary: We have a requirement to open advanced search screen from VBCS Screen LOV similar to oracle fusion standard screen. Is it possible to add hyperlink within LOV? …Sumit Sengupta 24 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Project Management
-
BICC Mapping documentSummary: HI Team Please provide me the latest BICC View Object Mapping Sheet link Content (please ensure you mask any confidential information): Version (include the ver…SYARABOLU 31 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
How to get size of file running in ESS jobSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…joelroshan92 5 views 2 comments 0 points Most recent by joelroshan92 Reporting and Analytics for ERP
-
Unusual behavior of OTBI report -Not displaying 'invoice amount' and 'discountable amount'Hi Team, We have OTBI report which displays invoice discount information. After 24A we are observing it is not displaying 'invoice amount' and 'discountable amount' for …Kalpesh Salunke-Oracle 27 views 6 comments 0 points Most recent by Kalpesh Salunke-Oracle Reporting and Analytics for ERP
-
What Information is stored in faw_db_sql_pjclabordisttxndetails FAW Table?Summary: What Information is stored in faw_db_sql_pjclabordisttxndetails FAW Table? What is the use of this table in FAW? Content (required): MAYO Clinic Version (includ… -
Does anyone have a Procurement Purchase Order dashboard they could share?Summary: Wondering if anyone has a (more recent) Procurement / Purchase Orders OTBI Dashboard they could share. Content (please ensure you mask any confidential informat…Greg Aulson 14 views 1 comment 0 points Most recent by Bharat Agrawal Reporting and Analytics for ERP
-
Unable to access attachments uploaded in workflow notification via hyperlinkAttachements uploaded in "Account Coding Workflow Notification" are getting saved as a content in BLOB column of a table rather than storing it as file in UCM. Hence it …
-
How do I see all scheduled recurring jobs & detailsI have come into a situation where folks have been allowed to schedule recurring jobs under their own IDs. This creates a handful of issues (in my mind at least): No one…Matt Mossman 302 views 12 comments 1 point Most recent by Bharat Agrawal Reporting and Analytics for ERP
-
Analysis to retrieve total element amount per month and yearly trendSummary: Good afternoon, I'm trying to build an analysis to get the total amount of elements (e.g., variable pay) + salary that is valid in a specific month in some coun…ammiano 24 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
how to store the manual input parameter values for multiple session in BIP report.Summary: User wants to run the BIP report with same input parameter values again and again and our report has around 20 manual input parameters. So is there any workarou…Gaurav Paliwal 12 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
can we audit Allowed Email Recipient DomainsSummary: Auditing Allowed Email Recipient Domains Content (please ensure you mask any confidential information): A change has been made in one of our test systems to the…
-
SQL Query to get Transaction column from Review Completed Transactions Page for intransit shipmentSummary: I want SQL query to transaction, serial number from get reviewed completed transaction data for Intransit shipment transaction type. Content (please ensure you …Latha00 830 views 5 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
How to link Account Receivables (AR) module with Costing to get item cost for an invoice lineSummary: Hello Which table should I use/link with 'RA_CUSTOMER_TRX_LINES_ALL' to get the cost price of an invoice line in AR? Content (please ensure you mask any confide…Varun Dhondea 109 views 3 comments 0 points Most recent by Syed_Ibrahim Reporting and Analytics for ERP -
BI publisher nested group issueI have an rtf template in BI Publisher where I want to show all rows of data within a repeating group. My problem is, I need to do this outside of the end of the group, …