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.
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Subledger Accounting & Accounting Hub
Discussion List
-
Count Function in User defined formula ?Summary Do we have Count Function in User defined formula ?Content Hi All, looking for quick info/help if someone knows if there is a way to write or use the count funct… -
Accounting Hub Cloud - Handling Large Volumes of DataSummary Handling Large Volumes of Data in Accounting Hub CloudContent We are implementing Accounting Hub Cloud for a telco related client which has very high volumes of … -
Accessing Segment in Chart of Accounts via SLA Account RuleContent Hi, We have this issue: * We have a custom Accounting Method which is not linked to a Chart of Accounts * We need to create an Account Rule to be used in a Journ…
-
Payables Sources for PO to Invoice differencesSummary Capture Variance amounts (PO to Invoice) for Quantities, AmountsContent Hello, We have a need to capture the differences for quantity, price and amount when matc…User_2025-02-10-08-27-07-493 75 views 8 comments 1 point Most recent by User_2025-02-10-08-27-07-493 -
Reverse Journals out of the GLSummary Have multiple sources that have posted to the GL. After further analysis found an error with the source and need to reverse the journals out of the GL.Content He…
-
Create Accounting Exception - The subledger journal must be balanced in the ledger currency.Content Hi, My client created a custom subledger application, we import transactions using the downloaded template but received an error when importing transaction. Erro…
-
How to use SLA rules for the Project Number in P&L and Balance Sheet AccountsSummary Project number is CoA segment, and is needed in all P&L and Balance Sheet transactionsContent Hi Client uses Projects subledger, and also has the Project number …
-
How to delete Draft transactions from FAH Sub ledger?Summary I loaded the FAH transactions in Draft mode and now willing to delete those and load again in Final mode. How can we achieve this?Content Hello, There are more t… -
Extracting supporting reference balance and year-end questionContent May I know if the OTBI/BIP report are the only ways to extract supporting reference balance? Is it possible to draw it from Smartview or other tools? Also, how t…
-
How many attributes can be defined while registering the FAH application?Summary How many attributes can be defined while registering the FAH application?Content Hi Experts, Can any one tell me how many columns can we register in headers and …
-
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…
-
Accounting Hub Cloud Best Implementation Practices White PaperSummary Key considerations, best implementation practices and use cases to assist in determining the optimal deployment and configuration options on Oracle Accounting Hu… -
Unable to use Supplier Type or Supplier Name in Cost Management to derive PPV AccountSummary Unable to use Supplier Type or Supplier Name in Cost Management to derive PPV AccountContent Hi, We need to derive PPV account depending on the Supplier Type or …
-
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…
-
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 …
-
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…
-
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 …
-
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 …
-
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 …
-
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…
-
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…
-
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 … -
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…
-
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… -
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… -
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…
-
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…
-
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
-
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…
-
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…