User-Defined Formula
Discussion List
-
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 123 views 13 comments 0 points Most recent by cylim Subledger Accounting & Accounting Hub -
How to derive Second segment from AR Refund AP invoices in fusionIn oracle fusion. There are receivable refunds that are imported to payables as payment requests. In those AP invoices, the second segment cost centre is coming as defau…Prasanna002 13 views 1 comment 0 points Most recent by Daniela Petria-Oracle Subledger Accounting & Accounting Hub
-
Schedule an ESS job to run for every X minutes between some Y and Z hours.I am looking to schedule an ESS job to run for every 3 hours between 8am to 6pm daily. i.e. Run times will be 8am, 11am, 2pm and 5pm every day for the whole year. Curren…
-
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 54 views 3 comments 0 points Most recent by Jan Bart van der Plaats Subledger Accounting & Accounting Hub
-
Why wont Fusion Accounting Hub Subledger User Defined Formulas use the LPAD function?Summary: User Defined Formulas will not accept the LPAD function Content (please ensure you mask any confidential information): Version (include the version you are usin…Phil I PNC 2 views 1 comment 0 points Most recent by gabriel.g.popescu-Oracle Subledger Accounting & Accounting Hub
-
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 32 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 2 views 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 24 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 13 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 67 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 32 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 42 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 74 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 82 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 42 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 74 views 1 comment 1 point Most recent by Andreea Brem-Oracle 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
-
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 12 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 42 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 30 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 113 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…User_2025-01-30-00-07-59-110 73 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…User_2025-01-30-00-07-59-110 30 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…User_2025-02-07-09-44-20-578 190 views 3 comments 1 point Most recent by User_2025-02-07-09-44-20-578 Subledger Accounting & Accounting Hub