Monthly Archives: July 2015

WLS: Invalid State file format

This is the error while starting up the Managed server through admin console.

Error: NodeManager not Reachable: java.io.IOException: Invalid State File Format

Unable to start managed servers, and the node manager is not reachable from Administration console. Identified that the node manager is throwing up a java exception as below in the log file.
<<<<<<<<<<<<
NodeManager not Reachable: java.io.IOException: Invalid State File Format
<<<<<<<<<<<<

server_name.state is generated by the server and contains current state of the server.
Node manager identifies the current state of the server from this file. If this file is deleted or corrupted, node manager cannot determine the state of the server.

This file can be found here DOMAIN_HOME/servers/server_name/data/nodemanager
for example E:/oracle/middleware/user_projects/domains/base_domain/servers/OIM/data/nodemanager/

Identify if the managed server is running.
Stop the Managed server by running ‘stopManagedWeblogic.sh’ in DOMAIN_NAME/bin/
Stop Admin server using ‘stopWeblogic.sh’ in DOMAIN_NAME/bin/
Stop Node Manager ‘stopNodeManager.sh’  under WL_HOME/server/bin
Delete the following files.

1.oracle/middleware/user_projects/domains/base_domain/servers/oim_server/data/nodemanager/oim_server.state
2.oracle/middleware/user_projects/domains/base_domain/servers//oim_server/data/nodemanager/oim_server.lck
3.oracle/middleware/user_projects/domains/base_domain/servers//oim_server/data/nodemanager/oim_server.pid

Restart Node Manager, Admin Server and Managed server inorder.

Oracle EBS: Automate Creation and Approval of Contract Purchase Orders / CPAs

site de rencontre pour les plus de 40 ans Objective

In one of my previous projects, I had to transfer the purchase requisitions from a property system to Oracle Apps R12. The REQ’s needs to be created, approved and a PO’s needs to generated and approved automatically. So, the technical solution to support all this is to create a Contract Purchase Agreement before hand so the PO’s can be created and approved. The objective is to Automate the Creation of Contract Purchase Orders/Agreements (CPA’s) in Oracle Applications 11i / R12.

http://kopuamonastery.org.nz/felmor/8165 Issue

There are around 500+ CPA’s that needs to be created which is not possible to enter manually given the time-slot available for Requisitions and Purchase Orders data migration. There are no tools available in the Market currently which offers a solution to automate the creation of Contract Purchase Agreements in Oracle Applications. The reason being Oracle do not currently offer an interface to support CPA type of Purchase Order.  There’s probably some valid reasons why Oracle hasn’t provided an interface for Contract purchase agreements at this time, I’m guessing because it’s fairly technical complex and therefore it might take a while to get this implemented correctly by Oracle and then followed by the third party vendors/tools e.g More4Apps, etc.,

http://josiart.at/rete/4065 Probable Solution

DataLoad Forms Events

http://serezin-du-rhone.fr/pifpaxys/4613 CPA
view Oracle EBS User Setup

Setup a single Oracle user with an ICX: Forms Launcher profile option value that is configured for record and playback

http://host.domain:port/forms/frmservlet?record=record.fld%20play=play.fld&config=playback

However, if the play.fld file on the server doesn’t exist, or is empty, then the Oracle behaviour changes. There are 3 options:

play.fld doesn’t exist – No playback will occur (obviously) and no file will be recorded. Oracle will behave “normally”.
play.fld is empty – Where play.fld exists, but is an empty file, no playback will occur but the Oracle session will be recorded to record.fld.
play.fld is a normal playback file – Playback will occur.

http://bossons-fute.fr/?fimerois=site-rencontre-discussion-gratuit&3f0=6e Location of the fld file: $INST_TOP/logs/ora/[Oracle Forms Version]/forms

misoprostol canada Scenario: Bulk CPAs needs to be created for the existing Supplier and Supplier Sites

Input: Supplier Number, Supplier Site Code

Output: Save the output in the .fld

Exceptions Handled: The email checkbox will be unchecked from the approval screen if the supplier notification is set to EMAIL.

/* Script to Create and Approve the Contract Purchase Agreements */

–Save the input as cpa.sql

–Save the output as play.fld

