BI Publisher
Discussion List
-
BIP Account query to get the rollup data in a a rowSummary: BIP Account query to get the rollup data in a a row Content (please ensure you mask any confidential information): Account 1 has rolled up to child 8, child 8 r…NarenInova 22 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Validate cross validation combination set in a BIP reportSummary: We have developed a BI Publisher report to validate the account combinations against the cross validation rules (CVR) using the PL/SQL API fnd_flex_ext.get_cvr_…
-
Deep link documentation for GL (and Financials)Summary: Where can we find the documentation for deep links for GL? Content (please ensure you mask any confidential information): Where is the detailed documentation fo…TyskJohan 289 views 4 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
General LedgerI' like to output the SEGMENT values (SEGMENT1~12) registered in GL that have an enabled flag of 'N', column by column. To achieve this with BIP, which table should I re…
-
GL Audit Trail Report not availableHi All, I am just trying to run the GL Audit Trail Report by below path, but report is not available. Steps to Search in BI Catalog: Go to Reports and Analytics > Browse…
-
how to fetch entered balancesSQL Query to identify Entered balances in Oracle Fusion tables.Suvodeep_Saha_98 11 views 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany
-
SQL Query for Journal entries details and APInvoice table joinSummary: Need help on SQL query for the Journal entry details and Invoice details Join together. In the below screen shot we need highlighted information. I have written…
-
How do I add location and brand segments to a Cost Summary report for fixed assets in Oracle Fusion?Summary: I would like to customize a seeded report found in Oracle Fusion by adding brand and location segments by updating the data model. Content (required): Version (…
-
Is there a way to get the latest data from the GL_FRC_REPORTS_B tableHi, I need to retrieve the latest data from the GL_FRC_REPORTS_B table. When I queried the table, the results did not match the expected original data. Could anyone assi…Keerthana Sekar 1 view 1 comment 0 points Most recent by Keerthana Sekar General Ledger & Intercompany
-
SQL Behind the package JEFR_JELINES_RPT_PKGWe are trying to write the custom SQL for creating a custom report, in order to fetch the details in BIP report. In order to achieve the same, could someone please assis…Mohd Saqib 31 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
sql query to find link between Intercompany Accounting and GLI want to know the tables and link between intercompany accounting and general ledger. I want to pick intercompany data in query. -
Can Export Bulk Data Option be used an alternative to BIP Anti PatternSummary: Export Bulk Data Option for fetching data asynchronously from ERP cloud, can this be used as an alternative to the BIP anti pattern of synchronously calling BI …
-
Custom BI ReportsSummary: Content (please ensure you mask any confidential information): Hi Team, I am currently working on creating a custom BI query, and I have come across an issue. W…Srushti Dhote 63 views 3 comments 0 points Most recent by Swapnil Kashid General Ledger & Intercompany -
What is the table storing Account Type?Summary: What is the table storing Account Type? Content (please ensure you mask any confidential information): Hi Experts, May I ask what is the table storing accountin…
-
fixed assets transaction tab amount details in fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
customize journal naming convention when transactions are imported through Fusion Accounting Hub.Summary: We need combination of accounting date, source, event type and Currency as an Journal name on front-end. i also followed some document there it was written that…
-
what are the tables where i can find project and its accouting detailsSummary: Hello , I want query or table names from which i can pick projects inofrmation of accounting like GL_date ,Account number,Account description. I am attaching th…
-
Unable to find Ending balance column in GL balance TableI am looking for a Ending balance for a particular account in gl_balances table. Is any other table contains this value ?
-
What are the possible statuses returned by an ESS Job in REST APISummary: Content (please ensure you mask any confidential information): I am submitting an ESS job and checking the status. I want to understand what are all the possibl…Jaeyshree K K 36 views 2 comments 0 points Most recent by Jaeyshree K K General Ledger & Intercompany
-
Fusion table for Journal import error codes and descriptionSummary: is there a table in fusion that stores the Journal import error code and description that we can see in Output file. Couldn't find anything in FND_LOOKUPS and G…Divya Mangtani 260 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
General Ledger Report - Cash BasisSummary: Hi Team, I would like to extract or build a custom report for General Ledger in oracle fusion with the below columns data. Required columns are: GL Date Transac…Sesha Sailini 13 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
oracle project subledger querySummary: I am trying to construct a query to subledger detail for Projects source, but find that the sql below does not return any detail for revenue, no data is returne…Robert of STAU 21 views 2 comments 0 points Most recent by Robert of STAU General Ledger & Intercompany
-
I need help setting up an account hierarchy to allow business users to view it in the cloud GLHello Support Community, I need help setting up "Account Hierarchy Management" to allow business users to view it in the cloud general ledger. Currently, they have acces…Prakash Vattapalli 31 views 3 comments 0 points Most recent by Rohan Kamat General Ledger & Intercompany
-
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 45 views 1 comment 0 points Most recent by Julien_Dubouis 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 13 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 334 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 2 views 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…NancyR_Bravo 100 views 2 comments 0 points Most recent by NancyR_Bravo General Ledger & Intercompany