BI Publisher
Discussion List
-
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 64 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 22 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 193 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 32 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 34 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 25 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 314 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… -
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 21 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…