Thats The Goal I Know Its Bad For Me
February 9th, 2020, posted in No SmokingQuery To Find Legal Entity Organization Company Code
February 3rd, 2020, posted in Oracle QueriesSELECT xep.legal_entity_id "Legal Entity ID", xep.name "Legal Entity", hr_outl.name "Organization Name", hr_outl.organization_id "Organization ID", hr_loc.location_id "Location ID", hr_loc.country "Country Code", hr_loc.location_code "Location Code", glev.flex_segment_value "Company Code" FROM xle_entity_profiles xep, xle_registrations reg, -- hr_operating_units hou, -- hr_all_organization_units hr_ou, hr_all_organization_units_tl hr_outl, hr_locations_all hr_loc, -- gl_legal_entities_bsvs glev WHERE 1=1 AND xep.transacting_entity_flag = 'Y' AND xep.legal_entity_id = reg.source_id AND reg.source_table = 'XLE_ENTITY_PROFILES' AND reg.identifying_flag = 'Y' AND xep.legal_entity_id = hou.default_legal_context_id AND reg.location_id = hr_loc.location_id AND xep.legal_entity_id = glev.legal_entity_id -- -- AND hr_ou.organization_id = hou.business_group_id AND hr_outl.organization_id = hou.organization_id ORDER BY hr_outl.name
Login 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 :