BI Publisher
Discussion List
-
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 …
-
Finding corresponding entity§ion of an intercompany transaction that hits an entity & sectionHow to find the originating entity and section number of a transation that ends up in another entity and section in the General Ledger. Currently our ERP COA has Entity,…
-
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 61 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 25 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 219 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 11 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 42 views 1 comment 0 points Most recent by Julien_Dubouis General Ledger & Intercompany -
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 22 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 313 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 25 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…