BI Publisher
Discussion List
-
Automating AGIS Invoices creation processHi Team We are trying to automate AGIS Invoices creation.OIC triggers the Transfer Intercompany Transactions to receivables.And after its trigerred we have created the B…Sowbhagya B 43 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany -
how to find is there any attachment with the anytime feedback?Summary: need to find whether a attachment is there or not with anytime feedback Content (please ensure you mask any confidential information): Version (include the vers… -
Assistance Required: Locating PVOs for ar_batch_sources_all and ar_credit_memo_amounts Table in BICCSummary: I am currently working on extracting BIP tables from BICC to UCM, but I am unable to locate the tables ar_batch_sources_all and ar_credit_memo_amounts within th…
-
Locating PVOs and Data Stores for ar_batch_sources_all and ar_credit_memo_amounts Tables in BICCSummary: I am currently working on extracting BIP tables from BICC to UCM, but I am unable to locate the tables ar_batch_sources_all and ar_credit_memo_amounts within th…
-
Tracing bursting processSummary: We are currently sending mails to customers through the bursting process. Could you please confirm if it is possible to trace, from the backend, the details of …
-
Edit template and add new column in the existing excel templateSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Santhosh M-Oracle 1 view 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Worker HDL Error A primary assignment already exists.Summary: We are trying to load worker data with historical Data in Dev1. We are getting this error(A primary assignment already exists.)for lot of inactive employees. We…Krishna Manmohan 115 views 3 comments 0 points Most recent by SarthakRohilla Reporting and Analytics for HCM -
Query to retrieve list of bi publisher jobs in oracle fusion.Summary: Hello Team, Could you please help in providing the query to show all the scheduled jobs from BI publisher page. Content (please ensure you mask any confidential…Srushti Dhote 33 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Query to find the approver name for AP invoicesWhat is the query or table name where we can find the approver name and approval date(action date) for an AP invoice. The table ap_inv_aprvl_hist_all gives the approver …KanikaGupta 6.3K views 4 comments 2 points Most recent by User_QTQ8P Payables, Payments & Cash Management
-
When Downloading the General Ledger Accounts Detail Report in CSV format - Date Format IssueOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Dallas Fort Worth International Airpo…Sai Kumar Bhanumukkula -Oracle 41 views 0 comments 5 points Started by Sai Kumar Bhanumukkula -Oracle General Ledger & Intercompany
-
The Conversion Rate Tolerance for user rate TypeSummary: Is there any Feature to Validate the User Conversion Rate entered by the user. Ex: Corporate: 3.673 Tolerance: 1% User: 3.764 (System Should through an warning …Rama Mohan ReddyB 21 views 3 comments 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
Restricting Person Type LOV on Line Manager Dashboard Without CustomizationWe are currently exploring options to restrict certain values from the Person Type LOV that appears on the Line Manager Dashboard. Since the Person Type Lookup is a syst…Shubham Kadam 11 views 3 comments 0 points Most recent by Shubham Kadam Reporting and Analytics for ERP
-
Adding BI report dates prompt to dashboardSummary: Adding BI report dates prompt to dashboard Content (please ensure you mask any confidential information): Hi, I've a BI report which pull event data between two…Bhavna-Civeo 11 views 4 comments 0 points Most recent by Bhavna-Civeo Reporting and Analytics for HCM
-
Financial Tax Register Report Region Wise ESS JobSummary Ability to have a Custom ESS Job for Financial Tax Register Report to associate custom FTR reportContent Hello All, We modified the standard Financial Tax regist…
-
Tax Register and Financial Tax Register did anyone ever customize this report?Summary: Tax Register and Financial Tax Register did anyone of us ever customize this report? Just to confirm if it possible which seems ok to me as data model is there … -
RTF Template File Size Limitation in OLC CertificationHi Team, In the Oracle Learning Cloud (OLC) module, I’ve created an RTF template for course certifications. The template includes six different certificates for six diff…
-
Renamed position reportSummary: Hi, We have a requirement to report on changes to employees positions, which is fine but we have an issue when the Position name itself has been updated and the… -
Required table for the Payment Method Preferences in PayrollSummary: Hi, Could you please let us know the table where the information of Payment Method preference stored for Payroll module. PAY_ORG_PAY_METHODS_VL has no informati…
-
How to embed Logo/Images in BI Publisher RTF Template in RTF Output formatSummary: How to embed Logo/Images in BI Publisher RTF Template in RTF Output format Need to Embed Logo in RTF output format for BI reports Template. Content (required): …Bala Kasineedi 354 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Need to make dynamic file name in BIP reportWe have a requirement to place the BIP report to SFTP server , file name should be dynamic as 'Filename_(sysdate-15)_(sysdate-3)'. I tried to make the filename as Filena…Anjali_Kumari4121 164 views 4 comments 0 points Most recent by Eveve Reporting and Analytics for HCM
-
Unable to find error details in interface table GL_SEGMENT_VALUES_INTERFACESummary: Hi Experts, Could anyone please provide the details for 'GL_SEGMENT_VALUES_INTERFACE' table. The import program 'Import Segment Values and Hierarchies' getting …Sai Krishna Chelikani 16 views 0 comments 0 points Started by Sai Krishna Chelikani General Ledger & Intercompany
-
Online Excel preview to view BIP report outputs instead of downloading the file?When getting a BIP Report output in Excel format, is it possible to preview it online (as in cases with PDF/CSV outputs) rather than having it downloaded to system and o…PrerakKhandelwal 31 views 0 comments 1 point Started by PrerakKhandelwal Reporting and Analytics for ERP
-
Seeded Process/Report/Data Model customizationSummary: Once we did customization of seeded Process/Report/Data Model, after applied any patch/upgrade then the customization changes will override. Content (please ens…
-
SQL for all roles and it's inherited roles for BIP.Summary: Hi, I have a requirement to create a BIP report to fetch the details of all Roles and its inherited roles. I have seen that it can be achieved by OTBI but can't…Sameer Khan 29 12 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
BIP Vs OTBI What is the practicality of moving BIP reports to OTBI?Summary: I am recommending that my client investigates the possibility of using OTBI in preference to BIP for their reports (including whether this is just for new repor… -
Table with error messages and warnings of Supplier Bank Accounts FBDI ImportContent Does anyone know if the error messages and warnings of the Supplier Bank Accounts FBDI Import are stored in a base table of which we can report through BI Publis…User_CR41D 858 views 8 comments 2 points Most recent by Ankit.K Payables, Payments & Cash Management
-
Table details for ESS_REQUEST_HISTORY and ESS_REQUEST_PROPERTYHi, Are ESS_REQUEST_HISTORY and ESS_REQUEST_PROPERTY database views? If yes then what are the tables using which these views are created or where can we find query of th…Ankit_Bhadja 12.9K views 16 comments 0 points Most recent by jpearceWSP Reporting and Analytics for ERP -
Can we access the file contents of UCM file in BIP Report?Content I have a requirement to read the contents of the file placed on UCM in BI Report and am struggling to find the right table for this purpose. In EBS there was a t…Sricharan Monigari 655 views 7 comments 1 point Most recent by Juhi Singh Reporting and Analytics for HCM -
Unable to fetch Enrollment Action time, Disclaimer status and Assigned date in a BI report.We need to retrieve the Action Time, Disclaimer Status, and Assigned Date fields from benefit enrollment records for a BI report. However, these columns do not appear to…