New tax rate creation
Business requested a new VAT to apply the tax at the invoice level. Steps: Go to Set up and Maintenance > Financials > Transaction Tax > Manage Tax Rates and…
Read MoreOracle R12 SQL Query – Price List or Fee Schedule for Customer
select HP.PARTY_NAME “Customer Name”,HCAA.ACCOUNT_NUMBER,HCAA.ACCOUNT_NAME,qph.name “Price List Name”,HCSUA.SITE_USE_CODE,HCSUA.LOCATION from qp_list_headers qph,APPS.HZ_CUST_ACCOUNTS_ALL HCAA,APPS.HZ_CUST_ACCT_SITES_ALL HCASA,APPS.HZ_CUST_SITE_USES_ALL HCSUA,APPS.HZ_PARTIES HPWhere hcaa.account_number = –Customer Account Numberand HCAA.CUST_ACCOUNT_ID = HCASA.CUST_ACCOUNT_IDand HCASA.CUST_ACCT_SITE_ID = HCSUA.CUST_ACCT_SITE_IDAND HCSUA.PRICE_LIST_ID = QPH.LIST_HEADER_IDAND HCAA.PARTY_ID=HP.PARTY_ID
Read MoreDynamic JSON Storage in Oracle APEX Forms
Introduction Oracle APEX applications often require storing complex, structured data in a flexible way. Instead of creating multiple tables for dynamic data structures, we can leverage JSON storage in a…
Read MoreHow to pass multiple parameters in REST API web service
Introduction: The purpose of this document is to demonstrate how we pass multiple set of parameters in REST API through Postman. Cause of the issue: Whenever we test any REST…
Read MoreExploring the New Security Features in Oracle Database 23ai
Oracle Database 23ai introduces advanced security features designed to enhance data protection, simplify configurations, and align with modern security standards. These updates strengthen the database’s security posture and improve usability…
Read MorePurchase Invoice GL to AP Drill down for Account Analysis Reconciliation
Introduction: This document outlines how to reconcile Oracle General Ledger (GL) and Oracle Payables (AP) for Purchase Invoice analysis by using a specific SQL script to drill down to the…
Read MoreAP: Create Accounting Completed In Warning with Offsets Error
Issue Overview: The error “The accounting program cannot create this journal line because the debit or credit that offsets it cannot be found” occurs when attempting to run the Create…
Read MoreAR Invoice Created Through Autoinvoice Cannot Be Completed Due To Error
AR Invoice Created Through Autoinvoice: Cannot Be Completed Due To Error Error ORA-01407: cannot update (???) to NULL ORA-06512: at “FUSION.ARP_UTIL”, line 6272 ORA-06512: at “FUSION.ARP_UTIL”, line 6242 ORA-06512: at line 1 Solution – Navigate to AR System Options (Manage Receivables System Options) – Change the field ‘Document Generation Level’ to ‘When Saved’ – Save the changes
Read MoreSLA Customization in Oracle Fusion.
What is Subledger Accounting? Oracle has provided standard accounting derivation for all the possible events of different aspects of business. However, there could be requirements of deriving custom accounting on certain conditions or business events. Subledger Accounting (SLA) is a rule-based accounting engine that centralizes accounting for Oracle Fusion products. Subledger Accounting is not a separate product in itself, rather it is Oracle’s engine catering to the accounting needs of both Oracle and external modules. Together with the ledger support, Subledger Accounting enables support of multiple accounting requirements concurrently in a single instance. Different accounting regulations can be satisfied by maintaining and applying different sets of rules to different sets of transactions, or accounting for the same transaction with multiple methods. Subledger accounting options define how journal entries are generated from subledger transactions at the subledger application level. Subledger accounting customizations comes in handy for such requirements. It has been first introduced in Oracle Applications e-business suite. Oracle fusion has leveraged the same functionality and extended it to a greater flexibility to derive accounting, descriptions, references and other components by using various conditions and even formulas which makes it even more flexible and result oriented. The different components to achieve such complex accounting derivations are as given hereunder: Mapping Sets Account Rules Journal Line Rules Description Rules Events Subledger Journal Entry Rule Sets Accounting Method Ledger Mapping Sets Mapping sets provide an efficient way to define a segment or account combination value for one or more transaction or reference attribute values. Using such input and output mappings is simpler than using complex conditions on account rules. Based on the value of the source input, a single segment or a full account is derived. Account Rules These are the rules that determine from where an accounting flexfield value is taken or how it is derived. Oracle does provide seeded rules, however one can create one’s own rules to derive accounting flexfield segment values. The following rule types are available: Account combination Segment Value Set Journal Line Rules These are the rules that determine whether a subledger journal line will be a debit or a credit line, whether lines with the same account should be merged and what the accounting class of the line is. The Link Journal Lines option determines whether the journal line rule is set up to establish a link between the accounting of transactions that are related both within the same application, and across applications. In the seeded definition, no link is established. Description Rules These are the rules that determine what appears on the subledger journal entry at the header and/or the line. The definition determines both the content and sequence in which the elements of the description appear. Event Events are used to process transactions, i.e. the transaction drives the accounting event. E.g. the SLA setup for the transaction Addition, e.g. is built under the event Addition and the event CIP Addition. There are also non-accountable events, like an amortized life change where no subledger journal entry is created from the event. Subledger Journal Entry Rule Sets The component rules (Account Rules, Journal Line Rules, Description Rules, and Supporting References) are now combined under the Subledger Journal Entry Rule Sets to form the complete set of rules per accounting event for the subledger.…
Read MoreResolving the Issue about , User PC not connecting to Wireless access point network
Resolving the Issue about , User PC not connecting to Wireless access point network
Read More