Category 129
Discussion List
- 
             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 14 views 3 comments 0 points Most recent by Nathan CCC 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 14 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 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… 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 … 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. 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… 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 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 18 views 3 comments 0 points Most recent by Bhaskar Konar 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 18 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 196 views 2 comments 0 points Most recent by Steven Woods 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 196 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 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
- 
             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… 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 104 views 4 comments 0 points Most recent by Vijay Ramani VJ Reporting and Analytics for ERP 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 104 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 … 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 18 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM 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 18 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 33 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 33 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… 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 41 views 5 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP 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 41 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 12 views 1 comment 0 points Most recent by Bhaskar Konar 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 12 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 … 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 21 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Project Management 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 21 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 21 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP 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 21 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… 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…
- 
             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 21 views 6 comments 0 points Most recent by Kalpesh Salunke-Oracle 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 21 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… 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 11 views 1 comment 0 points Most recent by Bharat Agrawal Reporting and Analytics for ERP 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 11 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 … 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 248 views 12 comments 1 point Most recent by Bharat Agrawal Reporting and Analytics for ERP 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 248 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 22 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM 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 22 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 11 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP 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 11 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… 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…