BI Publisher
Discussion List
-
Error in Common Lookup Migration ExternalReportWSSService APISummary: We are trying to migrate common lookup from source instance to target instance via oracle provided /xmlpserver/services/ExternalReportWSSService . There are tot… -
Questions about Maintain Chart of Accounts Hierarchies processWe recently discovered we had an issue with a custom BIP report that was built for us by our implementation consultants. Long story short, we discovered that any new com…Michael_Deming 1 view 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
Provide code for XLA_ACCT_ANALYSIS_RPT_PKG used in Global SLA Account Analysis Report in fusionSummary: Hi, We are working on Global SLA Account Analysis Report, and we want to know the tables and joines used in the data model. And also requesting you to share the…
-
Ability to Drill down from OTBI to edit journal passing data access set on general accountingSummary: Deeplink on a column in order to edit the journal , also if the user is set on general accounting on a ledger different from the report row ledger Content (plea… -
Get GL Balances from CONSOL ledger restricting sourceWe would like to get the GL Balances of the entries posted directly into the CONSOL ledger and are not transferred from the Primary ledgers. We can see that the source i…Arun Vasanthakumar 17 views 1 comment 0 points Most recent by Laura Petre-Oracle General Ledger & Intercompany
-
Does ADFdi, SmartView and VB Extension for excel supported with Google SheetSummary: Our client is only using Google products and not having MS office products. In this case does ADFdi, SmartView and VB Extension for excel supported with Google …
-
How to default standard bip report output to excel?Summary: How to default standard bip report output to excel? Content (required): How to default standard bip report output to excel? Version (include the version you are…
-
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 (…
-
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 26 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 31 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 72 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 35 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 282 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 21 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 149 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 45 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 46 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 41 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 61 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 65 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…Jakeeagarwal 109 views 2 comments 0 points Most recent by Jakeeagarwal General Ledger & Intercompany
-
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 241 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 311 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 65 views 3 comments 0 points Most recent by Raavi Srikanth -Oracle General Ledger & Intercompany