I am posting this script as lot of my friends have asked about this. They are lot of ways to do this. I am showing you in two best ways.Note:- In ‘N’ place, provide your Nth number you want to findout.How to Select the Nth highest value from a table:-————————————————-select level, max(sal) from scott.empwhere level […]
If there is some oracle Aplication Instance say (11.5.10) got upgrade to R12. After upgarding the Instance/Application, If I want to know the older version. Then use the following select statement. SELECT SUBSTR(snapshot_name,12,8)FROM ad_snapshotsWHERE comments = ‘Preseeded’AND REPLACE(SUBSTR(snapshot_name,12,8),’.’) =(SELECT max(to_number(replace(SUBSTR(snapshot_name,12,8),’.’)))FROM ad_snapshotsWHERE comments = ‘Preseeded’); Use the following to know the current Oracle Apps Version.——————————————————————— SELECT […]
Release 12 introduces a new module, Subledger Accounting (SLA), for managingaccounting across subledger transactions. With the introduction of SLA, Payables willno longer create accounting entries, but will instead rely on the central SLA engine todo so. During the upgrade, accounting options and their settings, and the existingaccounting entries in the Payables data model are moved […]
In Release 12, Oracle E-Business Tax, a new product, will manage transaction tax acrossthe E-Business Suite. In prior releases, the setup, defaulting and calculation oftransaction tax for Payables was managed within Payables using tax codes, theirassociated rates and a hierarchy of defaulting options. This method of managing tax isstill available to you in Release 12. […]
Multiple Organizations Access Control is an enhancement to the MultipleOrganizations feature of Oracle Applications. Multiple Organizations Access Controlallows a user to access data from one or many Operating Units while within a givenresponsibility. Data security is maintained using the Multiple Organizations SecurityProfile, defined in Oracle HRMS, which specifies a list of operating units anddetermines the […]
Recent Comments