Query to fetch dunning contact for customer
Using below query we can get dunning contact information. SELECT account_number customer_number, party_name customer_name, ( SELECT LISTAGG(party_name, ‘,’) WITHIN GROUP( ORDER…
Read MoreQuery to update payment terms for supplier site
Using Below script we can update payment terms for suppliers. DECLARE p_customer_profile_rec hz_customer_profile_v2pub.customer_profile_rec_type; xin_xout_object_version_number NUMBER; x_return_status VARCHAR2(2000); x_msg_count NUMBER; x_msg_data VARCHAR2(2000); …
Read MoreHow to write DDL statement in OAF
By using below script we can perform ddl statement in Application Module. public void OTCancel() { OnetimeVOImpl delvo = getOnetimeVO1(); Row row[] = delvo.getAllRowsInRange(); OADBTransactionImpl oadbtransactionimpl = (OADBTransactionImpl)getDBTransaction(); for (int…
Read MoreInvalid Column Type error in OAF
This error occurred in OAF when I added the new export button to table layout region. For this error just right click on our VO (View Object) and select Edit.…
Read MoreHow to disable field based on parameter value
By using following script we can get parameter value in page level. Based on value we can set rendered property for the fields as follows: public void processRequest(OAPageContext pageContext, OAWebBean…
Read MoreHow to terminate instance number in Install Base
Using below script we can terminate instance number in Install Base. UPDATE csi_item_instances SET active_end_date = SYSDATE WHERE instance_id = l_instance_id;
Read MoreJava script validation in OAF
By using below java script in OAF. we can validate based on field value and can throw error. var colspt2 = ‘quoteValidate’.split(\”^\”); for (var k = 0; k < colspt2.length…
Read MoreHow to set default value for Message Text Input
By using below command in controller, we can able to set default value to message Text Input. import oracle.apps.fnd.framework.webui.beans.message.OAMessageTextInputBean; public void processRequest(OssAPageContext pageContext, OAWebBean webBean) { super.processRequest(pageContext, webBean); String…
Read MoreSubmission of Concurrent request from OAF
Consider a scenario like we need to submit a concurrent request when submit button in clicked. Code to submit concurrent request should be added in AM so that it can…
Read MoreStale Data Error in OAF
Sometimes when we perform multiple transactions to EO, we may get error like below. Solution: Open the EO of the table. Navigate Attribute property of the primary key of the…
Read More