Introduction:- Using the below SQL script we can get the Catalog and Non Catalog Po’s details from country wise. Code:- SELECT P.SEGMENT1 “PO Number” ,PL.LINE_NUM “PO Line”,TO_CHAR(P.CREATION_DATE,’DD-MON-RRRR HH24:MI:SS’) “PO Created…
Read MoreIntroduction Business requested to provide the Payment reversal information Cause of the issue: Business want to cross check with Payment reversals How do we solve: We have created…
Read MoreIntroduction Business requested to provide the date for AR Adjustments for a particular period Cause of the issue: Business want to tally the data with uploaded Adjustments. How…
Read MoreIntroduction: This SQL query is used to fetching the data of Customer contact details like Customer Name, Contact Name, Email Address Contact Number and Dunning Letters etc… In this…
Read MoreIntroduction: This SQL query is used to fetching the data of Customer CIF information to identify whether we have any duplicate CIF numbers exists or not. Cause of…
Read MoreUsing 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 MoreUsing 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 MoreBy 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 MoreThis 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 MoreBy 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 More