Introduction This Post illustrate steps required to import bank account details of the suppliers in Oracle EBS R12. Script to import Bank account details for suppliers. PROCEDURE create_banks_accounts (p_change_type VARCHAR2)…
Read MoreIntroduction: This Post illustrates the steps required to Fetch Leases which are Expired but not terminated in Oracle EBS R12. Script to Leases Expired but not terminated SELECT GCC.segment4 SOL_ID…
Read MoreBelow 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 MoreYou can find correct jdeveloper version using following link. https://support.oracle.com/portal/ Search as Jdev with OA Extension.
Read MoreBy using following tag we can remove entire column in RTF. <?if@column:ORG_ID!=XXX?>Sales Order/Cust PO<?end if?>
Read MoreBelow 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 MoreBased on the condition we need to disable message choice in CO. OAMessageChoiceBean DispButtonValue = (OAMessageChoiceBean)webBean.findChildRecursive(“Disposition”); String DispValue = DispButtonValue.getText(pageContext); if (DispValue != null) { DispButtonValue.setDisabled(true); pageContext.writeDiagnostics(DispValue, “DispValue——>!!!!!!> = “,…
Read MoreWhen we do import, sometimes we are facing error as Exception in thread “main” java.lang.NoClassDefFoundError: Then you need to change jpximport.bat and import.bat files as below. Path —> \jdeveloper\jdevbin\oaext\bin You…
Read MoreDescription This article describes Report Manager functionality in Oracle R12 which allows users to primarily publish and store Financial Statements/reports that are written using Financial Statement Generator (FSGs). Note that Report Manager…
Read MoreIntroduction: The below query fetches the details of an Invoice along with the HSN Code of a respective item present in an Invoice. GST details can also be fetched. SELECT…
Read More