BI Publisher
Discussion List
-
I am in search of a GL Transaction Detail query in SQLSummary: I am in search of a GL Transaction Detail query in SQL Content (please ensure you mask any confidential information): I need the SQL code so I can modify if nee…Mike.Myers.CDIPRODUCTS.COM 23 views 3 comments 0 points Most recent by CA Nirmal Choudhary 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…User_2025-02-11-12-30-38-982 1.2K views 9 comments 4 points Most recent by Truptesh Solanki General Ledger & Intercompany
-
Hi all, does anyone know how to calculate the prior fiscal year to date using bi publisher data modeSummary: Content (please ensure you mask any confidential information): I am aware the I can use FRS, but I am being pushed to use BI publisher. My question is, do you g…
-
Extract Layout Templates in ReportSummary: Hi, Is there a way to extract the details of Layout Templates in a Report? The client wants to extract all layout details of their reports as Excel for their re…Ralph Aldrich Magno 12 views 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany
-
getting duplicate seniority dates in OTBI report FusionSummary: Oracle Fusion OTBI report is there giving duplicate records for one of the employee. It showing two seniority date records out of it we need earliest seniority …
-
Action Taken Table/Field under Manage Accounting ErrorsSummary: Hello Colleagues, Good day! With regards to Manage Accounting Errors, do we have a table/field that contains the Action taken? I tried to search all tables and …Ralph Aldrich Magno 65 views 4 comments 0 points Most recent by Ralph Aldrich Magno General Ledger & Intercompany
-
Impact of Member Name Path when a Tree includes multiple versionsSummary: Impact of Member Name Path when a Tree includes multiple versions Content (please ensure you mask any confidential information): We have a tree that includes on…
-
Is there a way to bulk enabling DFFs instead of one by oneSummary:We have many DFF that will need to enable for BI. Looking for a faster way to enable all at once instead of doing it one by one. Content (please ensure you mask …
-
Get Expenditure item date from back end tablesSummary: Please advise how we can get Expenditure Item Date and Expenditure Type from back end tables. I have below query as of now it is giving result based on SYSDATE.…
-
How do we get Transaction counts by day or by week from modules AP,AR,GL,FA & CM from Oracle FusionSummary: We are looking for the Transaction counts of all the modules from Oracle Cloud Fusion by day or by week. Is there any default reports that can give these counts…Jaikar_Reddy 86 views 4 comments 0 points Most recent by Cezar M-Oracle General Ledger & Intercompany
-
OTBI Report analysisSummary: I have created mostly Reports development in Oracle BiPublisher. Where i used to show prompt input parameters in Reports and formatting easily with multiple gro…
-
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):…
-
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…GNCC33 207 views 3 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Can BIP push data directly to OCI object storage?Summary: Content : We are trying to send data directly from SaaS to OCI object storage. Is this possible and how? Thanks.
-
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…MDeming 11 views 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…
-
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 11 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 …
-
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 111 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 81 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 …
-
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 173 views 4 comments 0 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 125 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…KanikaGupta 516 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…martingabriel Kinovisques 41 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…User_2025-03-10-17-00-26-818 53 views 1 comment 0 points Most recent by Hussian Sharief M-Oracle General Ledger & Intercompany