Subledger Accounting
Discussion List
-
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… -
schedule Import Accounting Transaction end up with errorHi team, When we upload FBDI file and run the schedule Import Accounting Transaction, it ended up with an error Log file is attached under the attachment and we want to …Tharushi Sathsarani 12 views 1 comment 0 points Most recent by Anisha singh-Oracle Subledger Accounting & Accounting Hub
-
Group Journals by Legal EntitySummary: Hi All, Is there a way to group journals generated from Subledger sources like Payables, Receivables etc by legal entity/company code segment? We have one BU fo…ankit_goel WDC 12 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Subledger Accounting & Accounting Hub
-
Account Rule with 2 User Defined Formula is not workingSummary: We have defined 2 UDA for Cost Management accounting. Substring(Lot Number,0,1) Substring("Serial Number"(CST,S,S),0,1) If we use both the UDA in PO Delivery/WI…Murugasamy Velusamy-Oracle 31 views 1 comment 0 points Most recent by Murugasamy Velusamy-Oracle Subledger Accounting & Accounting Hub
-
Not able to setup the BSV for the Cash Clearing Account ClassSummary: We have one Business Unit (BU1) assigned to one Legal Entity(LE1) and we have multiple Balancing Segment Values ( 290, 292,294, 296,298, etc.) assigned to the L…Akhaya Sahu 73 views 8 comments 0 points Most recent by Eain Cathcart-Oracle Subledger Accounting & Accounting Hub -
Consolidate Accounting Date for Unearned RevenueSummary: Hi Team, Please let us know if there any way we can consolidate all the Unearned Revenue Accounts for a particular period before transferring to GL, to reduce t…Goutam5555 2 views 1 comment 0 points Most recent by Deepak Singal Subledger Accounting & Accounting Hub
-
REST API or SOAP Service to create subledger Accounting JournalsSummary: We have a requirement wherein we need to create Subledger Accounting Journal entry using REST API or SOAP service. I couldn't find any details on oracle documen…Paresh Mundra 22 views 1 comment 0 points Most recent by Anca A-Oracle Subledger Accounting & Accounting Hub
-
Can a mapping set use Input Source without a Value Set?Summary: Can a mapping set use Input Source without a Value Set? Content (please ensure you mask any confidential information): I am trying to create a mapping set withi…ramesh.sivapalan 33 views 2 comments 0 points Most recent by ramesh.sivapalan Subledger Accounting & Accounting Hub
-
Setup Accounting on FA based on Invoice or PO segmentIssue re-created in Assets, and can be accessed through link below.Urvisha Ancharruz 21 views 2 comments 0 points Most recent by Urvisha Ancharruz Subledger Accounting & Accounting Hub
-
Approval Workflow for Manual Subledger Journal - adjustment conditionSummary: Approval Workflow for Manual Subledger Journal - adjustment condition Content (please ensure you mask any confidential information): We are setting up an approv…Suhailah Raza 35 views 2 comments 0 points Most recent by Suhailah Raza Subledger Accounting & Accounting Hub
-
Does interorg transfer between two differeny business units create itercompany journals?Hello, I have a question please. I have only one legal enttity, one GL but different business units. I have the first segment of the GL for the company segment or the bu…Mohamed Helmy 12 views 1 comment 0 points Most recent by Mohamed Helmy Subledger Accounting & Accounting Hub -
About the scope of influence of "Merge Matching Lines"Summary: What is the scope of the "Merge Matching Lines" item in "Manage Journal Line Rules"? Content (please ensure you mask any confidential information): Currently I …REI TSUKAHAR-Oracle 19 views 2 comments 0 points Most recent by REI TSUKAHAR-Oracle Subledger Accounting & Accounting Hub
-
Distribution combination must include the name of the accounts instead of the account code.Summary: I have a question from a customer to include the account combination account name beside the account code is that applicable aor not and How ? Content (please e…Hadeer Ahmed 5 views 2 comments 0 points Most recent by Hadeer Ahmed Subledger Accounting & Accounting Hub
-
can i remove or hide 3 lines from the entry by SLA and the entry still will be balancedSummary: i have a request from a customer to remove or hide 3 debit lines as marked without effecting the entry balancing .is that applicable Content (please ensure you …Hadeer Ahmed 3 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Subledger Accounting & Accounting Hub
-
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…User_2025-02-06-00-21-58-611 559 views 3 comments 0 points Most recent by Visu Subledger Accounting & Accounting Hub -
AHCS Model Setup and Suspense functionality limited in the cloudSummary: In the cloud we would like to have a setup where we could have mulitple event classes with their own Source/Categories in order to be able to use the suspense a…Phil I PNC 21 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Subledger Accounting & Accounting Hub
-
Subledger deeplink to view transaction is not working when Reversal status = ReversedSummary: Since 23D we have a deeplink in an OTBI report to view subledger transaction that is not working when the transaction is from Payable and the reversal status = …Remi Grégoire-Jacques 16 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Subledger Accounting & Accounting Hub
-
How can I get Subledger Begin Balance from Oracle Tables if we are not using the Subledger ReferenceSummary: We are trying to create a custom report for EPM to pull Subledger ending balance for a period. Since we don't use the reference option we don't have the data in…Dhiresh Kavi 6 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Subledger Accounting & Accounting Hub
-
To restrict cost center SEGMENT default values if one BU user creates another BU REQUISITIONSummary: To restrict cost center SEGMENT default values if one BU user creates another BU REQUISITION, we have a requirement to restrict Cost center segment values to be…Hitachi ServiceDesk 41 views 4 comments 0 points Most recent by Ifeanyi Katchy-Oracle Self Service Procurement
-
Payables Multiperiod Accounting Configuration - Journal Line Rule validation ends in warningSummary: While configuring Multiperiod Configuration, I duplicated the Journal Line Rule called as "Multiperiod Item Expense Recognition" to make it to Prorate by Days. …Wilson Chelakadan 85 views 1 comment 0 points Most recent by Wilson Chelakadan Subledger Accounting & Accounting Hub -
Multiple input sources of "Invoice Distribution Account" for Payables Mapping SetSummary: We require mapping multiple segments from the Invoice Distribution account as an input to determine a segment output in SLAs Input: SEGMENT 1 - SEGMENT 2 - SEGM…Victor J 62 views 3 comments 2 points Most recent by Julien_Dubouis Subledger Accounting & Accounting Hub
-
How to define SLA for Project accounting for AR InvoicesHi, We have a business requirement were the accounting string need to update based on Project accounting type (this we are maintaining DFF in project accounting), but th…Koteshwar Tippani 33 views 1 comment 0 points Most recent by Koteshwar Tippani Subledger Accounting & Accounting Hub -
How to create separate GL journal batch for each FAH/AHCS transaction for single SLA app.Summary: Hello Experts, Our customer is in need to create individual GL journal batch out of each AHCS / FAH transaction. Luckily, there will be only one source transact…Sarang Prabtani-Oracle 31 views 5 comments 0 points Most recent by Jim Pang-Oracle Subledger Accounting & Accounting Hub
-
Is is possible to display Gain/Loss amount journal entry for Assets Retirement in GL?Summary: Display Gain/Loss amount journal entry in Asset subledger accounting when retiring an asset Content (required): Trying to figure out if there is a way to displa…Eva Mirzoyan 36 views 4 comments 0 points Most recent by K Leeni Samuel Subledger Accounting & Accounting Hub -
withholding invoice item line account from original invoice distributionSummary: This is what is happening- Stage1: Invoice Item line Distribution segment2-1001 Invoice AWT line Distribution Segment2 - 9999 (from setup) Stage2: After account…sujash.saha 12 views 1 comment 0 points Most recent by Daniela Petria-Oracle Subledger Accounting & Accounting Hub -
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 2 views 1 comment 0 points Most recent by Daniel Martin Subledger Accounting & Accounting Hub
-
Maintenance PRs generated form Maintenance Work ordersHello everybody, I have a business case regarding the creation of a purchase requisition (PR) generated from a maintenance work order. It is automatically assigned a def…Abdelaziz Safwat 64 views 1 comment 0 points Most recent by Manikandan S R-Support Oracle-Oracle Costing
-
Configure Payroll SLAs to Reference Pay Element ClassificationSummary: Within the Payroll SLAs, we have the need to create a segment account rule (or mapping set) based on a Pay Element Classification. As we are now using the Labor…Emily Pudliner 32 views 3 comments 0 points Most recent by Emily Pudliner Payroll and Global Payroll Interface (GPI) -
Supporting references can be used only with predefined applications such as payables?Supporting references can be used only with predefined applications such as payables, assets and etc or they can also be used with newly defined applications like insura…Victor Chrabieh 43 views 4 comments 2 points Most recent by Conor Pewterbaugh Subledger Accounting & Accounting Hub -
How to block transactions from particular sources from posting to specified cost centersWe have a requirement to block/prevent posting transactions to specific cost centers from the subledger modules such as payables. There should be no restriction of posti…Lakshmi Kanchi 21 views 3 comments 0 points Most recent by Lakshmi Kanchi Subledger Accounting & Accounting Hub