Oracle Blogs

  /fscmRestApi/resources/11.13.18.05/receivablesCreditMemos/ If this REST API does not GET all the credit memo ... follow below steps. You can use GET operations to process standard credit memos. To use the Receivables Credit Memos REST resource for processing standard credit memos, you must enable the AR_STD_CM_REST lookup code. Here’s how to enable AR_STD_CM_REST : In the Setup and Maintenance work area, go to the Manage Receivables Lookups task. Query for the lookup type AR_FEATURES . Under AR_FEATURES , create the lookup code AR_STD_CM_REST and enable it.  

 DECLARE    CURSOR cur_all_trx    IS           SELECT ROWID,              NULL PARTY_NUMBER,              RCT.ORG_ID,              RCT.CUSTOMER_TRX_ID,              RCT.TRX_NUMBER         FROM XX_DELETE_TRANSACTION RCT        WHERE NVL (V_RET_STATUS, 0) <> 'S'          AND TRX_NUMBER = 'inv';            xv_msg_data     VARCHAR2 (4000) := NULL;    xv_msg_count    NUMBER := 0;    v_msg_index     NUMBER := 0;    xv_ret_status   VARCHAR2 (1) := NULL;    v_message_tbl   arp_trx_validate.message_tbl_type;    v_res           VARCHAR2 (4000) := NULL;    v_res_na...

 select * from po_headers_all / set serverout on; declare   /**********************************************************************   I_ACTION ==>   *********************************************************************/   V_STATUS VARCHAR2(100); --For check this HEADER_ID Status. (Is 'INCOMPLETE' ?)   V_RETURN_CODE VARCHAR2(1) := 'S'; --Process status code ==> S : Success / E : Error   V_RETURN_MSG  VARCHAR2(2000); --Error message   V_ITEM_KEY  VARCHAR2(200); --For API   V_ITEM_TYPE VARCHAR2(20);   V_SEGMENT1           PO_HEADERS_ALL.SEGMENT1%TYPE; --For API   V_PREPARER_ID        PO_HEADERS_ALL.AGENT_ID%TYPE; --For API   V_DOCUMENT_TYPE_CODE PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE; --For API   V_DOCUMENT_SUBTYPE   PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%type; --For API   I_HEADER_ID number; -- PO_HEADER_ID   V_ORG_ID number;   ...