FRM:- 92095: Oracle Jinitiator version too low.

1

Just add the environment variable in windows.

VARIABLE NAME :     JAVA_TOOL_OPTIONS

VARIABLE VALUE:     -Djava.vendor=”Sun Microsystems Inc.”

No Approver found in GL Workflow

Sometimes there will be Issue like Jounal approver is not found or the workflow fails like No Approver found so as given by oracle in Doc ID 415875.1.

This usually happens due to incorrect or incomplete setup (please review Note 161382.1).

In this example, the workflow failed originally because the journal preparer’s supervisor did not have an employee name assigned to the user.
Depending on the case, the corrected data must be entered in the steps below:

  1. Select the ‘Workflow Administrator’ responsibility.
    Note that the Workflow Administrator Role must be assigned to the User or Responsibility that is doing this. See Note 371792.1: Basic Setup To View Workflows and Notifications Owned by other Users: Workflow Administrator.
  2. Open the ‘Status Monitor‘ screen (Administrator Workflow > Status Monitor)
  3. Query the workflow in the current context. To know the parameter values to use, please review Note 166367.1 How to Find the Workflow Details in General Ledger Journal Approval.
  4. Select the workflow with error from the list and open the ‘Activity History‘.
  5. Select the failed activity and click the ‘Update Attributes‘ button.
  6. Update the missing attributes of the failed activity, for example:
    – preparer id = employee id from the fnd_user table (-1 shows that an assignment was missing)
    – Approver Name = Preparer’s supervisor’s name (i.e.Person Name to be Attached for the supervisor User)
    – Approver Display Name = Preparer’s supervisor’s name (i.e.Person Name to be Attached for the supervisor User)
  7. Select the errored out activity and click on the ‘Rewind‘ button.
    Clicking on rewind button opens a page listing all the completed activities of this workflow and gives you a choice to select the activity from where the workflow should be rewound.
  8. Select the first activity of the workflow as the point from where it is to be rewound.
    A confirmation was received that the workflow was rewound .
  9. Requery the workflow to see the latest status.
    The notification must have been sent to the approver.

 

Journal IN PROCESS Issue

We had a Issue that the journal approval went to the approver and then we got the Error stating that No Approver found. After that we have cancelled the workflow and checked the Journal. Journal Approval was in Process and we were not able to modify the Journal. After that raising the SR we go the solution

Please use the follow script to be able to approve again the journal. Please note you should have the setup corrected at the time
you try to approve again the journal.

1. Backup the gl_je_batches
create table gl_je_batch_bak as select * from gl_je_batches

2. update gl_je_batches
set approval_status_code = ‘R’
where je_batch_id = 958912
and approval_status_code = ‘I’
and status = ‘U’;

Normally, in such cases you need to correct the setup to avoid the error ‘No approver found‘ and then try to restart the workflow of the journal batch by following the solution in Document 415875.1.
Then you can reassign or resubmit it for approval.
Also please review GLXJEENT Journal Approval Workflow is Stuck with Batch Approval Status “In Process” Can not Delete, Modify or Approve it ( Doc ID 161382.1 )

Bouncing Apache server in Oracle Apps for OAF

In R12.2.x Version of Oracle Apps we have a different method to Bounce server.

The First step is sourcing

Login to your server and run the Environment file in the server and in my case it is in the below path

/oraapps/PREPROD/EBSapps.env run

Once Sourced now go to AD_TOP and generate the jar files here this command adcgnjar will generate jar files.

cd $AD_TOP
cd bin
adcgnjar

You may need to give the apps password for generating the jar files in the server.

Once the jar files are generated then stop and start the server. You may need the weblogic server password to stop and start.

admanagedsrvctl.sh stop oacore_server1
admanagedsrvctl.sh start oacore_server1

In R12.1.x Version

This is very easy no need to follow the porcedures like creating jar files in the server just restart the apache services

cd $ADMIN_SCRIPTS_HOME
adoacorectl.sh stop
adoacorectl.sh start

Happy Bouncing

 

Item Update Script Oracle apps

Below is a simple Item upload Script. The Mandatory Information that we have to pass is the Inventory_item_id and organization_id so once the other Information is given then the script will update the items.
—————————-
–UPDATE
—————————-
DECLARE
l_item_table EGO_Item_PUB.Item_Tbl_Type;
x_item_table EGO_Item_PUB.Item_Tbl_Type;
x_return_status VARCHAR2(1);
x_msg_count NUMBER(10);
x_msg_data VARCHAR2(1000);
x_message_list Error_Handler.Error_Tbl_Type;
cursor c is select * from mtl_system_items_b where RECEIPT_REQUIRED_FLAG =
nvl(‘N’, ‘N’);
BEGIN

for item_rec_req in c_item_rec_req loop
–Apps Initialization
–select * from fnd_user where user_name = ‘4IAPPS’;

