BI Publisher
Discussion List
-
Interface tables used in the Fusion Accounting Hub Import process (Import Accounting Transactions)Summary: Can someone provide details about the interface tables used in the Fusion Accounting Hub Import process (Import Accounting Transactions)? Specifically, I am loo…Singhi, Govind 20 views 3 comments 0 points Most recent by Swapnil Kashid Subledger Accounting & Accounting Hub -
Restrict Control Account within SubledgerContent We have a requirement to restrict entering control account in AR & AP Transactions. We managed to achieve this partially via Customer/Supplier Control Option und…Rihan Jameel 32 views 5 comments 0 points Most recent by Gifty Jose Subledger Accounting & Accounting Hub -
Customizing Payables Period Close Exceptions ReportSummary: My client is looking to customize the Payables Period Close Exceptions Report. They need additional fields in both the report parameters and the report output. …
-
Query to get the Subledger Application name, Process category names and idsSummary: Can you help me with query to get the SLA name, Process category name and their IDs that can be passed to Create Accounting job? Content (please ensure you mask…
-
Report/Table which shows future MPA(Multiperiod Accounting) Entries for an AHCSSummary: Report/Table which shows future MPA(Multiperiod Accounting) Entries for an AHCS(Accounting Hub) Journal Source Content (please ensure you mask any confidential …User_3UDBD 22 views 2 comments 0 points Most recent by User_3UDBD Subledger Accounting & Accounting Hub
-
Subledger DFF enabled not shown in OTBI subject areasSummary: BIenabled subedger line level DFF cannot be found in OTBI subledger accounting subject areas Content (please ensure you mask any confidential information): A li…Dian Minshan 1 view 2 comments 0 points Most recent by Vivianevasc Subledger Accounting & Accounting Hub -
Need Oracle SQL query to pull Project Subledger transactionHi All, We need a query to pull Project Subledger transaction by Accounts. Please provide us some leads for the same if the query is not available. This is needed as par…
-
Performance issue with BI ReportSummary: Dear All, We have an custom report which was built by Oracle Dev Team. Now we are seeing performance issues with Report. When we try to run(i.e. Schedule the re…Naresh313 68 views 2 comments 0 points Most recent by Mukesh Arora-1 Subledger Accounting & Accounting Hub
-
Will PAAS & SAAS instances time zones be always in Sync?Will PAAS & SAAS instances time zones be always in Sync as we are fetching SAAS data(BIP Reports) from PAAS based on date parameters passed from PAAS. We need to ensure …
-
Need to add column in FAH application line level with 250+ characters and get to GL line level dffSummary: Need to have a character lengeth 250+ column in FAH application line level and flow to GL line level Content (please ensure you mask any confidential informatio…Dian Minshan 3 views 1 comment 0 points Most recent by Daniel Martin Subledger Accounting & Accounting Hub
-
How to build custom report for LCM details with receipt accounting details to recon with GLHow to build custom report for LCM details with receipt accounting details which will be reconciling with GL. We are looking to build the report which will give us Lande…Chintan_Thakkar99 1 view 1 comment 0 points Most recent by Mohamedtaha-Oracle Reporting and Analytics for SCM
-
How to reconcile the subledger journals between primary and secondary ledgersHi There Recently we are trying to develop a report to reconcile the journals between primary and secondary ledger. The clients are now using the subledger conversion le…Alex.s.li-Oracle 21 views 1 comment 0 points Most recent by Laura Petre-Oracle Subledger Accounting & Accounting Hub
-
Alert Composer for Oracle General Ledger and Fusion accounting HubSummary: We have implemented Fusion Accounting Hub in Oraclr fusion SaaS to intergrate our two EBS intances with different chart of accounts . We are looking for email a…Vipul_vipul 31 views 2 comments 0 points Most recent by Andreea Brem-Oracle Subledger Accounting & Accounting Hub
-
How to go up from JELINE_ROW to CCID_S in my xml on my rtf templateSummary: Going up a level or two of my xml on my rtf template Content (please ensure you mask any confidential information): I have customised the Account Analysis rtf. …
-
Report for Disabled GL account code combinations with balancesSummary: HI Team, Is there any report in Fusion GL which can list the disabled/invalid account code combinations along with their balances. Thanks Content (please ensure…Mayank Sapra 24 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Create Accounting Execution Report Same as Accounting Automation?Summary: Our Accounting Automation report runs each night at 11:10pm and I am one of three who receive the email notification with the summary and the Automation Errors.…
-
Newly Created Supporting References not showing up in OTBI ReportSummary: I created two non-balance carrying supporting references - see steps I followed below. After creating these, I ran the following query within Reports & Analytic…Akbar Ahmed 51 views 1 comment 0 points Most recent by Akbar Ahmed Subledger Accounting & Accounting Hub
-
FAH to GL reconciliation reportSummary: FAH to GL reconciliation report Content (required): Hi All, I am looking to prepare FAH to GL reconciliation report. This report should provide the details of a…Mayank Patni 133 views 1 comment 0 points Most recent by Harshad N Godbole Subledger Accounting & Accounting Hub
-
Account Analysis Report - BIP ReportSummary: Hello Team . Can we use Account Analysis Report to reconcile subledger balances with GL in ARCS ? Content (required): Afraid of Account Analysis Report pulling …Taibba Tabassum 51 views 1 comment 0 points Most recent by Haripriya-Oracle Subledger Accounting & Accounting Hub
-
How to tackle different date formats being entered by user in Supporting Reference in BIP Report?Summary: I have a scenario when users input dates in multiple formats eg.18/Mar/2022, 18/March/2022, 18/03/2022, 2022/03/18 while posting a Journal in the Supporting Ref…User_M14OP 21 views 2 comments 0 points Most recent by User_M14OP Subledger Accounting & Accounting Hub
-
'Batch Source' Field From Subledger Journal Line required (Table and Field Name required)Content Hi Community, We require the Batch Source (see sreenshot) field from the Subledger Journal Lines for reporting purposes. Can anyone advise what table and field t…Kunal Daya-175386 36 views 6 comments 2 points Most recent by alexey.shtrakhov Subledger Accounting & Accounting Hub
-
Supporting References with balancesSummary Calculate YTD balances for Supporting References with balances fieldsContent Hi all, Can YTD balances be derived or calculated for Supporting References with bal…Pavan SK 81 views 2 comments 1 point Most recent by Miranda Ho-Oracle Subledger Accounting & Accounting Hub