BI Publisher
Discussion List
-
Deeplink to Inquire on Detail BalancesSummary: We want to link from a BI Publisher and OTBI Report directly on the Inquire on Detail Balances Page with filled out parameters. It should be the same like it is…Yves Chassein 21 views 1 comment 0 points Most recent by Julien_Dubouis General Ledger & Intercompany -
24C New BIP report Journal and Transaction Details Report Unable to Select From & To Period ParameteSummary: 24C New BIP Report: Journal and Transaction Details Report: Unable to Select From & To Period Parameters Content (please ensure you mask any confidential inform… -
whats argument2 in Load Interface File for ImportSummary: whats argument2 in Load Interface File for Import Content (please ensure you mask any confidential information): Im trying to submit Load Interface File for Imp…Jaeyshree Kumaran Kalpana 11 views 1 comment 0 points Most recent by Pooja Asthana-Oracle General Ledger & Intercompany
-
BI Publisher - Object_version_number column in gl_je_headers tableDear All, After creating a journal manually, the object_version_number in gl_je_headers is set directly to the value 3. Can anyone tell me what the purpose of this colum…George Mattar 11 views 1 comment 0 points Most recent by Uddipta Bhaumik-Oracle General Ledger & Intercompany
-
Can we Display Rejection reason via Notification to user if Journal is auto rejectedHi Team, We have configured the Journal auto-rejection rule if the Attachment or Journal description is missing at the Journal Header level. When a journal is rejected, …Ashwini Naik 189 views 4 comments 0 points Most recent by Ravi Kanth Vuddagiri General Ledger & Intercompany
-
security setup sensitive dataSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…SRIDHAR KAREGOWDRA 1 view 1 comment 0 points Most recent by Sharada Beleramane-Oracle General Ledger & Intercompany
-
OTBI report/Dashboard on User ,Roles, Sox ViolationSummary: Do we have any reports/dashboards on User, Roles and Sox (Sarbanes-Oxley Act compliance) violation available in Customer Connect or in Oracle Thanks in Advance …
-
In which table can we find Reserve for Encumbrance Account value ?Summary: Im looking for the table where is stored the code combination (code_combination_id) of "Reserve for Encumbrance Account" Content (please ensure you mask any con…
-
GL Journal Lines reporting for Mexico's Electronic Invoice UUIDSummary: I have a requirement to store Mexico's electronic invoice number (aka UUID) at the GL Journal Lines level. The UUID is being passed from Oracle Cloud Payables t… -
How to view and modify code in header RTF template without breaking the outputSummary: Hello, good day! Is there a way to view and edit the whole code in header of the RTF template? We have this bunch of code in the header of the RTF template and …Ralph Aldrich Magno 11 views 4 comments 0 points Most recent by Rickell Muir Receivables & Collections
-
Lineage document comparing PeopleSoft tables with Oracle Fusion tablesSummary: We need to migrate PeopleSoft Finance and HCM tables/fields to Oracle Fusion Financials and HCM. Could you please provide the lineage document comparing PeopleS…
-
General Ledger Journal and Subledger Transaction Mapping ReportIt looks like Oracle has provided this report for China localization only, we have a similar requirement for US operations, is it possible to run this report for Non Chi… -
How the translation tokens works ?Summary: Hello, I have two learning use cases regarding token translation that I'd like to share with you and understand. Both are kind of close, the only difference is … -
Report of 'Corrected Import Journals Errors'?Summary: We're looking for a report that shows us all interfaced journals that have been manually 'corrected' - is there a seeded Scheduled Process or OTBI report in Ora… -
Does DEFAULT_EFFECTIVE_DATE column in GL_JE_HEADERS table includes adj dateWhen we run a report with accounting period from Jan 31 to December 31, 2024. Will the report includes adjusting entries posted on 13_Dec-2024 adj period? The accounting…
-
I am in search of a GL Transaction Detail query in SQLSummary: I am in search of a GL Transaction Detail query in SQL Content (please ensure you mask any confidential information): I need the SQL code so I can modify if nee…Mike.Myers.CDIPRODUCTS.COM 21 views 3 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
How to Extract Chart of Accounts Values and HierarchiesSummary How to Extract Chart of Accounts Values and HierarchiesContent Hi I would just like to inquire if there is a standard report (OTBI), program or an API that can e…JOHANN CHRISTIAN MORDENO 784 views 9 comments 4 points Most recent by Truptesh Solanki General Ledger & Intercompany
-
What is the link between batch name and ESS job Import Journals ?Hello, We need to query the details of a journal batch (Batch name) with the schedule process (ESS Job 'Import Journals') that created that journal batch. We obtain the …
-
Hi all, does anyone know how to calculate the prior fiscal year to date using bi publisher data modeSummary: Content (please ensure you mask any confidential information): I am aware the I can use FRS, but I am being pushed to use BI publisher. My question is, do you g… -
How to refresh data in GL_FRC_REPORTS_BWe have requirement to fetch all the report details from given instance. Table Name : GL_FRC_REPORTS_B ( this table doesn't contain the updated data) What are the steps …
-
Extract Layout Templates in ReportSummary: Hi, Is there a way to extract the details of Layout Templates in a Report? The client wants to extract all layout details of their reports as Excel for their re…Ralph Aldrich Magno 11 views 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany
-
getting duplicate seniority dates in OTBI report FusionSummary: Oracle Fusion OTBI report is there giving duplicate records for one of the employee. It showing two seniority date records out of it we need earliest seniority …
-
Action Taken Table/Field under Manage Accounting ErrorsSummary: Hello Colleagues, Good day! With regards to Manage Accounting Errors, do we have a table/field that contains the Action taken? I tried to search all tables and …Ralph Aldrich Magno 62 views 4 comments 0 points Most recent by Ralph Aldrich Magno General Ledger & Intercompany
-
Impact of Member Name Path when a Tree includes multiple versionsSummary: Impact of Member Name Path when a Tree includes multiple versions Content (please ensure you mask any confidential information): We have a tree that includes on…
-
Is there a way to bulk enabling DFFs instead of one by oneSummary:We have many DFF that will need to enable for BI. Looking for a faster way to enable all at once instead of doing it one by one. Content (please ensure you mask …
-
Get Expenditure item date from back end tablesSummary: Please advise how we can get Expenditure Item Date and Expenditure Type from back end tables. I have below query as of now it is giving result based on SYSDATE.…
-
How do we get Transaction counts by day or by week from modules AP,AR,GL,FA & CM from Oracle FusionSummary: We are looking for the Transaction counts of all the modules from Oracle Cloud Fusion by day or by week. Is there any default reports that can give these counts…Jaikar_Reddy 54 views 4 comments 0 points Most recent by Cezar M-Oracle General Ledger & Intercompany
-
OTBI Report analysisSummary: I have created mostly Reports development in Oracle BiPublisher. Where i used to show prompt input parameters in Reports and formatting easily with multiple gro…
-
Can we extract data from oracle fusion ERP using BICC and deliver it to SFTP serverSummary:Hello Folks, We wanted to know if it is possible to extract maximum data from fusion ERP using BICC and deliver it to SFTP server. Thank you. Content (required):…User_Y8ID8 132 views 2 comments 0 points Most recent by Wouter Volbeda General Ledger & Intercompany