Best Of
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.
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