SELECT
aps.vendor_id vendor_id,
apss.vendor_site_id vendor_site_id,
‘# Forms Event File
# Created: 17-MAY-2012 15:01:25
##BLOCKS PO_APPROVE PO_CONTROL PO_HEADERS
##DESC=
##FIRSTVALUE=1
##LASTVALUE=7
##CLICKFIELDS=
##FONTNAME=Default
##FONTSIZE=8
##WINCHNG 37=2
##WINDEC
##HDRVLDT=0­0­0­0­­
##MAINVLDT=0­0­0­0­­‑0­0­0­0­­‑0­0­0­0­­‑0­0­0­0­­‑0­0­0­0­­‑0­0­0­0­­
##DATEPICKER=1
WINDOW POXPOEPO PO_HEADERS ACTIVATE 3
WINDOW POXPOEPO PO_HEADERS DEACTIVATE 3
WINDOW POXPOEPO PO_HEADERS ACTIVATE 3
WINDOW POXPOEPO PO_HEADERS DEACTIVATE 3
WINDOW FNDSCSGN NAVIGATOR ACTIVATE 1
CLICK FNDSCSGN NAVIGATOR LIST 1 473
ACTIVATED FNDSCSGN NAVIGATOR LIST 1 473
CLICK FNDSCSGN NAVIGATOR LIST 1 475
ACTIVATED FNDSCSGN NAVIGATOR LIST 1 475
WINDOW FNDSCSGN NAVIGATOR DEACTIVATE 1
WINDOW POXPOEPO PO_HEADERS ACTIVATE 5
KEY Next_item
VALUE POXPOEPO PO_HEADERS DOC_TYPE_NAME 1 ‘ || ‘”‘ || ‘Contract Purchase Agreement’ || ‘”‘ ||’
##WIDTHS=188
##TITLES=DOC_TYPE_NAME
KEY Next_item
VALUE POXPOEPO PO_HEADERS VENDOR_NAME 1 ‘ || ‘”‘ || aps.VENDOR_NAME || ‘”‘ ||’
##WIDTHS=268
##TITLES=VENDOR_NAME
KEY Next_item
VALUE POXPOEPO PO_HEADERS VENDOR_SITE_CODE 1 ‘ || ‘”‘ || apss.VENDOR_SITE_CODE || ‘”‘ ||’
##WIDTHS=146
##TITLES=VENDOR_SITE_CODE
KEY Next_item
KEY Next_item
KEY Next_item
KEY Next_item
VALUE POXPOEPO PO_HEADERS AGENT_NAME 1 ‘ || ‘”‘ || ‘OraWorld, UK’ || ‘”‘ ||’
##WIDTHS=146
##TITLES=AGENT_NAME
KEY Next_item
KEY Next_item
VALUE POXPOEPO PO_HEADERS COMMENTS 1 ‘ || ‘”‘ || ‘CPA Creation’ || ‘”‘ ||’
##WIDTHS=244
##TITLES=COMMENTS
CLICK POXPOEPO PO_CONTROL TERMS 1 MOUSE
WINDOW POXPOEPO PO_HEADERS DEACTIVATE 5
WINDOW POXPOEPO PO_HEADER_DETAIL ACTIVATE 5
CLICK POXPOEPO PO_HEADERS START_DATE 1
VALUE POXPOEPO PO_HEADERS START_DATE 1 ‘|| ‘”‘ || ’21-MAY-2012′ || ‘”‘ ||’
##WIDTHS=151
##TITLES=START_DATE
CLICK POXPOEPO PO_HEADERS END_DATE 1
VALUE POXPOEPO PO_HEADERS END_DATE 1 ‘|| ‘”‘ || ’30-JUN-2012′ || ‘”‘ ||’
##WIDTHS=188
##TITLES=END_DATE
MENU CUSTOM FILE SAVE
WINDOW POXPOEPO PO_HEADER_DETAIL DEACTIVATE 5
WINDOW POXPOEPO PO_HEADERS ACTIVATE 5
CLICK POXPOEPO PO_HEADERS SEGMENT1 1
CLICK POXPOEPO PO_CONTROL APPROVE 1 MOUSE
WINDOW POXPOEPO PO_HEADERS DEACTIVATE 5
WINDOW POXPOEPO PO_APPROVE ACTIVATE 5′ ||
decode(apss.supplier_notif_method,’EMAIL’,

CLICK POXPOEPO PO_APPROVE EMAIL_CHECK 1
‘,
null,

‘) ||
‘CLICK POXPOEPO PO_APPROVE WF_OK_BUTTON 1 MOUSE
WINDOW POXPOEPO PO_APPROVE DEACTIVATE 5
WINDOW POXPOEPO PO_HEADERS ACTIVATE 5
WINDOW POXPOEPO PO_HEADERS DEACTIVATE 5
WINDOW POXPOEPO PO_HEADER_DETAIL ACTIVATE 5
WINDOW POXPOEPO PO_HEADER_DETAIL DEACTIVATE 5
WINDOW POXPOEPO PO_HEADERS ACTIVATE 5
WINDOW POXPOEPO PO_HEADERS DEACTIVATE 5
WINDOW FNDSCSGN NAVIGATOR ACTIVATE 1
ACTIVATED FNDSCSGN NAVIGATOR LIST 1 475
WINDOW FNDSCSGN NAVIGATOR DEACTIVATE 1
WINDOW POXPOEPO PO_HEADERS ACTIVATE 7′  Form_Event
from
ap_suppliers aps,
ap_supplier_sites_all apss
where
aps.vendor_id = apss.vendor_id
and apss.org_id = 101
and nvl(aps.end_date_active, sysdate)  >= sysdate
and nvl(apss.inactive_date,  sysdate)  >= sysdate
and nvl(apss.purchasing_site_flag,’N’) = ‘Y’
and (aps.segment1, apss.vendor_site_code) in
((‘12345′       ,’MANCHESTER’))
UNION ALL
SELECT
aps.vendor_id vendor_id,
apss.vendor_site_id vendor_site_id,
‘KEY Next_item
VALUE POXPOEPO PO_HEADERS DOC_TYPE_NAME 1 ‘ || ‘”‘ || ‘Contract Purchase Agreement’ || ‘”‘ ||’
KEY Next_item
VALUE POXPOEPO PO_HEADERS VENDOR_NAME 1 ‘ || ‘”‘ || aps.VENDOR_NAME || ‘”‘ ||’
KEY Next_item
VALUE POXPOEPO PO_HEADERS VENDOR_SITE_CODE 1 ‘ || ‘”‘ || apss.VENDOR_SITE_CODE || ‘”‘ ||’
KEY Next_item
KEY Next_item
KEY Next_item
KEY Next_item
VALUE POXPOEPO PO_HEADERS AGENT_NAME 1 ‘ || ‘”‘ || ‘OraGurus, UK’ || ‘”‘ ||’
KEY Next_item
KEY Next_item
VALUE POXPOEPO PO_HEADERS COMMENTS 1 ‘ || ‘”‘ || ‘CPA Creation’ || ‘”‘ ||’
CLICK POXPOEPO PO_CONTROL TERMS 1 MOUSE
WINDOW POXPOEPO PO_HEADERS DEACTIVATE 5
WINDOW POXPOEPO PO_HEADER_DETAIL ACTIVATE 5
CLICK POXPOEPO PO_HEADERS START_DATE 1
VALUE POXPOEPO PO_HEADERS START_DATE 1 ‘|| ‘”‘ || ’21-MAY-2012′ || ‘”‘ ||’
CLICK POXPOEPO PO_HEADERS END_DATE 1
VALUE POXPOEPO PO_HEADERS END_DATE 1 ‘|| ‘”‘ || ’30-JUN-2012′ || ‘”‘ ||’
MENU CUSTOM FILE SAVE
WINDOW POXPOEPO PO_HEADER_DETAIL DEACTIVATE 5
WINDOW POXPOEPO PO_HEADERS ACTIVATE 5
CLICK POXPOEPO PO_HEADERS SEGMENT1 1
CLICK POXPOEPO PO_CONTROL APPROVE 1 MOUSE
WINDOW POXPOEPO PO_HEADERS DEACTIVATE 5
WINDOW POXPOEPO PO_APPROVE ACTIVATE 5′
||
decode(apss.supplier_notif_method,’EMAIL’,

CLICK POXPOEPO PO_APPROVE EMAIL_CHECK 1
‘,
null,

‘) ||
‘CLICK POXPOEPO PO_APPROVE WF_OK_BUTTON 1 MOUSE
WINDOW POXPOEPO PO_APPROVE DEACTIVATE 5
WINDOW POXPOEPO PO_HEADERS ACTIVATE 5
WINDOW POXPOEPO PO_HEADERS DEACTIVATE 5
WINDOW POXPOEPO PO_HEADER_DETAIL ACTIVATE 5
WINDOW POXPOEPO PO_HEADER_DETAIL DEACTIVATE 5
WINDOW POXPOEPO PO_HEADERS ACTIVATE 5
WINDOW POXPOEPO PO_HEADERS DEACTIVATE 5
WINDOW FNDSCSGN NAVIGATOR ACTIVATE 1
ACTIVATED FNDSCSGN NAVIGATOR LIST 1 475
WINDOW FNDSCSGN NAVIGATOR DEACTIVATE 1
WINDOW POXPOEPO PO_HEADERS ACTIVATE 7′  Form_Event
from
ap_suppliers aps,
ap_supplier_sites_all apss
where
aps.vendor_id = apss.vendor_id
and apss.org_id = 101
and nvl(aps.end_date_active, sysdate)  >= sysdate
and nvl(apss.inactive_date,  sysdate)  >= sysdate
and nvl(apss.purchasing_site_flag,’N’) = ‘Y’
and (aps.segment1, apss.vendor_site_code) in
((‘23456′        ,’MANCHESTER’)
UNION ALL
SELECT
aps.vendor_id vendor_id,
apss.vendor_site_id vendor_site_id,
‘KEY Next_item
VALUE POXPOEPO PO_HEADERS DOC_TYPE_NAME 1 ‘ || ‘”‘ || ‘Contract Purchase Agreement’ || ‘”‘ ||’
KEY Next_item
VALUE POXPOEPO PO_HEADERS VENDOR_NAME 1 ‘ || ‘”‘ || aps.VENDOR_NAME || ‘”‘ ||’
KEY Next_item
VALUE POXPOEPO PO_HEADERS VENDOR_SITE_CODE 1 ‘ || ‘”‘ || apss.VENDOR_SITE_CODE || ‘”‘ ||’
KEY Next_item
KEY Next_item
KEY Next_item
KEY Next_item
VALUE POXPOEPO PO_HEADERS AGENT_NAME 1 ‘ || ‘”‘ || ‘OraGurus, UK’ || ‘”‘ ||’
KEY Next_item
KEY Next_item
VALUE POXPOEPO PO_HEADERS COMMENTS 1 ‘ || ‘”‘ || ‘CPA Creation’ || ‘”‘ ||’
CLICK POXPOEPO PO_CONTROL TERMS 1 MOUSE
WINDOW POXPOEPO PO_HEADERS DEACTIVATE 197
WINDOW POXPOEPO PO_HEADER_DETAIL ACTIVATE 197
CLICK POXPOEPO PO_HEADERS START_DATE 1
VALUE POXPOEPO PO_HEADERS START_DATE 1 ‘|| ‘”‘ || ’21-MAY-2012′ || ‘”‘ ||’
CLICK POXPOEPO PO_HEADERS END_DATE 1
VALUE POXPOEPO PO_HEADERS END_DATE 1 ‘|| ‘”‘ || ’30-JUN-2012′ || ‘”‘ ||’
MENU CUSTOM FILE SAVE
WINDOW POXPOEPO PO_HEADER_DETAIL DEACTIVATE 197
WINDOW POXPOEPO PO_HEADERS ACTIVATE 197
CLICK POXPOEPO PO_HEADERS SEGMENT1 1
CLICK POXPOEPO PO_CONTROL APPROVE 1 MOUSE
WINDOW POXPOEPO PO_HEADERS DEACTIVATE 197
WINDOW POXPOEPO PO_APPROVE ACTIVATE 197′
||
decode(apss.supplier_notif_method,’EMAIL’,

CLICK POXPOEPO PO_APPROVE EMAIL_CHECK 1
‘,
null,

‘) ||
‘CLICK POXPOEPO PO_APPROVE WF_OK_BUTTON 1 MOUSE
WINDOW POXPOEPO PO_APPROVE DEACTIVATE 197
WINDOW POXPOEPO PO_HEADERS ACTIVATE 197
MENU CUSTOM FILE EXIT_ORACLE_APPLICATIONS
USER_EXIT CHOICE OK’  Form_Event
from
ap_suppliers aps,
ap_supplier_sites_all apss
where
aps.vendor_id = apss.vendor_id
and apss.org_id = 101
and nvl(aps.end_date_active, sysdate)  >= sysdate
and nvl(apss.inactive_date,  sysdate)  >= sysdate
and nvl(apss.purchasing_site_flag,’N’) = ‘Y’
and (aps.segment1, apss.vendor_site_code) in (‘34567′ ,’ALTRINCHAM’);

References

http://more4apps.com/product-category/procure-to-pay/