Accounting Rules
Discussion List
-
Multiperiod Accounting in Accounting HubI have completed the setups for MPA in SLA. Create a new SL, Created attributes DATE1, DATE2. When uploaded the transactions through XLATransactionUpload templates, and …KanikaGupta 1 view 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Subledger Accounting & Accounting Hub -
Connection between Mapping Set and Account RuleHello Is there any way to check if for given Mapping Set, exists Account Rule? Regards SylwiaSylwia Borkowska 21 views 3 comments 0 points Most recent by Daniela Petria-Oracle Subledger Accounting & Accounting Hub
-
How to get segment 2 from standard invoice item distribution to AWT INVOICE DISTSummary: We have requirement to have the segment2 i.e our location segment to be copied from standard invoice item distribution to withholding tax invoice distribution a…PullaguraKP 21 views 1 comment 0 points Most recent by PullaguraKP Subledger Accounting & Accounting Hub
-
The cost accounting rule not check mapping set in the next priority even the mapping exist.Summary: The cost accounting rule not check mapping set in the next priority if output not found from mapping set in previous priority. Content (please ensure you mask a…
-
SLA Description rule conditionsCan functions (e.g. TO_CHAR, TO_DATE, SUBSTRING) be used in description rule conditions?yossunak-Oracle 11 views 1 comment 0 points Most recent by yossunak-Oracle Subledger Accounting & Accounting Hub
-
Modify the Account Rule Assignment to Use a Different AccountSummary: Content (please ensure you mask any confidential information):Our cost center 1000 (Segment 3) is targeting a deactivated company code 100 (Segment1) which is r…
-
How to derive accounting of AR invoice adjustment from invoice receivable distributions using SLA?Summary: We have a requirement to drive the segments of AR adjustments on invoice based on invoice receivable distribution( except for company and natural account which …
-
We are building a SLAM rule to derive segment 4 based on segment 3.We are building a SLAM rule to derive segment 4 based on segment 3. Segment 4 is analysis segemnt and segment 3 is natural account. We are trying to build it via account…Arun Kumar Malik 31 views 3 comments 0 points Most recent by Arun Kumar Malik 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
-
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 1 view 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 21 views 2 comments 0 points Most recent by Siva Kumar 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 23 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 1 view 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 1 view 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 21 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 21 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 4 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 22 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 31 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 21 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 21 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 179 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