BI Publisher
Discussion List
-
Table to get Natural Account segment hierarchy in Oracle FusionSummary: Looking for Table to get Natural Account segment hierarchy in Oracle Fusion Content (required): I am trying to retrieve GL balances using SQL query in data mode… -
Conversion RatesSummary: Conversion Rates Content (required): We have "MY IFRS Primary" Primary ledger ledger currency for this Primary ledger is "MYR" as we are creating a custom repor… -
Manage General Ledger Lookup Values - Seeded Export and ImportSummary: Manage General Ledger Lookup Values - Seeded Export and Import is not generating expected output. Need to design a custom report to generate output file similar…Rajeswari B 12 views 2 comments 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
What is the Logic behind "Average Balances Trial Balance Report"?Summary: What is the Logic behind "Average Balances Trial Balance Report", also looking "GL_TRIAL_BALANCE_AVG_RPT_PKG" package. Content (required): Logic for the calcula…Naushad15 32 views 2 comments 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany
-
Withholding tax base on rateSummary: withholding tax report, invoice with withholding base particular rate Content (required): transaction date, withholding rate and amount, invoice number Version …
-
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):…
-
How to retrieve data from GL Cube?Summary: How to retrieve data from GL Cube? Content (required): The link below provides some information about the GL Cube (Overview of Oracle General Ledger Balances Cu…RS_CSAA 74 views 4 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
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…Matt Luscombe 34 views 3 comments 0 points Most recent by Andreea Brem-Oracle 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 222 views 7 comments 4 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Can someone help me with the query for customizing the trial balance report.Summary: Currently i am trying to customize the oracle standard trial balance report for fetching the YTD,PTD and QTD balances. Need someone who can help with the logic …Rudraksha Vishnu 25 views 1 comment 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany -
GL_PERIOD_STATUSES in BIP not up to date?Hi Guys I must be doing something wrong because I am not seeing the same values in the oracle backend database via BIP that I am seeing in the Oracle Front End. In the f…
-
Unable to use deep link to navigate to view journal page through OTBI.We want to use Deep links in our OTBI report for journals. By using that deep link we should be able to navigate to view journal page in the application. However we have…KanikaMahajan 92 views 1 comment 1 point Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Table gl_je_batches not up to date in BIP?Hi Guys I have an issue today when accessing table gl_je_batches via BIP, I am not seeing the very latest batches in there which I know have been created because I can s…
-
Spain SAF-T chart of accounts mapping requirements. ?Summary: Spain SAF-T chart of accounts mapping requirements. ? Content (required): Hello Will you please let me know the mapping and report requierements ? If you can sh…Gabriel Kinovisques 43 views 1 comment 0 points Most recent by Anca A-Oracle General Ledger & Intercompany
-
Is there any Oracle seeded report which shows reconciliation status as one of its column?Summary: Oracle seeded report showing "Reconciliation status" (Reconciled/Unreconciled) as output. Content (required): Oracle seeded report showing "Reconciliation statu…NupurS 42 views 1 comment 0 points Most recent by Hussian Sharief M-Oracle General Ledger & Intercompany
-
What the the tables containing the daily balances for all code combinations and cat codes?Summary: What is the table containing the daily balances for all code combinations and cat codes? Content (required): Hello, I understood that in JD Edwards it is a tabl…Teodora Bulancea 42 views 3 comments 0 points Most recent by Nitin Kumar05 General Ledger & Intercompany
-
FEC - Audit report for France - huge data problemSummary: FEC - Audit report for France - huge data problem Content (required): We are concerned about the high volume of data generated by the FEC ( Audit report for Fra…Patrick Chrabieh 62 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
How to view attributes for a value within OTBI Subject Areas such as enabled flag, start date etc.Summary: Need to view attributes of a value such as enabled flag, start date, end date, allow posting, account type etc. Content (required): Our client wants to be able …Shiva K 62 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Localization Report for TurkeySummary: Need E-Ledger Report for Turkey Content (required): Hi All, We have Turkey localization and below reports are required: Quarterly Advance Tax Declaration (Incom…
-
After Upgrade 23A Account Analysis Report is emptySummary: Scheduled update was made for 23A and when generating the report Account Analysis with any account and parameters does not return data. Content (required): Sche…Yerwin Blanco 242 views 1 comment 0 points Most recent by Haripriya-Oracle General Ledger & Intercompany -
Join Subledger Tables to AP_INVOICE_DISTRIBUTIONS_ALLSummary: I'm not sure if this belongs more in the Reporting forums, however I am looking to join any of the following Subledger accounting tables to the AP_INVOICE_DISTR…JBabbit121 278 views 1 comment 0 points Most recent by Madalina R-Oracle General Ledger & Intercompany
-
Need Journal Posted By detailsSummary: We need a a field that maps with Journal Posted by details Content (required): In EBS JE_Batches table we have Posted by field available. In fusion we don't hav…Raavi Srikanth -Oracle 62 views 3 comments 0 points Most recent by Raavi Srikanth -Oracle General Ledger & Intercompany
-
WRS best practice for Financial reports or Oracle BI publisher is more stable?Summary WRS vs BI Publisher for reportingContent WRS vs BI PublisherWhere is it recommended to develop a complicated financial report with compairsons Oracle BI Publsihe…Umer272 35 views 2 comments 1 point Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
Regarding Alternate Fusion Application function for XLA_CONDITIONS_PKG.DISPLAY_CONDITIONSummary: Hi Team, We are migrating a few reports from EBS to Fusion and we have found that the XLA_CONDITIONS_PKG.DISPLAY_CONDITION function is not available in the Fusi…Ankit GML 42 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Close Monitoring and outstanding subleger TransactionSummary: Hi, close monitoring and outstanding subledger not cover the customer requirement , is need one dashboard for monitoring 9 business units and ledgers , my custo…Mahgoub S.Mohamed 33 views 1 comment 1 point Most recent by Cezar - Fusion Oracle Support-Oracle General Ledger & Intercompany -
Journal ApprovalSummary: Report that reflects Journal Approval Content (required): Is there any report or sql that reflects the approvers of GL Journals. Looking for an approval report …CraigX 42 views 2 comments 1 point Most recent by Cezar - Fusion Oracle Support-Oracle General Ledger & Intercompany
-
JE_Lines_ DFF in OTBISummary: JE_Lines_ DFF in OTBI Content (required): Which of the GL subject area can I find the DFF when creating an Analysis? Will the field name listed as Atribute1,2,3…CraigX 52 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle General Ledger & Intercompany
-
Override AP Transaction not captured by Budgetary control ModuleSummary: Hi All, Please note that actually when I'm proceeding with Override of a transaction in AP module same is not being capture in the Budgetary Module. For example… -
User GUID populated for field Created byHi All, We would like to understand why user GUID is captured for few records in GL_CODE_COMBINATIONS table and for few records we have username populated. We could see …Swapnil Kashid 22 views 1 comment 0 points Most recent by Cezar - Fusion Oracle Support-Oracle General Ledger & Intercompany