Best Of
Re: Can the Branch Number be added to the Search External Bank Account Assignment search screen?
Hi @User_3XYJE,
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 EBS Customizations (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
Re: API/Interface table to create "Resources" in BOM in oracle apps R12 with application version 12.2.9
Please review below notes for new APIs available -
12.2.11: New APIs For Associating Resources Instances (BOM_RES_PUB), Department Resource Instances (BOM_DEP_PUB) and Creating Standard Operations With Resources and Alternate Resources (BOM_STD_OP_PUB) (Doc ID 3006643.1)
To load departments (BOM_DEP_PUB.Process_Department) and resources (BOM_RES_PUB.process_resources) there is also an enhancement implemented in 12.2.14 :
12.2.14: How To Use New Public APIs To Load BOM (Bills of Material) Departments And Resources? (Doc ID 3020900.1)
Sample scripts are provided in the notes.
Re: Why does receipt show as a "Receipts at Risk" on Credit Case Folder when it has a status of Cleared.
Thanks John we'll give that a try and let you know
Re: Non-adoption of PeopleSoft Workflow Engine (AWE) by FIN Asset Team
You need to message @ tina t - Oracle. She's the Asset Management functional side and can help make it work as intended. Point her to this post. It seems complete.
Re: Generate QR Code for AR Invoice for Saudi Arabic BI Publisher report
Hello,
Please review Note 2820494.1 - E-Business Suite R12: Saudi Arabia Electronic Invoicing, December 2021 :
"For QR code creation
- Oracle E-Business Suite does not support the generation of QR code itself, but standard AR e-invoice extract includes all the data elements required. Customer can leverage third party software alternatives to generate and embed the QR code in invoices
- Saudi Arabia requires the QR code to be encoded Base64 and in TLV(tag-Length-Value) format. The data would be converted to hex and then encoded in Base64.Oracle EBS supports this
- Utilities and functions like UTL_RAW.CAST_TO_RAW (to cast a VARCHAR2 value into a RAW value),RAWTOHEX (to convert raw to a character value containing its hexadecimal representation), UTL_ENCODE.BASE64_ENCODE (to convert to BASE64 encoded form) etc. can achieve this .
- By way of guidance and as an example, the following string could be built to be passed to the QRcode BIP function
- SELECT
- UTL_RAW.CAST_TO_VARCHAR2
- (
- UTL_ENCODE.BASE64_ENCODE
- (
- '01' || TRIM(TO_CHAR(LENGTHB('فاتورة ضريبية مبسطة'),'0X')) || RAWTOHEX(UTL_RAW.CAST_TO_RAW('فاتورة ضريبية مبسطة')) ||
- '02' || TRIM(TO_CHAR(LENGTH('310122393500003'),'0X')) || RAWTOHEX(UTL_RAW.CAST_TO_RAW('310122393500003')) ||
- '03' || TRIM(TO_CHAR(LENGTH('2022-04-25T15:30:00Z'),'0X')) || RAWTOHEX(UTL_RAW.CAST_TO_RAW('2022-04-25T15:30:00Z')) ||
- '04' || TRIM(TO_CHAR(LENGTH(TRIM(TO_CHAR(1000.00,'99999999.99'))),'0X')) || RAWTOHEX(UTL_RAW.CAST_TO_RAW(TRIM(TO_CHAR(1000.00,'99999999.99')))) ||
- '05' || TRIM(TO_CHAR(LENGTH(TRIM(TO_CHAR(150.00,'99999999.99'))),'0X')) || RAWTOHEX(UTL_RAW.CAST_TO_RAW(TRIM(TO_CHAR(150.00,'99999999.99'))))
- ))
- "qr_code" FROM dual
"
Regards,
Nanzy
FRM-41830 List of Values Contains No Entries
While trying to Search for KFF (Key Flex Field) or Value Set from GL>Setup>Financials>Felx fields>Key>Values>Find Key Flex field Segment, Unable to get any Values from LOV
Getting the error message- FRM-41830 List of Values Contains No Entries
Re: How do you print a page from PeopleSoft?
Hello User,
PeopleSoft has given option to print page, in your PeopleBook you can check this navigation:- Development Tools >> Portal Technology >> Configuring the Portal Environment >> Configuring Web Profiles
Enable Print
Enables or disables the Print link in the pagebar site wide:
Select to enable the Print link in the pagebar for components that have the pagebar enabled.
Do perform this activity:-
In the webprofile General tab, select the Enable Print and save.
Restart PIA and this should show print button on top right corner.
Thanks,
Akash
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.