Tuesday, January 3, 2012

API to update AR Invoice Printing Details in R12 AR_INVOICE_SQL_FUNC_PUB


This API can be used to update the below details of an AR Transaction. I hope this is the only public api available for updating the AR Transaction.

SELECT printing_pending,
       printing_count,
       printing_last_printed,
       printing_original_date,
       last_printed_sequence_num
  FROM ra_customer_trx;


API USED: AR_INVOICE_SQL_FUNC_PUB.UPDATE_CUSTOMER_TRX


SCRIPT:

SET SERVEROUTPUT ON;
DECLARE
   p_choice                   VARCHAR2 (200);
   p_customer_trx_id          NUMBER;
   p_trx_type                 VARCHAR2 (200);
   p_term_count               NUMBER;
   p_term_sequence_number     NUMBER;
   p_printing_count           NUMBER;
   p_printing_original_date   DATE;
   l_print_pend               CHAR (1);
   l_print_last_printed       DATE;
BEGIN
   p_choice                 := 'PRI';
   p_customer_trx_id        := 3001;
   p_trx_type               := NULL;
   p_term_count             := NULL;
   p_term_sequence_number   := NULL;
   p_printing_count         := 1;
   p_printing_original_date := NULL;
  
   AR_INVOICE_SQL_FUNC_PUB.UPDATE_CUSTOMER_TRX
          (p_choice                      => p_choice,
           p_customer_trx_id             => p_customer_trx_id,
           p_trx_type                    => p_trx_type,
           p_term_count                  => p_term_count,
           p_term_sequence_number        => p_term_sequence_number,
           p_printing_count              => p_printing_count,
           p_printing_original_date      => p_printing_original_date
          );

   SELECT printing_pending, printing_last_printed
     INTO l_print_pend, l_print_last_printed
     FROM ra_customer_trx_all rctl
    WHERE rctl.customer_trx_id = p_customer_trx_id;

   DBMS_OUTPUT.put_line ('printing_pending := ' || l_print_pend);
   DBMS_OUTPUT.put_line ('printing_last_printed := ' || l_print_last_printed);
END;


Tuesday, January 3, 2012 by Team search · 0

Monday, January 2, 2012

Payment Process Request (PPR) Status and Descriptions in R12



Payment Process Request is one of the new comers in R12, which normally transitions through the different stages of processing, the PPR will display a "Status" to let you know where in the process the PPR has progressed to, and what's going on with it. There are more number of statuses associated with PPR. Here in this post we tried to give most witnessed statuses and their details.

PPR PROCESS STATUSES
Description
NEW
This status indicates that the PPR has been successfully submitted for processing, and the AutoSelect program is digesting the criteria provided by the user on the header of the PPR in preparation of the automatic selection the invoices and memos related to that criteria.
SELECTING INVOICES
This status indicates that the AutoSelect program is selecting the eligible invoices/memos for the payment batch based on Due Date, Discount Date, Pay Group, and other criteria provided by the user on the header of the PPR
CANCELLED - NO INVOICES SELECTED
If no invoices or memos met the selection criteria provided by the user on the header of the PPR, the PPR is automatically terminated and the status changes to this status.
MISSING..." STATUSES
Other statuses may appear at this point in the process if the user failed to included required information on the PPR header, such as "Missing Exchange Rates", etc.
INVOICES SELECTED
After selecting the documents (invoices/memos), they are locked to prevent other checkruns from selecting the same documents
INVOICES PENDING REVIEW
This status will only appear if you selected the "Stop Process for Review After Scheduled Payment Selection" option on the Processing tab of the PPR header. This status means that the PPR process has stopped, and is waiting for you to review the invoices and memos that were selected for payment (and make any changes to the batch, as needed). Click on the Take Action icon to be taken to the Review Proposed Payments window
CALCULATING SPECIAL AMOUNTS
This status will only appear if you selected the "Calculate Payment Withholding and Interest During the Scheduled Payment Selection" option on the Processing tab of the PPR header. This status means that interest and withholding tax are being calculated and applied, as necessary, to the invoices and memos selected for this payment batch
ASSEMBLING/ASSEMBLED PAYMENTS
An "interim" status, it appears after the calculation for interest and withholding has been completed, and the Build Payments program is starting. It may appear again later after the user provides any required bank account and PPP information for the invoices/memos ("documents") selected
INFORMATION REQUIRED - PENDING ACTION
This status appears if you did not provide a default Internal (Disbursement) Bank Account and/or PPP on the header of the PPR. In that case, you need to click on the Take Action icon to be taken to a form where you can decide which internal bank account and PPP should be used for each invoice and memo selected for payment
PENDING PROPOSED PAYMENT REVIEW
This status will only appear if you selected the "Stop Process for Review After Creation of Proposed Payments" option on the Processing tab of the PPR header. In this case, the system is waiting for you to review (and modify, if needed) the proposed payments for this batch. Click on the Take Action icon to be taken to the "Review Proposed Payments" window
FORMATTING
This status indicates that the proposed payments have been turned into payment instruction files. At this point, you will want to click on the Show link to view the new associated payment instruction file(s). Each payment instruction file with have their own PI Reference Number. If you have both electronic and paper ("check") payments involved in this payment batch, you will see a payment instruction file for each type of payment method
CONFIRMED PAYMENT
Once the payment instructions have been transmitted/printed and confirmed, the Status of the PPR changes to this status to indicate a successfully completed payment batch (PPR)
TERMINATED
If the user terminates a PPR anytime prior to confirmation of the payments (using the Terminate icon), the status will change to "Terminated", and the PPR is permanently closed




Monday, January 2, 2012 by Team search · 1

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.