BI Publisher
Discussion List
-
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.7K 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 135 views 11 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
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 44 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 36 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 62 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 33 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 36 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 37 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 32 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 42 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 7 views 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 40 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 14 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…
-
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…
-
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 36 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 17 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 26 views 2 comments 0 points Most recent by Sreedhar Elagandula Reporting and Analytics for ERP
-
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 29 views 1 comment 0 points Most recent by Gary Wan Guanghui Reporting and Analytics for ERP
-
need to fetch the timestamp when Invoice status changes to Approved at summary levelSummary: for every invoice, when clicked on 'Validate' it will kick a process in the backend "Validate Invoices" which will change the status of Invoice to Validated nee…Anjali Sidharthan 16 views 1 comment 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
Burst to multiple email addresses stored in a parameterSummary: Burst to multiple email addresses stored in a parameter Content (please ensure you mask any confidential information): I would like to have Bursting to multiple…
-
Unable to proceed to create Dataset using webservice in Oracle BIP ReportSummary: Unable to create dataset with Webservice while creating custom BIP report Content (please ensure you mask any confidential information): below are the steps to …SireeshaJaladi 123 views 6 comments 1 point Most recent by Sri Prasanth Reporting and Analytics for ERP
-
Missing Columns in BICC PVO but columns available in the underlying Oracle database tablesSummary: While analyzing the BICC Object Views for sending the data to Traget System—similar to the BIP extracts—for the following three Oracle tables, I noticed that so…Anshul Bansal 60 views 1 comment 0 points Most recent by Sai Revanth Reporting and Analytics for ERP
-
Need to see supplier full account numberSummary: Is there any standard report in oracle we can leverage to see the full account number of Supplier. Could you please confirm? Content (please ensure you mask any…