How To Get Last Record From The Table In Oracle Sql
October 30th, 2022, posted in Oracle Queries
AP_SUPPLIERS , AR_CUSTOMERS DETAILS QUERY IN ORACLE APPS R12
October 16th, 2022, posted in Oracle QueriesAP_SUPPLIERS MASTER DETAILS QUERY:- ***************************************** select a.SEGMENT1 vendor_code, b.VENDOR_ID, a.VENDOR_NAME, b.VENDOR_SITE_ID, (select organization_id from hr_operating_units where organization_id=b.ORG_ID )ou_id, (select name from hr_operating_units where organization_id=b.ORG_ID )operating_name, b.VENDOR_SITE_CODE, (b.ADDRESS_LINE1||b.ADDRESS_LINE2||b.ADDRESS_LINE3||b.CITY||b.STATE||b.ZIP) address, null GST_REGISTRATION_NO, c.PAN_NO, b.state from ap_suppliers a, ap_supplier_sites_All b, JAI_AP_TDS_VENDOR_HDRS c, JAI_CMN_VENDOR_SITES d where a.vendor_id=b.vendor_id and b.VENDOR_ID=c.vendor_id(+) and b.VENDOR_SITE_ID=c.VENDOR_SITE_ID(+) and b.VENDOR_ID=d.vendor_id(+) and b.VENDOR_SITE_ID=d.VENDOR_SITE_ID(+) AND (NVL(A.ENABLED_FLAG,'N')='Y' OR NVL(D.INACTIVE_FLAG,'N') <> 'N') and b.INACTIVE_DATE is null and a.end_date_active is null AND A.SEGMENT1 = 'PRMAAA1' order by a.VENDOR_NAME,b.VENDOR_SITE_CODE,b.ORG_ID AR_CUSTOMERS MASTER DETAILS QUERY:- ********************************************** select hp.party_number customer_number, hca.cust_account_id customer_id, hp.party_name customer_name, hca.account_number customer_account_number, hcas.org_id ou_id, (select name from hr_operating_units where organization_id = hcas.org_id) operating_unit_name, HCAS.PARTY_SITE_ID CUSTOMER_SITE_ID, HPS.PARTY_SITE_NUMBER CUSTOMER_SITE_NUMBER, ( HL.ADDRESS1 || HL.ADDRESS2 || HL.ADDRESS3 || HL.ADDRESS4 || HL.CITY || HL.POSTAL_CODE) ADDRESS, NULL GST_REGISTRATION_NO, jac.PAN_NO PAN_NO, hl.state, HP.PARTY_TYPE CUSTOMER_TYPE from hz_cust_acct_sites_all hcas, hz_cust_accounts_all hca, hz_parties hp, hz_party_sites hps, hz_locations hl, JAI_CMN_CUS_ADDRESSES jac where 1=1 --and hca.account_number = 'RDAAAG2' and hca.cust_account_id = hcas.cust_account_id and hca.party_id = hp.party_id and hcas.party_site_id = hps.party_site_id and hca.party_id = hps.party_id and hps.location_id = hl.location_id and jac.address_id(+) = hcas.CUST_ACCT_SITE_ID order by customer_name
Find And Delete Files Older Than Some Particular Time Period In Linux
October 9th, 2022, posted in SolarisSearching By File Timestamp
Unix/Linux filesystems have three types of timestamp on each file. They are as follows:
- Access time (-atime): The timestamp when the file was last accessed.
- Modification time (-mtime): The timestamp when the file was last modified.
- Change time (-ctime): The timestamp when the metadata for a file (such as permissions or ownership) was last modified.
Search and delete file older than 7 days
Lets take an example, wherein we will find and delete file older than 7 days. We will be using the option “-mtime” of the find command for this.
1. Get a list of files using find command as follows:
# find /path_to_directory -mtime +7 -type f -exec ls {}\;
2. If the filenames start with any particular pattern, filter using that as follows:
# find /path_to_directory -name 'filenamepattern*' -mtime +7 -type f -exec ls {}\;
3. After checking and confirming the output, go for removal script(It is very IMPORTANT), otherwise there will be irrecoverable data loss.
# find /path_to_directory -name 'filenamepattern*' -mtime +7 -type f -exec rm -fv {}\;
# find . -name “*.pdf” -atime +7 -exec rm {} \;
4. If this needs to be done on a remote server through cron job and log the filenames of deleted files, use the following command
# ssh user@remote_ip "find /path_to_directory -name 'filenamepattern*' -mtime +7 -type f -exec rm -fv {} \; >> /tmp/backup_deletion`date +%Y%m%d`.log 2>&1"
Conclusion
The -mtime parameter will search for files based on the modification time; -ctime searches based on the change time. The -atime, -mtime, and -ctime use time measured in days. The find command also supports options that measure in minutes. These are as follows:
- -amin (access time)
- -mmin (modification time)
- -cmin (change time)
For example, to print all the files that have an access time older than seven minutes, use the following command:
# find . -type f -amin +7 -print
-newer option
The -newer option specifies a reference file with a modification time that will be used to select files modified more recently than the reference file.
Find all the files that were modified more recently than file.txt file:
# find . -type f -newer file.txt -print
What Is The Difference Between 11i And R12 In Oracle Apps
September 25th, 2022, posted in Oracle11i
1) Consist of 3C
2) No concept of MOAC.
3) Major table changes like po_vendors.
4) Banks are created in Account Payables.
5) Ap_Invoices_lines_all table in finance is not there.
R12
1) Consist of 4C
2) Introduction of MOAC( Multi org access control)
3) Major table changes (Ap_suppliers)
4) Banks are created in Cash Management.
5) Subledger Accounting is not there.
5) Ap_invoices_lines_all is there.
6) Subledger Accounting is there.