Problem You can’t get a clean page break on your document. Word page breaks don’t work, and the official guideline doesn’t work. http://docs.oracle.com/cd/E12844_01/doc/bip.1013/e12187/T421739T481157.htm#pgebreaks In the template sample shown in the following figure, the field called PageBreak contains the split-by-page-break syntax: Place the PageBreak field with the <?split-by-page-break:?> syntax immediately before the <?end for-each?> field. The PageBreak field sits inside the end of the SUPPLIER loop. This will ensure a page break is inserted before the occurrence of each new ..read more

The Below query is very useful if you want to see the pending notifications in the database. SELECT wno.* FROM (SELECT o.deq_time deq_time, o.enq_time enq_time, DECODE (o.state, 0, 'PENDING', 2, 'EMAIL SENT', 3, 'EXCEPTION', o.state ) state, TO_NUMBER ((SELECT str_value FROM TABLE (o.user_data.header.properties) WHERE NAME = 'NOTIFICATION_ID') ) p_notification_id ..read more

Get the Account Description: SELECT apps.gl_flexfields_pkg.get_description_sql(&char_of_account_id, 1, gcc.segment1) seg1, gl_flexfields_pkg.get_description_sql(&char_of_account_id, 2, gcc.segment2) seg2, gl_flexfields_pkg.get_description_sql(&char_of_account_id, 3, gcc.segment3) seg3 ..read more

SELECT distinct pv.vendor_id, pv.segment1, pv.vendor_name, pvsa.vendor_site_code, decode(pvsa.STATUS, ‘I’, ‘Inactive’, ‘A’, ‘Active’) Site_Status, pvsa.pay_group_lookup_code, pvsa.address_line1, pvsa.country, (select LISTAGG(hcp.phone_area_code || ‘ ‘ || hcp.phone_number, ‘, ‘) WITHIN GROUP (ORDER BY hcp.phone_area_code || ‘ ‘ || hcp.phone_number) from hz_contact_points hcp, hz_party_sites hps, hz_relationships hzr, HZ_CONTACT_POINTS hcpp, hz_parties hzp where hps.party_id = pv.party_id AND hcp.owner_table_id = hps.party_site_id AND hcp.primary_flag = ‘Y’ AND hcp.owner_table_name = ‘HZ_PARTY_S ..read more

Important Terminologies Configuration Personalization Extension Customization Deployment Architectural Components of OAF BC4J UIX AOL MDS BC4J It stands for Business Components For Java,it is a Component that relate SQL Database concepts to the java world like View with View Objects (VO) Table with Entity Objects (EO) Transactions with Application Module (AM) It is the model layer of the MVC Design Pattern. UIX It stands for User Interface XML ,it is an oracle standard and it allows creation of User interface (UI) Objects Through the use of XML. This removes the need ..read more

The below code will add rent increase for provided Lease declare -- Non-scalar parameters require additional processing p_rent_index_rec pn_index_rent_pvt.rent_index_rec; p_index_constraint_tbl pn_index_rent_pvt.index_constraint_tbl; p_api_version NUMBER := 1.0; p_init_msg_list VARCHAR2(1) := 'F'; v_bank_id NUMBER := 530705; x_return_status VARCHAR2(2000); x_msg_count NUMBER(5); x_msg_data VARCHAR2(2000); x_branch_id NUMBER; p_count NUMBER; begin begin pn_mo_cache_utils.fnd_req_set_org_id(127); fnd_global.apps_initialize(user_id => 6082, resp_id => 21513, resp_appl_id => 240 ..read more

This API is really simple because you only need Name and Number of Vendor to execute this API. Let’s have a look on the Code. DECLARE l_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type; l_return_status VARCHAR2(10); l_msg_count NUMBER; l_msg_data VARCHAR2(1000); l_vendor_id NUMBER; l_party_id NUMBER; BEGIN -- Required l_vendor_rec.segment1 := '0000235916'; l_vendor_rec.vendor_name := 'TEST_SUPP'; -- Optional l_vendor_rec.match_option := 'R'; pos_vendor_pub_pkg.create_vendor( -- ------------------------- -- Input Parameters -- ------------------------- p_vendor_rec => l_vendor_rec ..read more

We always need sql query for data extraction in almost all the modules that we use in Oracle EBS. So today I am writing this post to create a view in Oracle Property Manager for fetching lease data. Tables used in this query are PO_VENDORS FND_LOOKUPS PN_LEASES_ALL PN_PAYMENT_SCHEDULES_ALL PN_PAYMENT_TERMS_ALL PN_PAYMENT_ITEMS PN_DISTRIBUTIONS_ALL PN_PAY_GROUP_RULES CREATE OR REPLACE VIEW XX_LEASE_EXP_DETAILS_V AS SELECT pnpi.export_to_ap_flag export_to_ap_flag, TO_CHAR (NULL) export_to_ar_flag, pnpi.transferred_to_ap_flag transferred_to_ap_flag, TO_CHAR (NULL) transferred_to_ar_flag ..read more

Today I will show you how to delete workplan cost codes from Tasks that are wrongly added in project. Basically I have added cost codes in tasks but unfortunately wrong cost codes were added along with correct ones so I am deleting those. I am deleting those cost codes by using a select statement as per my criteria but you can use your select criteria for deletion. Oracle Project Cost Codes Deletion using API DECLARE L_API_VERSION_NUMBER NUMBER := 1.0; L_COMMIT VARCHAR2(1) := 'F'; L_RETURN_STATUS VARCHAR2(1); L_INIT_MSG_LIST VARCHAR2(1) := 'F'; L_MSG_COUNT NUMBER; L_MSG_INDEX_OUT ..read more

Error <1584529807716> <Uncaught Throwable in processSockets java.io.IOException: DP_POLL failed for /dev/poll - [No such device or address (6)]. java.io.IOException: DP_POLL failed for /dev/poll - [No such device or address (6)] at weblogic.socket.DevPollSocketMuxer.doPoll(Native Method) at weblogic.socket.DevPollSocketMuxer.processSockets(DevPollSocketMuxer.java:95) at weblogic.socket.SocketReaderRequest.run(SocketReaderRequest.java:29) at weblogic.socket.SocketReaderRequest.execute(SocketReaderRequest.java:42) at weblogic.kernel.ExecuteThread.execute(E ..read more