Special characters validation
For any field if you want throw any exception when entered any special characters. We need to use following pattern to find. Pattern p = Pattern.compile(“[^a-zA-Z0-9\\s]”);
Read More500 Internal error in OAF
Once any environment get refreshed in EBS, a new dbc file will be generated. Some times we will receive 500 internal error. To over come this we need to replace…
Read MoreCalling External URL in new Tab
When we calling any external URL from OAF page, we need to add destination URI as below. So URL will open in new tab with same browser. javascript:var a =…
Read MoreDisplaying Number of characters entered in text field
In OAF page, if user want to know how many characters entered in message text input field. Below is the code we need to use in process request. String…
Read MoreCalling External URL in a New window
Suppose if we want to call any external URL in OAF page. So you can call as like below. urlname = https://www.google.com/ pageContext.sendRedirect(urlname);
Read MoreDelete Empty Customization
Same Page is working for one user and is not working for another user. In this case sometimes due to some empty customization this issue will occur. You can run…
Read MoreAP Invoice Payments API
Below is the package you can download for AP Invoice Payments. ap-invoice-payments-api
Read MoreExpected Shipments in PO
Below is the query for getting expected shipments in Oracle Purchasing. SELECT reqh.type_lookup_code, reqh.requisition_header_id po_header_id, rsl.requisition_line_id po_line_id, rsl.req_distribution_id po_distribution_id, reqh.segment1 po_number, msi.segment1 AS item_code, rsl.item_description, rsh.shipment_num, rsl.line_num shipment_line_number, rsl.quantity_shipped expected_receipt_qty,…
Read MoreCovert to Operating Unit Timezone
Below is the function to get current operating unit Timezone. FUNCTION convert_to_ou_tz(p_date DATE, p_org_id NUMBER DEFAULT fnd_global.org_id) RETURN DATE IS l_timezone VARCHAR2(50); l_new_date DATE; BEGIN SELECT attribute8 INTO l_timezone FROM…
Read MoreBursting Control file using filter condition
Below is the command we can use filler in XML Publisher Data Template. <?xml version=”1.0″ encoding=”UTF-8″?> <xapi:requestset xmlns:xapi=”http://xmlns.oracle.com/oxp/xapi” type=”bursting”> <xapi:request select=”/METADATA/ROWSET/ROW”> <xapi:delivery> <xapi:email server=”XXXXXXX” port=”XX” from=”DoNotReply@XXXXXX.com” reply-to=”DoNotReply@XXXXXX.com”> <xapi:message id=”email1″ to=”${TO_MAIL}”…
Read More