BI Publisher
Discussion List
-
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 18 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
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 7 views 0 comments 0 points Started by Keerthana Sekar 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.Abdur Rehman 180 views 3 comments 0 points Most recent by erp_expert03 General Ledger & Intercompany
-
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 55 views 3 comments 0 points Most recent by Swapnil Kashid General Ledger & Intercompany
-
Error 500--Internal Server ErrorSummary: Error 500--Internal Server Error From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1: 10.5.1 500 Internal Server Error The server encountered an unexpected co…
-
how to fetch entered balancesSQL Query to identify Entered balances in Oracle Fusion tables.Suvodeep_Saha_98 11 views 0 comments 0 points Started by Suvodeep_Saha_98 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…
-
Turkey E-ledger requirementSummary: Hello Team, Our customer requires Turkey E-Ledger report to be developed as part of Turkey Localization. Please check and let us know if we have any out of box …Narayanan M S-Oracle 1 view 0 comments 0 points Started by Narayanan M S-Oracle General Ledger & Intercompany
-
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… -
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…
-
Print Receivables Transactions not sending print job to printerSummary: Print Receivables Transactions process creates output but it is not being printed. Content (please ensure you mask any confidential information): When we run th… -
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 11 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 12 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
journals accounting date tableDear All, Can anyone tell me where's the accounting date of the journal is stocked? I queried date_created column in the GL_JE_HEADERS table, but I noticed that I am obt…
-
Difference between Date_created column and creation_date column in GL_INTERFACE TableSummary: Difference between Date_created column and creation_date column in GL_INTERFACE Table. Name Datatype Comments CREATION_DATE TIMESTAMP Who column: date and time …User_PZTF9 21 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 25 views 2 comments 0 points Most recent by Robert of STAU General Ledger & Intercompany
-
how to invoke ESS Job Set from webservicesSummary: Trying to use SOAP WSDL and submitESSJobRequest Service. I am able to submit ESS Job but While submitting Job Set I am not able to.Please throw some lights arou…Aditi Agrawal2650 22 views 1 comment 0 points Most recent by veerendranath pulivarthi-Oracle 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 24 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 183 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