To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Subledger Accounting & Accounting Hub
Discussion List
-
How to store some key values in DFF Attributes in XLA_AE_LINES table by AHCSSummary We would like to capture some key information in the standard DFF attributes which is available in XLA_AE_LINES. The requirement is to store some data file colum… -
Join Conditions for PO to XLA to Projects and AP Payments to XLA to Projects in Oracle FusionSummary Join Conditions for PO to XLA to Projects and AP Payments to XLA to Projects in Oracle FusionContent Dear All, Can you please let me know the Join Conditions in …
-
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…
-
Account Hub duplicate transaction number checkingContent By default, the account hub check duplication on transaction number, does anyone know how does it check the duplication? Does the transaction number needs to be …
-
Disable Subledger accounting information from FAH to GL for some business eventsSummary We have a business requirement where certain business events from source application should account in sub ledger and disable posting to GL (Main goal is to main…
-
Subledger Journals - OTBI Subject AreaContent Hi, In Subledger Journals OTBI subject area, Accounting period column does NOT show in ascending/descending order in prompts. Using the below SQL in the prompts …
-
Create Subledger Application Setup in SpreadsheetSummary Downloaded Template requires a Password to enter dataContent Create Subledger Application Setup in Spreadsheet task allows the setup template to be downloaded on… -
FAH vs Custom GL Journal integrationSummary Are there any guidelines/criteria on when to use Fusion Accounting Hub (FAH) vs Custom GL Journal integration?Content 1) For the third party source system (such …
-
User Defined Formula with DecimalContent In User defined formulas, we have the following formula ."TRX_LINE_ATTR11" is a DFF in Receivables ToInteger("TRX_LINE_ATTR11") In the Invoice 1.when populating … -
Is there any SQL to validate the "Import Accounting Transactions" child's job status?Summary "Import Accounting Transactions" always completed Normal irrespective of child jobs statusContent Parent ESS Job: Import Accounting Transactions Child Jobs: Crea… -
Invalid sources in Header/Line CSV fileContent Hi, Import Accounting Transactions had failed because of "Invalid sources in Header CSV file / Invalid sources in Line CSV file". [ 2020/08/10 09:30:08 ]Validati…
-
Registering Subledger applicationsSummary Considerations or Impacts for registering/deciding # of Source Systems as Subledger applicationsContent Hi, I was wondering if someone has some material or any w… -
ERP – Budgetary Control and Encumbrance Accounting Best Implementation Practices, 26 August 2020, 9Content Submit your questions for the ERP – Budgetary Control and Encumbrance Accounting Best Implementation Practices session to have them answered during the live even…
-
Data Load from Accounting Hub into ARCS via Data ManagementSummary Data Load from Accounting Hub into ARCS via Data ManagementContent Hello all, had a quick question. I am working on the Account Reconciliation Cloud Service (ARC… -
Project SLA Definition: Link Journal LinesSummary Copy the AP Invoice Liability A/C to Project Supplier Cost Adjustment as clearing A/CContent We are trying to configure Subledger Accounting Rules for Project Co…
-
Link between subledger lines and invoice linesSummary I need to link XLA_DISTRIBUTION_LINKS with ap_invoice_lines_allContent I need to link XLA_DISTRIBUTION_LINKS with ap_invoice_lines_all, basically to link the tax…
-
Accounting DateSummary Why Sub ledger accounting date takes last date of the accounting periodContent Hi all, Why Journal passed through the sub modules (AP,CM,AR) takes last date of t…User_2025-01-30-03-25-48-139 53 views 2 comments 0 points Most recent by User_2025-01-30-03-25-48-139
-
No Metadata File exists - while loading the TransactionsSummary No Metadata File exists - while loading the TransactionsContent Import Accounting Transactions has error out because of "No Metadata File exists" However we have…
-
How to populate values in Accounting Class at Journal Line RuleSummary Some of the accounting class are missed like Loan Fee, Interest receivable,Unearned fee income,Loan feeContent Hi, While configuring loan subleder in AHC, Few ac…
-
SLA to split liability entries on an AP InvoiceSummary Is it possible to create an SLA to split the liability entry into 2 different liability accounts?Content I am trying to determine if this is possible, before I g…
-
Replacement for FAHRCS?Summary Accounting Hub REporting Cloud service for EBS has been discontinued, is FAH considered a replacement?Content Hi all I understand that Oracle Fusion Accounting H…User_2025-02-05-01-55-41-732 36 views 2 comments 1 point Most recent by User_2025-02-05-01-55-41-732
-
Accounting Hub Cloud Best Implementation Practices White PaperSummaryKey considerations, best implementation practices and use cases to assist in determining the optimal deployment and configuration options on Oracle Accounting Hub… -
Receipts Write Off AccountingSummary Receipts Write Off AccountingContent We use project billing to create revenue and invoices and SLA rules exists for create accounting project revenue uses a Proj…
-
Accounting HubSummary "The Accounting Hub" to manage multiple data sources into Financial Consolidation and CloseContent Is anyone using "The Accounting Hub" to manage multiple data s… -
Duty role for Subledger Journals in SpreadsheetSummary Duty role for Subledger Journals in SpreadsheetContent Hi All, Could someone provide the duty role/privilege behind 'Create Subledger Journals in Spreadsheet' pl…
-
Journals Not Generated for FAH TransactionsSummary Journal Not Generated for FAH TransactionsContent Hi All, I have configured the Accounting Hub for Expenses Management for 1st time. What I have done are follow:…
-
Treasury ModuleSummary Treasury ModuleContent Hi, Treasury Module in cloud is available? Regards Srinivas
-
Calculation of PTD from YTD balanceSummary Is it possible to derive the PTD balance in FAH?Content Hi We are going to receive data extract from external sources with YTD balance periodically and the expec… -
Sub ledger SQLSummary I need to link sub ledger tables to each journal sourceContent I am creating a report that shows GL transactions and need to link into each specific journal sour…
-
How subledger accounting entries are balancedContent Have you ever had doubts about how subledger accounting entries are getting balanced and why sometimes they are not? Check out this post on the ERP ACE Blog whic…