Script to compare two initoras.sh file
Please use the below script. #!/bin/ksh file1=$1 file2=$2 for parameter in `cat $file1 | grep = | awk ‘{print $1}’ | grep -v ‘#’` do value1=`grep ^$parameter $file1 |…
Read MoreDATABASE UPGRADE USING AUTOUPGRADE TOOL FROM 12c to 19c.
It is a feature that is enhanced in oracle 19c and it is mainly used to automate the upgrade process.it not only automates the database upgrade but also performs the pre-upgrade steps…
Read MoreOracle AP Month End Close Request Set
1. Login to Oracle Enter User Name and Password and Click – Login SELECT System Administrator Responsibility and Press OK Button GO to Requests : Select -> Set Enter Request…
Read MorePeriod Opening
Open and close accounting periods to control journal entry and journal posting, as well as compute period- and year-end actual and budget account balances for reporting To create path in…
Read MoreRecovering Datafile Without Rman Backup
It is possible to recover datafile when accidentally removed or deleted and when there is no backup at all , We can recover the datafile without any issues ,now i…
Read MoreBank branch creation
Navigation: Accounts payables >> Setup >> Payment >> Bank and Bank Branches Step 1 : once enter into Bank and Bank branches it will open Cash management screen once…
Read MoreCreate accounting calendars in GL fusion.
Accounting Calendar Options Define an accounting calendar to create your accounting year and the periods it contains. Specify common calendar options that the application uses to automatically generate a calendar…
Read MoreDifference between AR and GL
User reported that they are getting differences in GL and AR for particular accounts. we noticed that the user is comparing with the custom reports like AR ageing and GL…
Read MoreError on updating customer taxpayer id
Proactively support team has identified an issue with duplicate party id. Support team has worked with oracle to get a fix for the same.01_sop-cm_ora_gdf_01-data-fix-spain-and-poland
Read MoreORA-01555 / ORA-600 in standby database after switchover
ORA-01555 / ORA-600 in standby database after switchover After doing a SwitchOver from Production to standby(open read only), We were facing frequent ORA-01555 error. This is a Oracle bug in…
Read More