Sometimes you may get a Error as
oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
If you know that there is no Issue in server side and the problem is in your JDeveloper and you have done some trial and error method. I suggest you to change the hostname to IP in the DBC file and sometimes this Issue will get solved.
1. How to Get More Stable Shots
You know the ups and downs of you mobile camera. I use Lenovo k4 note which has a good camera and night mode is good.
The key for me here is then NOT to use the “software” shutter button but instead use the physical volume buttons which act as your shutter, eliminating camera shake and giving you sharper images. I am ofter surprised by the number of people who are unaware of this feature. The added bonus is that if you use your headphones that came with the phone, you can also use the buttons on that as a cable release and not have to touch the camera at all.
One more thing, hold down the shutter button and you get 10 fps burst mode so you don’t miss the action.
2. Keep Your Lens Clean
A simple but important point: As we tend to keep our phone in our jeans pockets or handbags, give your lens a quick wipe before you shoot. It is a lint and dust magnet in there!
3. Download a Better Camera App
It’s true that the built in camera app has been improved over time, and is great for your average user, but us photographers who require a little more control over the settings should turn to the App Store.
There are numerous 3rd party apps that you can download to give you all the control you would want.
4. Post-Process Your Images
The reality is, like it or not, that you’ll need to process your images to get the best possible final photo.
5. Never Ever Use the Digital Zoom
If you want the best possible image from your phone, forget about using Digital Zoom. The solution is simple: just zoom with your feet. The knock on effect of doing this is that it really improves your compositional skills.
In case of Optical zoom phones like Zenfone zoom you can go for Zoom.
AP Invoice Line Approval Workflow
For AP Invoice Line Approval first we have make sure that the below points are met.
1. Check the approval workflow is enabled.
2. Make sure the Transaction Type: Payables Invoice Approval item class of header and line shoulb be of same level.
3. Check the Packages that it is the functionality is not disabled
Step 1: Create a Attribute Depending on your functionality. Here the transaction ID is same as your Invoice ID
Here make sure the Item Class is selected as line level. This will fetch the number of records matches with the lines for the Invoice.
Step 2: Create Condition Accordingly
3. Define Approver Groups
4.Apply rule according to the requirement
Now create the Invoice and Initiate Line level approval
Note: This will be applicable for matched Invoices.
Now we will invoke the approval for the invoices.
Below is my Invoice
So this Invoice has 4 lines and the approval has to gone to such a way that it should go the the approvers defined in the line level.
Now On Invoking the workflow by placing in the lines and then go to Actions and then tick Initiate Approval and then click ok.
Now you can directly check the line approval history by Reports(in menu) –> View Approval History for line level Approval.
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:
- 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.
- Open the ‘Status Monitor‘ screen (Administrator Workflow > Status Monitor)
- 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.
- Select the workflow with error from the list and open the ‘Activity History‘.
- Select the failed activity and click the ‘Update Attributes‘ button.
- 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)
- 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.
- 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 .
- Requery the workflow to see the latest status.
The notification must have been sent to the approver.
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 )
Query to get the Trial Balace Detail Report is given below. We can also cross check the same with Account Analysis Report.
The Below query is taking by the seeded view GL_JE_JOURNAL_LINES_V.
FROM gl_period_statuses ps,
WHERE lr.source_ledger_id = lr.target_ledger_id
AND lr.application_id = 101
AND b.average_journal_flag = ‘N’
AND b.je_batch_id = h.je_batch_id
AND lines.code_combination_id in (select code_combination_id from gl_code_combinations_kfv where segment1 between :seg1low and :seg1high and segment3 between :seg3low and :seg3high)
AND b.actual_flag = ‘A’
AND h.je_header_id = lines.je_header_id
AND h.ledger_id = lr.source_ledger_id
AND lines.period_name = ps.period_name
AND ps.ledger_id = lines.ledger_id
AND b.default_period_name between :p_period_start_name and :p_period_end_name
AND ps.application_id = 101
and gccv.code_combination_id = lines.code_combination_id
and ffvv.flex_value = gccv.segment3
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
Once Sourced now go to AD_TOP and generate the jar files here this command adcgnjar will generate jar files.
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
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.
cursor c is select * from mtl_system_items_b where RECEIPT_REQUIRED_FLAG =
for item_rec_req in c_item_rec_req loop
–select * from fnd_user where user_name = ‘4IAPPS’;
–select * from fnd_responsibility_tl where responsibility_name like ‘Inventory Super User’
–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’);
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(‘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).
DBMS_OUTPUT.PUT_LINE(‘Organization Id :’||to_char(x_item_table(i).
DBMS_OUTPUT.PUT_LINE(‘Error Messages :’);
FOR i IN 1..x_message_list.COUNT LOOP
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(‘Error has Occured and error is ‘||SUBSTR(SQLERRM,1,200))
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.