
Archive for January, 2020
Flashpoint Batman Defeated By Batman
January 26th, 2020, posted in DC Comic And MoviesLogin page error: 404 – The url /OA_HTML/AppsLogin not found
January 22nd, 2020, posted in OracleSuddenly the login page was throwing an error – 404 /OA_HTML/AppsLogin was not found on the server
The access_log shows no errors. error.log from $LOG_HOME/ora/10.1.3/Apache shows
Upon searching in Metalink found couple of direct hits. Most of them clearly mentioned that “it got resolved once all step till patch 7303030 and post patch step is completed “.
This is there as part of our plan later, but to reach to that point we need to do licensing.
Proactive approach: Planner should have done this licensing part before doing HTTP server.But we are doing Production and this crucial step wasn’t taken care of….
Only option we have is to do steps from Note : Note: 1177264.1
1. Login to server
2:- Run adadmin
2a:- Choose the following options
1. Generate Applications Files menu
4. Generate product JAR files
Do you wish to force regeneration of all jar files? [YES] ?
3:- Shutdown the E-business suite middle tier services
4:- Run the ojspCompile.pl
I recreated the jar files using adadmin
and compiled the jsp using
cd $FND_TOP/patch/115/bin
perl ojspCompile.pl --compile --flush -p 20 -log /tmp/ojspc_error2.log
Ensure that the file
$ORA_CONFIG_HOME/10.1.3/j2ee/oacore/application-deployments/oacore/html/server-wsdl/wsrp_service.wsdl
Has Apps Owner.
Run Autoconfig on MT & DB.
bring up application and retest issue
FInally after performing issue got resolved…
SQL for Active Banks and Branches in EBS R12
January 21st, 2020, posted in Oracle QueriesSELECT BankOrgProfile.*FROM HZ_ORGANIZATION_PROFILES BankOrgProfile, HZ_CODE_ASSIGNMENTS BankCA WHERE 1 = 1 AND SYSDATE BETWEEN TRUNC (BankOrgProfile.effective_start_date) AND NVL (TRUNC (BankOrgProfile.effective_end_date), SYSDATE + 1) AND BankCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE' AND BankCA.CLASS_CODE IN ('BANK', 'CLEARINGHOUSE') AND BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES' AND (BankCA.STATUS = 'A' OR BankCA.STATUS IS NULL) AND BankCA.OWNER_TABLE_ID = BankOrgProfile.PARTY_ID :