Best Of
Sales Order Cancellation with Approval Process
Hi All,
Does JDE sales order module with cancellation approval hierarchy process? We found order being cancel by users and we need to control them to cancel the order without approval.
Any idea or recommendation?
Thanks
Regards,
Heng
Re: We are using ISO 20022 format in R12 and we wanted to default Bank Instruction 1 Field to populate
Hi Murali,
Please refer below documents which can helpful:
How to Modify Benefits Templates Using Oracle BI Publisher (Doc ID 391397.1)
R12: IBY/AP Available Approaches to Achieve Format Customization in Oracle Payments for Oracle Applications Release 12 (Doc ID 787467.1)
R12:AP/IBY Understanding XML Payment Templates and Formats (Doc ID 562806.1)
Regards,
Srinivas
Re: How to Trace OV Transactions to General Ledger Entries?
The journal entries can be found in the F0911 table.
The F43121 has fields Document Number & Document Type (DOC & DCT). Once you know the DOC & DCT values, you can use these values to find the DOC number in the F0911.
Also, you can use the order number to find the F0911 records.
If the PO number is 1234, then you would search the F0911, field GLPO using '00001234' to find the records for this PO. There of course, could be other receipts for this order, so those records would show in this query, but would also show the various OV numbers so you could match up to the correct records. (Note, you must enter the leading zeros to fill the 8 digit field when searching on GLPO.)
Hopefully this gives you what you need to find your F0911 journal entry records.
Dennis - Oracle Support
Re: How can I get all 9 digits of precision in systimestamp?
So far not getting anything too helpful from my SR w/Oracle. The support fellow can reproduce my issue, and gave me the info I already had for seeing it at the OS level, and also mentioned:
"There is a limitation in the database for displaying the 9 digits."
which seems goofy - why offer 9 digits if I can't actually use them? Anyway, will keep y'all posted. :) Thanks.
Re: We are using ISO 20022 format in R12 and we wanted to default Bank Instruction 1 Field to populate
Hi Murali,
Define a variable in payment template (.xsl file) and assign Bank Instruction from site value to variable and then populate variable value for <InstrForDbtrAgt/> field.
Find the below sample syntax for define "instrid" variable and assign variable to a <MsgId> field.
Regards,
Anjana
Re: OEM - Upgrade from 13.4 to 13.5 - Ignore Database Prerequisite Check via ConfigureGc.sh
You are Welcome. Have a nice day
Re: When trying to approve an adjustement in receivable, an error message is appearing :" it is not poss
Hi
Make sure you check approval limit for currency as well as check for amount range.
You may have created Adjustment in -ve amount but approval limit may be in +ve amount.
So make sure that -ve amount is also covered in the Approval limit.
Best Regards,
Bharat
Re: is Unpublished Bug 35243332 filed with Java 17.0.5 is fixed
Hello Michael,
Thank you for response and help with the font issues. we already tried clientDPI settings. Modified clientDPI to 90% of our original in formsweb.cfg still fonts are not properly displayed (blurred). Will remove clientDPI setting and try with two scale settings you mentioned in your response
Currently we are using forms version 12.2.1.4 . and java run version (JAVA_VERSION="1.8.0_221") and our application is launched with java webstart. As JAVA webstart is removed from JDK and JRE is not available in the future versions , we want to test Forms Standalone (FSAL) solution . (Note: forms server on linux same java version 1,8) .
With JAVA run version 1.8… application launch with FSAL is working without any issues;
but with new versions of JDK we are encountering font issues (not properly scaled and has blurring issues). We thought these issues are resolved with JDK 21 but encountering same font issues.
Any other suggestions to resolve the font issue will be appreciated
Once again thank you for your help
Sridhar
Re: where can i find doc id 2038801.1 ?
Hi @User_0K1G3 ,
The outage reported overnight has been resolved, so the document should be accessible to you now.
Have a great day,
Jennifer B.
My Oracle Support Community Administrator
Workaround for Editing Expense Accounting Details from the modal page EX_SHT_FAPDIST_FL
Has anyone found a way to allow an approver (that has the right privilege template) to edit the accounting details from this link on this page:
We find that having to go into the Expense Details of a transaction to change the Accounting is a significant slow down for our approvers. Perhaps this belongs in the Idea Space if this is currently working as intended.



