BI Publisher
Discussion List
-
Joining GL with subledger, description repeatingI have the below SQL query and it runs and amounts are as expected. My issue is that when looking at a project journal the line description is repeating and it's not dis…Sean-B-01 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Some of the PDF attachments not appearing on printed AR Invoice in Print Receivables TransactionsHi Team, We are facing an issue where attachments in receivables transactions are not consistently getting attached or sometimes dropped during the printing of the invoi…
-
Table for ESS Job scheduleSummary What is the table name in Oracle Cloud which stores the Schedule of an ESS JobContent Is there a table name or query which I can use for fetching the frequency, …Shubhojit Purkait 1.4K views 11 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Assets - The following segment labels have misspelled BI Object Name setSummary: Hi What are correct spelled BI Object Name set for Assets. I have hit the following error: Regards, Bo Content (please ensure you mask any confidential informat…
-
View PDF Option is not working for some Cancelled PO in fusion.Hi Experts! Recently we are facing an issue with view pdf option in fusion. Case: It is working for PO s which are not cancelled. Its working for some Cancelled POs. But…Mainur-Oracle 113 views 11 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
Sending remittance advice email limitSummary: we are a government department and are now paying a large volume of grant payments. this means an increase to the number of payments and therefore remittance ad…
-
OTBI - Issue while submitting Custom report - Asset Cost DetailSummary Error while selecting parameters for Custom OTBI report which was copied from Asset Cost Detail reportContent Error while selecting parameters for Custom OTBI re…User_2025-02-04-10-47-46-258 32 views 1 comment 0 points Most recent by Priya_Ananda Reporting and Analytics for ERP -
Change database timezone?Hello Gurus, I understand that data in Oracle Fusion tables are being stored in UTC timezone. Can that be updated to timezone per Organization's choice? If yes what can …Sheetal VBCS 12 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
ESS Job Report Output File NameSummary: After running the ESS job in Oracle Fusion 'Default Document', we can see the output name. Can we set this output name to reflect the order number or invoice nu…User_39SVE 47 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How to know who delete some reports in OTBIA folder containing reports has disappeared from my environment, and we want to know if it was accidentally deleted by a user or where the folder is located.Roy1823 14 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Any SOAP or REST calls available to see status of scheduled BIP reports?Hello Gurus, I am looking for SOAP/REST calls that can tell me whether the scheduled BIP report failed or succeeded. The navigation is Reports and Analytics → Home → Rep…Sheetal VBCS 24 views 2 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
Unwrap Text in BIP Report Panel LayoutSummary: Please let me know if anyone worked on below functionality. I have a BIP report that uses a template designed using Oracle Fusion Reports and Analytics. The rep…Bala Murali SV8 24 views 4 comments 0 points Most recent by Bala Murali SV8 Reporting and Analytics for ERP
-
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 21 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 31 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
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…
-
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
-
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 24 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
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 13 views 3 comments 0 points Most recent by Shubham Kadam Reporting and Analytics for ERP
-
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…
-
How to hide Common Content folder under Shared Folders on BIP Catalog pageSummary: Before the quaterly patch 25A, system did not show "Common Content" under Shared Folders on BIP Catalog page. But somehow system shows "Common Content" under Sh…Tomoyuki Hyakutake-Oracle 35 views 3 comments 1 point Most recent by Ilmars K. Reporting and Analytics for ERP
-
Unable to find the SQL joining for Event class and Mapping set in Oracle fusion Project to CostingSummary: Hi, We are unable to find the SQL joining Event class (XLA_EVENT_CLASSES_VL) and Mapping set (XLA_MAPPING_SETS_VL) in Oracle fusion Project to Costing. The inpu…
-
Audit tables for Project Tasks and Sub Tasks in Oracle fusion cloud and policies to enableHi, Are there any Audit tables for Project Tasks and Sub Tasks related in Oracle fusion cloud to create a BI publisher report? I was able to enable the audit policies fo…sarathkumarkondadadi 26 views 0 comments 1 point Started by sarathkumarkondadadi Reporting and Analytics for ERP
-
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 11 views 0 comments 0 points Started by Sai Krishna Chelikani Reporting and Analytics for ERP
-
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
-
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
-
Multi Language in Single BI Publisher ReportHello Community, We are having a requirement to Generate Invoice Report such that for certain Provinces the report should show the invoice in two languages in single fil…Sreedhar Elagandula 12 views 2 comments 0 points Most recent by Sreedhar Elagandula Reporting and Analytics for ERP
-
How to embed logo or image in email body using email bursting querySummary: Need info on Parameter5 of email bursting query can be included with image file or Logo in it. We want company logo to be added along with email body .Please gu…
-
Need the joining table for Manage contract types columns buyer role and seller roleSummary: I need the joining for OKC_CONTRACT_TYPE_PARTIES for buyer role and seller role as I am getting whole data for the roles but I need to get only buyer and seller…
-
Query for Transaction Console transactionsSummary: Query for Transaction Console transactions Content (required): I am looking to write a query that contains the below information from the Transaction Console, r…
-
pasteItem2Summary: Which value of flagACL I should use to correspond to the ACL option 'Create'? Content (please ensure you mask any confidential information): Unarchive the BIP c…Gary Wan Guanghui 22 views 1 comment 0 points Most recent by Gary Wan Guanghui Reporting and Analytics for ERP