Delete 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 MoreOAF Personalization for IFSC Code in Supplier Screen
Below is the document you can download for IFSC Code. oaf-pesonalization-for-ifsc-code-in-supplier-screen
Read MoreFinding Source Code for Java Class Files
JAD is one of the tool for getting source code the java classes.
Read MoreHow to find out correct version of Jdeveloper
You can find correct jdeveloper version using following link. https://support.oracle.com/portal/ Search as Jdev with OA Extension.
Read MoreRemove Entire column in RTF Template
By using following tag we can remove entire column in RTF. <?if@column:ORG_ID!=XXX?>Sales Order/Cust PO<?end if?>
Read MoreSales Order Update
Below is the standard API to update sales order deliver to information based on shipment method. Shipment method & deliver to information are maintaining in custom table. oe_order_pub.Process_Order is the…
Read More