–select * from fnd_responsibility_tl where responsibility_name like ‘Inventory Super User’

FND_GLOBAL.APPS_INITIALIZE(USER_ID=>1110,RESP_ID=>20634,RESP_APPL_ID=>401);

–FIRST Item definition
l_item_table(1).Transaction_Type := ‘UPDATE’;
— Replace this with ‘UPDATE’ for update transaction.
–l_item_table(1).Segment1 := ‘TESTAPEXITEM’;
l_item_table (1).inventory_item_id := item_rec_req.inventory_item_id;
–l_item_table(1).Description := ‘UPDATED – TESTAPEXITEM’;
–l_item_table(1).Organization_Code := ‘IMO’; –masterorg
l_item_table(1).Organization_id := item_rec_req.organization_id;
–l_item_table(1).Template_Name := ‘BPI FINISHED GOOD-MAKE’; –template
l_item_table(1).RECEIPT_REQUIRED_FLAG := ‘Y’;
DBMS_OUTPUT.PUT_LINE(‘Calling API to Create Item’);

EGO_ITEM_PUB.Process_Items(
p_api_version => 1.0
,p_init_msg_list => FND_API.g_TRUE
,p_commit => FND_API.g_TRUE
,p_Item_Tbl => l_item_table
,x_Item_Tbl => x_item_table
,x_return_status => x_return_status
,x_msg_count => x_msg_count);

DBMS_OUTPUT.PUT_LINE(‘Sucess:’);
DBMS_OUTPUT.PUT_LINE(‘Return Status ==>’ ||x_return_status);

IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
FOR i IN 1..x_item_table.COUNT LOOP
DBMS_OUTPUT.PUT_LINE(‘Inventory Item Id Created:’||to_char(x_item_table(i).
Inventory_Item_Id));
DBMS_OUTPUT.PUT_LINE(‘Organization Id :’||to_char(x_item_table(i).
Organization_Id));
END LOOP;
ELSE
DBMS_OUTPUT.PUT_LINE(‘Error Messages :’);
Error_Handler.GET_MESSAGE_LIST(x_message_list=>x_message_list);
FOR i IN 1..x_message_list.COUNT LOOP
DBMS_OUTPUT.PUT_LINE(x_message_list(i).message_text);
END LOOP;
END IF;
end loop;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(‘Error has Occured and error is ‘||SUBSTR(SQLERRM,1,200))
;
END;

Thank you.

View ALL workflows from ALL users

I just had this Viewing Users workflow so I just came around this blog. It may be helpful in some cases where we can check from our Username.

http://oracleebsapps.blogspot.com/2011/08/view-all-workflows-from-all-users.html

XML BI Publisher IF statement Logical OR syntax in RTF Template

A question came through today: what is the syntax for a logical OR in a BI/XML Publisher IF statement?

The standard BI Publisher “IF” statement doesn’t seem to cut it.

Lets say I want a test:

if (a=1 or a=2)  then output_my_stuff end if

I don’t want to have to repeat output/logic like:

if(a=1 or a=2 or a=3)
then
 tag_should_be_exe
end_if

A solution is to use if statement structure. So we have:

<?if:GRADE=’1′ or GRADE=’2′ or GRADE=’3′ or GRADE=’4′?>

<?end if?>

If it works use it!

Source

Listing Employees Based on Elements

Listing Employees Based on Elements

Sometimes we need to get a report based on Elements and everytime we cant write a Query as it consumes time by the way. So there is a Inbuilt form which is found in the above screenshot that is List Employees by element. So by this we can easily get the list of employees by the element.

Concurrent Request Completed with Warning

We are facing Issue while running report in TEST Instance.

 

Below is the Screenshot.

Completed Warning

While Checking the log

Log file Info

 

And by the Checking the OPP log file for the concurrent Program Im getting this as below

The Log file’s Location can be found by this Query

SELECT fcpp.concurrent_request_id req_id, fcp.node_name, fcp.logfile_name
FROM fnd_conc_pp_actions fcpp, fnd_concurrent_processes fcp
WHERE fcpp.processor_id = fcp.concurrent_process_id
AND fcpp.action_type = 6
AND fcpp.concurrent_request_id = <request_id>;

OPP file info

After doing some search I got this to Restart the OPP

– Log on to System Administrator Responsibility
– Navigate to Concurrent > Manager > Administer
– Scroll down and look for “Output Post Processor”
– Click on Activate

OPP Restarting

As the  Error is telling the about the path so to check the OPP path

Navigation

XML Publisher Responsibility –> Admisitration

Check the Below screenshot for the path defined

OPP path in Oracle apps

Once this is done now the report works correctly.

Thank you.

Follow

Get every new post delivered to your Inbox.

Join 364 other followers