Best Of
Can the System Automatically Create the Bank Statement by Uploading/Importing PDF Bnk Stmt File?
Image 47
PeopleTools 8.60.10
Description:
Currently we have a LOT of small banks that send a PDF bank statement file, and we manually enter the bank statement into PeopleSoft. Is there a way to upload and import a PDF file of a bank statement and PeopleSoft automatically create the bank statement from the details on the PDF? This would greatly reduce our manual workload.
Re: Inbound Mailer Processing
Hi Jess,
Such issue can occur if several mailers use the same IMAP account.
An IMAP account should not be used by more than one mailer.
See the below documents which explain this:
Extract of doc id 741352.1:
"You need to set a different account for each and every Workflow Mailer on same instance or different instances."
To check how IMAP account is set up on each environment, you'll need to run the below SQL on each of these environments:
SELECT b.component_name, c.parameter_name,
a.parameter_value
FROM fnd_svc_comp_param_vals a,
fnd_svc_components b,
fnd_svc_comp_params_b c
WHERE b.component_id = a.component_id
AND b.component_type = c.component_type
AND c.parameter_id = a.parameter_id
AND c.encrypted_flag = 'N'
AND b.component_type = 'WF_MAILER'
AND c.parameter_name in('INBOUND_SERVER','ACCOUNT')
ORDER BY c.parameter_name;
Hope this will help,
Many thanks and best regards,
Isabelle
Re: Approval mail stuck in mailbox inbox
Usually, when we have a problem with an inbound email, the Workflow Mailer is deactivated. The DBAs have configured some kind of alert to notify them of this, but unfortunately I don't have any details about how this is configured. I'll see if I can find out any details. Is your Mailer being deactivated, or does it just stop processing?
I think the key would be to try to figure out why it is happening in the first place, so that you can prevent if from happening at all.
Do you see any clues in the log file? Any error messages?
Early on, we had some problems when people were responding through certain mobile devices. The device was automatically changing the NID to a phone number, which cause a problem when it came into the Workflow Mailer. I believe that there are certain settings you can do on the device to prevent this from happening.
We've also experienced errors when outside vendors send unsolicited emails where there is just a Subject Line and an Attachment, but no body.
Also, I don't believe you can have the Workflow Mailer account attached to Outlook at the same time it is processing. It can cause a lock, preventing processing. I would make sure that no one has the mailbox linked to their Outlook and I would also ensure that the email account is not used in another Instance, because that can cause problems as well.
If you can figure out the cause of the delay in processing, you might not need to configure an alert.
DGray
Re: UBE Performance Tuning
Hello,
It is nothing specific to JDE in regards the performance. You should always have in your mind general principles of software programing. For example when fetching data, in case you want to fetch data having specific condition, then you should use that condition to fetch the data and not walk through a full data set.
Timing for execution of a line of code cannot be measured.
I believe you are referring to the Event Rules timings. Even if you are referring to NER or BSFN lines, please keep in mind that an instruction in C, at compilation is converted to assembly language and different instructions in C can be implemented in assembly in several commands. Each assembler line takes one CPU tick to execute. The higher CPU frequency, the quicker multiple assembler lines (codes) are executed. This is a trivial explanation and is not involving low level analysis of code execution.
You may start design an UBE which will make use of NER and BSFN and check the performance. You always can see where the delays are occurring if you will run the UBE with debug logging on and then use the Performance Workbench (for example) to check the timings and how many times data has been fetched from a table.
Please check also the following KM Documents:
- JD Edwards EnterpriseOne Diagnostic Tools: Performance Workbench (Doc ID 2013059.1)
- E1: ENV: Performance Workbench Tool Information for Analyzing JDEDEBUG Logs (Doc ID 654972.1)
Thank you!
Best regards,
Cezar
Re: R9840R ZJDE0005
Hi @2011,
Thank you for visiting My Oracle Support Community and posting your question here! I want to let you know I have moved your thread to our Install, Upgrades & Change Mgmt - JDE1 (MOSC) subcategory for those subject matter experts to engage.
If an answer resolves your question, please choose the "YES" on that comment for "Did this answer the question?".
In the meantime, feel free to review the following information to learn more about our Community:
- How to Find and "Follow" Categories - Learn how to Follow Categories of interest
- Setting Up Category Notifications for New Content - Learn how to get notifications on content
- How to Search and Do Advanced Search - Learn how to get to advanced search and filter options
- Visit our MOSC Resource Center
- Browse all our represented Product Categories
- How to Edit Your Community Username - Details are provided to change your default display name, which will allow for a more personalized profile
- How to Ask a Question and View Answers in the My Oracle Support Community - My Oracle Support Community organization details are provided, which can be used to find the product subcategory for your question
- Community Guidelines
- How to be a good Community Citizen
- Not posting Private Information
- How to be a Community Star
Thanks,
Gail
