BI Publisher
Discussion List
-
unable to find the table which stores the approver details for fusion bpm nor rest api, please helpSummary: Hi Experts We are unable to find REST API or fusion table to extract the approval rules and the approver details. Below is the more details Would like to extrac…zakir112443 73 views 1 comment 0 points Most recent by Pradeep Kumar Reddy V Reporting and Analytics for HCM -
Include min function in value setSummary: Content (please ensure you mask any confidential information): Hello experts, I should manage the attached query in a value set. However in the VALUE COLUMN NAM…Valerio Curzi 43 views 11 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
To identify last modification details in Item Master , Item Locator and SubinventorySummary: We want to identify last modification details in Item Master , Item Locator and Sub inventory other than the 'last update date' , 'creation date', 'last updated…PrerakKhandelwal 31 views 0 comments 0 points Started by PrerakKhandelwal Reporting and Analytics for ERP -
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 116 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