User-Defined Formula
Discussion List
-
Line description from SLA to this Reconciliation Reference fieldThe customer needs a way to bring the same line description from SLA to Reconciliation Reference field on journal line in GL. Do you know any way to bring this informati…Pedro Bacic 22 views 3 comments 0 points Most recent by Mounika Daggupati Subledger Accounting & Accounting Hub -
Standard common language or code used on conditions definition in account rules setupSummary: Are there any documentation or guidance on the standard "syntax" used to formulate the conditions in a account rule? Initially we are looking how to translate a…RB Vasquez 1 view 1 comment 0 points Most recent by gabriel.g.popescu-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 11 views 1 comment 0 points Most recent by Murugasamy Velusamy-Oracle Subledger Accounting & Accounting Hub
-
Can we assign multiple event class to one User Defined Formula?Summary: We created User Defined Formula and able to assign to only single event class. Due to that we are unable to use the same Account Rule (where the UDA used as a s…Murugasamy Velusamy-Oracle 11 views 2 comments 0 points Most recent by Murugasamy Velusamy-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 1 view 1 comment 0 points Most recent by Deepak Singal Subledger Accounting & Accounting Hub
-
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 21 views 1 comment 0 points Most recent by Wilson Chelakadan Subledger Accounting & Accounting Hub -
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 21 views 3 comments 0 points Most recent by Emily Pudliner Payroll and Global Payroll Interface (GPI) -
Can I use substr on account.all in UDF in SLA?We are trying to use a user-defined formula to get value of an individual segment (which is not defined in as one of the segments like "Intercompany Segment" etc) from t…Vineet Joshi-192697 31 views 1 comment 0 points Most recent by Laura Petre-Oracle Subledger Accounting & Accounting Hub
-
Document on ARCSHi, Does anyone have latest documentation on ARCS. ThanksMadhavi Godbole 21 views 1 comment 0 points Most recent by Madhavi Godbole Subledger Accounting & Accounting Hub -
User Formula not working in TAB Account RuleSummary: Our customer uses Oracle Self-Service Procurement to create and manage their purchase requisitions. Regarding the charge account, the goal is to automatically d…Thiago Somma 51 views 1 comment 0 points Most recent by Ifeanyi Katchy-Oracle Self Service Procurement
-
How to retrieve the total PO Amount in the Payables application from SLA sources.Summary: Hi Experts, I have requirement to retrieve the total PO amount from Payables application when the invoice is matched with purchase order. Based on the total PO …Balakrishna Sivappagari 81 views 1 comment 0 points Most recent by Lori K-Oracle Payables, Payments & Cash Management
-
Is it possible to copy the Natural Account from one Debit line to another Debit line through SLA?Summary: Is it possible to copy the Natural Account from one Debit line to another Debit line through SLA? Content (required): Hi Experts, I have requirement to copy Nat…Balakrishna Sivappagari 41 views 5 comments 0 points Most recent by alexey.shtrakhov Subledger Accounting & Accounting Hub
-
I would like to use a lookup on the "Manage User-Defined Formulas" screen.Summary: I would like to use a lookup on the "Manage User-Defined Formulas" screen. Content (required): Hi, I would like to know why, when I use my 'AUXILIAR DE LA CUENT…Hans Villanueva Rojas 71 views 1 comment 1 point Most recent by Andreea Brem-Oracle Subledger Accounting & Accounting Hub
-
Date data type User Defined Formulas are not available in the Accounting AttributesSummary: Hi Experts, I defined the custom User Defined Formula with data type "Date" . This custom user defined formula is not available in the Accounting Attributes as …Balakrishna Sivappagari 41 views 2 comments 0 points Most recent by Daniel Martin Subledger Accounting & Accounting Hub
-
Text limit in the insert of the formulas in the "Manage User-Defined Formulas" screen.Summary: Text limit in the insert of the formulas in the "Manage User-Defined Formulas" screen. Content (required): Hi, I would like to know the character limit (text) t…Hans Villanueva Rojas 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle Subledger Accounting & Accounting Hub
-
How to Create AP Invoice accounting entries based on Purchasing CategorySummary: Create AP Invoice accounting entries based on Purchasing Category Content (required): Customer requires to create different AP Invoice (or Credit Mamo) entries …Andrius Čėsna 111 views 12 comments 0 points Most recent by Andrius Čėsna Subledger Accounting & Accounting Hub
-
Modify a formula on the 'Manage User-Defined Formulas' screen through a web service.Summary: Modify a formula on the 'Manage User-Defined Formulas' screen through a web service. Content (required): I would like to know if it's possible to modify a formu…Hans Villanueva Rojas 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle Subledger Accounting & Accounting Hub
-
Accounts Payable Distribution DFF date field not available in the SourcesSummary: Hi Experts, I have requirement to take the Invoice distributions DFF field(INV_ATTRIBUTE_DATE1) for accounting changes. When i check the payables sources, i see…Balakrishna Sivappagari 31 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
How to have default cost center segment on the basis of buyer on the inventory based PO's ?Summary: I am trying to default cost center segment on the basis of buyer in the PO . So for this I created a new account rule in Cost accounting SLA in which the source…AkashAgarwal 41 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle Subledger Accounting & Accounting Hub
-
Manage User-Defined Formulas SintaxSummary: Hi, we need to transfer an information from AR Receipt to GL line reconciliation reference. The information is store in the file "Comments"(receipt header) and …Carlo_M. 81 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle Subledger Accounting & Accounting Hub
-
How to generate sub ledger accounting based on Price Hold?Summary: Our client has a specific requirement to assign Invoice price Variance Code combinations' natural account segment a specific value based on the event of price v…Akash Verma 51 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Subledger Accounting & Accounting Hub -
Mapping set to book in one AR account Domestic and in another AR Foreign CustomersSummary Mapping set to book in one AR account Domestic and in another AR Foreign CustomersContent Hello , I have the business requirement to book in one Accounts Receiva…gabriel kinovisques-163562 28 views 2 comments 0 points Most recent by ChristinaMoore Subledger Accounting & Accounting Hub
-
AP SLA Customization - -Oracle Fusion/21BContent AP SLA Customization Requirement: Based on two accounting segments ( balancing segment & Cost Center) need to derive third segment ( Deparment) Example : Discoun…VijayPatel 79 views 4 comments 0 points Most recent by ChristinaMoore Subledger Accounting & Accounting Hub
-
User Defined Formula in Accounting HubSummary User Defined Formula in Accounting HubContent We want to use the User Defined Formulas for the below scenario The Journal Line value is of Credit in nature. Howe…Indavar 62 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle Subledger Accounting & Accounting Hub
-
FAH: Journal line with negative amount as Debit and Positive Line as CreditSummary FAH: Journal line with negative amount as Debit and Positive Line as CreditContent Please note, we are implementing FAH for some of the downstream data sources a…Indavar 29 views 1 comment 1 point Most recent by Gergana Radoutcheva-Oracle Subledger Accounting & Accounting Hub
-
AHCS: Foreign Currency Transaction's Accrual Reversal on different (latest) conversion rateContent We understand that Accrual Reversal of foreign currency transactions will take the same exchange rate and it will nullify the entire balance to the penny (correc…Vishnu Kant 175 views 3 comments 1 point Most recent by Vishnu Kant Subledger Accounting & Accounting Hub
-
Is there any option to create JLR with condition by linking with LookupSummary Is there any option to create JLR with condition by linking with LookupContent We have a requirement to create JLR with conditions Condition: if one particular s…Veerendra Chava 34 views 1 comment 0 points Most recent by Venkata Kompella Subledger Accounting & Accounting Hub
-
AHCS: Line Level Sources are not available for use in User Defined FormulaContent Hi, I recently noticed that all the Line Level Sources in a custom Sub Ledger is not available for use in Custom Formulas. Is this by design or I missed somethin…Vishnu Kant 40 views 1 comment 1 point Most recent by Vishnu Kant Subledger Accounting & Accounting Hub
-
AHCS: Different Posting Treatment for Different Rules but same Event_TypeContent Hi, Hope you all are doing well. I could use your help / views in below business scenario: Business Scenario We have an existing custom sub-ledger application (1…Vishnu Kant 27 views 1 comment 1 point Most recent by Vishnu Kant Subledger Accounting & Accounting Hub