User-Defined Formula
Discussion List
-
Unable to create Payables User Defined Holds RuleSummary: Unable to create Payables User Defined Holds Rule thourgh the spread sheet Content (please ensure you mask any confidential information): We are unable to Unabl…Suresh Balusu 94 views 6 comments 0 points Most recent by Nimesha Yatigammana Payables, Payments & Cash Management -
SLA rule for AR Receipt gain/loss based on receivable account on receipt applicationSummary: We have a scenerio where it is required to post realised gain/loss amounts in different accounts based on the AR Receipt receivable account is offsetting from t…Albert M 22 views 1 comment 0 points Most recent by Anca A-Oracle Subledger Accounting & Accounting Hub
-
SLA Account Rule Condition Error when Transaction Type Name Contains “ &" SymbolHello I am creating SLA Account Rules based on Transaction Type Name. Example – the below condition works fine and validation is successful: "Transaction Type Name" = 'I…Rramu 11 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Subledger Accounting & Accounting Hub
-
Not possible to select user-defined formula on custom line ruleSummary: Unable to select UDF in LOV for custom line rule in Receipt Accounting Content (please ensure you mask any confidential information): I have defined a test User…
-
Ability to select 'attribute_number' DFF as source in user-defined formulasSummary: Ability to use values in attribute_number DFFs as a source in user-defined formulas for SLA. For example PO Schedule attribute_number1 Content (please ensure yo…Marcus131975 11 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle Subledger Accounting & Accounting Hub
-
SLA engine not recognizing the Timestamp datatype as DateSummary: Hi Team, i am using the timestamp data type field in user defined formula as date datatype. However system is throwing error timestamp should be in YYYY-MON-DD …Balakrishna S 11 views 1 comment 0 points Most recent by Daniela Petria-Oracle Subledger Accounting & Accounting Hub
-
Dyanmically updated a DFF based on accounting date selectedHello, We have a requirement to mark the DFF 'Business Day 2 JC' to Yes or No depending on the Accounting date selected. If Accounting date is prior to SYSDATE then mark…
-
Auto Splitting of PO lines based on Start and End date provided in PO Line DFFSummary: PO is created for a contract which is across years like insurance. The PO DFF is used for recording the start and end date of the insurance contract. We require…saurabh.srivastav 11 views 2 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing
-
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 124 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 11 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 51 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 1 view 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 31 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 31 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 111 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 42 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 41 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 83 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
-
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 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 51 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle Subledger Accounting & Accounting Hub