Accounting Rules
Discussion List
-
Utilizing Account rule priority or defining a condition "If mapping not found in previous rule"Summary: Need to derive Location segment value based on 3 mapping sets. I want the create accounting program to go to rule 2 if no mapping is found in rule 1, and so on …Abishek R Hande 2 views 1 comment 0 points Most recent by Daniel Martin Subledger Accounting & Accounting Hub -
Default 9999 as segment 4 if segment 3 is in range 4000-5999Hi All , We need to default 9999 as segment 4 if segment 3 is in range 4000-5999 while running accounting for AP. We need to acheive this via slam but since segment valu…Arun Kumar Malik 3 views 1 comment 0 points Most recent by Daniel Martin Subledger Accounting & Accounting Hub
-
Secondary ledger mapping issue in fusionSummary: We have primary and secondary ledger. Our Data Conversion Level is Subledger & we have written Subledger accounting rules in primary ledger and the couple of se…Siva Kumar 23 views 2 comments 0 points Most recent by Siva Kumar Subledger Accounting & Accounting Hub
-
Description rule based on Transaction line description not working.We have defined a custom Description rule for receivables based on the source 'Transaction Line Description' However, when accounting is generated Transaction line descr…Srinivas.chekuri 13 views 1 comment 0 points Most recent by gabriel.g.popescu-Oracle Subledger Accounting & Accounting Hub
-
How to derive second segment from AR Refund AP invoicesSummary: The AR Refund transactions are flown to AP as payment requests where the second segment is default from receivables activity. we need to derive second segment s…Prasanna002 27 views 1 comment 0 points Most recent by gabriel.g.popescu-Oracle Subledger Accounting & Accounting Hub
-
The description for the Receivables A/c (Dr.) is not appearingSummary: A transaction was created and posted to the ledger. While viewing the accounting, the description for Revenue (Cr.) is appearing, but the description for the Re…User_MCDLB 3 views 1 comment 0 points Most recent by Daniela Petria-Oracle Subledger Accounting & Accounting Hub
-
Does oracle have Capability to upload the Journals for several Months in bulk IF FE period is 1Summary: Does Oracle have the capability to run std journal entries on command? For instance, prepaid have are prorated over a year. Can the entry be set up in Oracle an…Baskara Sateesh-Oracle 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Accounting Hub Setups - Massive changes - API or Excel/CSVSummary: The customer needs a way to create and change journal line rules and all another relative setups in a massive way by API or excel/csv. Our desire is to automate…Pedro Bacic 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Is there any syntax for using a value with an apostrophe in an Account Rule?Summary: In building an Account Rule for use in Purchasing TAD, we would like to enter conditions that include the Project Type. As an example, we have a rule with these…Nicole Marasigan-247845 3 views 1 comment 0 points Most recent by Vaibhav Chaudhary-Oracle Purchasing
-
Accounting Hub Setups - Massive changes - API or Excel/CSVSummary: The customer needs a way to create and change journal line rules and all another relative setups in a massive way by API or excel/csv. Our desire is to automate…Pedro Bacic 23 views 2 comments 0 points Most recent by Gergana Radoutcheva-Oracle Subledger Accounting & Accounting Hub
-
Receivables - How to use the field Transaction Line Tax Rate Name for SLA ?Summary: Receivables - How to use the field Transaction Line Tax Rate Name for SLA ? Content (please ensure you mask any confidential information): Hello I need to chang…martingabriel Kinovisques 22 views 2 comments 0 points Most recent by martingabriel Kinovisques Subledger Accounting & Accounting Hub
-
Control subledger posting of projects account - 18201 (Restrict other modules AP,AR to use project)There are a few cases where AP/AR users accidentally post to the project CIP account 18201, which creates discrepancy between the Projects and GL modules. Please note th…Gifty V 3 views 1 comment 0 points Most recent by gabriel.g.popescu-Oracle Subledger Accounting & Accounting Hub
-
Account Combination Rule for Concatenated Value from Source FileSummary: Is it possible to create an Account Rule for the entire combination with type as source. Content (please ensure you mask any confidential information): Working …User_GCXFW 21 views 1 comment 0 points Most recent by gabriel.g.popescu-Oracle Subledger Accounting & Accounting Hub
-
BSV Mapping for RoundingWe need your help in mapping the BSV of Rounding & FX Gain/Loss to Payable Account BSV (Liability Account) on an invoice.Siva Sankar Naidu 21 views 7 comments 0 points Most recent by Daniela Petria-Oracle Subledger Accounting & Accounting Hub
-
Is it possible to use the field "Tax Classification Code" for SLA in Receivables?Summary: Is it possible to use the field "Tax Classification Code" for SLA in Receivables? Content (please ensure you mask any confidential information): Hello We need t…martingabriel Kinovisques 32 views 2 comments 0 points Most recent by alexey.shtrakhov Subledger Accounting & Accounting Hub
-
SLAM rules to conditional flip segment4 based on 1st character of segment3Hi All, We have a requirement where we want to derive segment 4 based on 1st character of segment3. Eg. Condtion 1: If account segment in range 500000 to 599999 then we …Arun Kumar Malik 23 views 3 comments 0 points Most recent by Arun Kumar Malik Subledger Accounting & Accounting Hub
-
Is there a Oracle table storing import accounting Transactions errors?Summary: We would like to know if there is any Oracle table storing the errors available 'Import Accounting Transactions into Interface' ESS job logs. For example, inval…Saichand Reddy Danda 25 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Subledger Accounting & Accounting Hub
-
How to use SLA rules to generate Project Number COA segment in billing offsetSummary: Project number is CoA segment, and is needed for project related transactions Content (please ensure you mask any confidential information): Client uses PPM Mod…
-
Validations related to an account derivation rule returns a 'Warning' message . Will it work?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Amalesh Roychoudhury 31 views 10 comments 0 points Most recent by Amalesh Roychoudhury Subledger Accounting & Accounting Hub -
Significance of Include User Transaction Identifiers Y/NSummary Include User Transaction Identifiers = YContent Hi All What is the significance of "Include User Transaction Identifiers" in Create Accounting. What happens if y…SarahL 178 views 2 comments 0 points Most recent by Vijay Kumar J Subledger Accounting & Accounting Hub -
Why doesn't Liability Automatic Offsets work with Payables Mapping Set and Subledger Account Rule?Summary: Set up Payables Subledger Accounting rules to map a few of the Primary Balancing Segments to new ones created. Expense side works but not the Liabiity Automatic…LoT13 1 view 1 comment 0 points Most recent by Daniela Petria-Oracle Subledger Accounting & Accounting Hub -
PO Exchange and Invoice variance to be accounted same as POSummary: Is it possible to create mapping set in Payables based on Inventory org and Inventory Item type? Content (required):We have Invoice variance and Exchange varian…Thiyagu RJ 61 views 1 comment 0 points Most recent by Daniela Petria-Oracle Subledger Accounting & Accounting Hub
-
Multiple Encumbrance Accounts for Business UnitSummary: Multiple Encumbrance Accounts for Business Unit Content (please ensure you mask any confidential information): Customer needs assistance in accounting for invoi…User_AZR8C 1 view 1 comment 0 points Most recent by Daniela Petria-Oracle Subledger Accounting & Accounting Hub
-
Accounting rule condition in SLA setup is showing error "Possibly blind query executed ...."Summary: Issue with Accounting Rule Condition in SLA Setup We encountered an error when adding more values to an existing SLA rule condition using "OR". The error messag…PrasadKota 38 views 4 comments 0 points Most recent by PrasadKota Subledger Accounting & Accounting Hub
-
Can we map the cost center segment of revenue account to the cost center segment of tax account?Can we map the cost center segment of revenue account to the cost center segment of tax account in receivables? If yes, could someone please let me know steps to configu…Jaishyam P 22 views 2 comments 1 point Most recent by Jaishyam P Subledger Accounting & Accounting Hub
-
Can the SLA rules override the check done for an CoA mapping account rule?Summary: We have set up done all the setup so that particular SLA rules are applied for one of the accounting string segments, one rule for the segment in the Primary Le…RoxanaS 37 views 3 comments 0 points Most recent by Gergana Radoutcheva-Oracle 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
-
Mapping Set vs Source in RMCS SLA - Which option is preferred from a performance perspective?Summary: We are using out of the box integration from Oracle Subscription management to Oracle Revenue Management. We have a requirement to derive few accounting segment…RaviAhuja2805 11 views 1 comment 0 points Most recent by gabriel.g.popescu-Oracle Subledger Accounting & Accounting Hub
-
Unable to search Purchasing Account Rules from Global searchWhen we try to search task "Manage account Rule" from global search, it is giving the search results as below - - Manage Account Rules - Manage Account Rules: Cost Manag…Abhishek Tiwari-Oracle 21 views 3 comments 0 points Most recent by Swapnil Kashid Subledger Accounting & Accounting Hub
-
Is it possible to use Intercompany Transaction Type as a source in Account Rules?Summary: Hi there, I'm trying to understand whether it is possible to write an account rule using the intercompany transaction type as a source. Content (please ensure y…Rob Tempelman 13 views 3 comments 0 points Most recent by Daniela Petria-Oracle Subledger Accounting & Accounting Hub