Hi,

Steps to Determine the Data Flow from PO to PA:

a.  Is the po_distributions_all.accrue_on_receipt_flag = Y.  If Y, then the R12 intended behavior is to send Receipts.  If N, then invoices should be sent.

b.  If the accrue_on_receipt_flag = Y, then check the ap_invoice_distributions_all.historical flag = Y for the po_distributions_all.PO_DISTRIBUTION_ID in 'a' above.  If the flag is Y, then the PO distribution has been upgraded from 11i.  If this is the case, then whether the receipt or invoice is sent will be based upon which was sent first in 11i (creation_date).  If the receipt was sent first in 11i, then receipts will be sent to PA.  If invoices were sent first in 11i, then invoices will be sent to PA.  

c.  To determine which was sent first, check the creation_date on the first receipt and invoice.  The earlier date will indicate the transaction type transferred.  If the receipt is dated BEFORE the invoice, then receipts will flow to PA...but if invoices are dated BEFORE receipts, then invoices will flow to PA.

Review

R12 Data Flow between Purchasing (PO), Payables (AP) and Projects (PA) when the PO_DISTRIBUTIONS_ALL.ACCRUE_ON_RECEIPT_FLAG = Y (Doc ID 2109264.1)

Regards,
Sadeesh

Hi,

Utilize this script to find the user_id, responsibility_id and responsibility application_id for the user. 

select substr(fnd.user_name,X,XX),
fnd.user_id user_id,
fru.responsibility_id resp_id,
fru.responsibility_application_id resp_appl_id,
frt.responsibility_name
from
fnd_user fnd,
fnd_responsibility_tl frt,
fnd_user_resp_groups_direct fru
where
fnd.user_id = fru.user_id and
frt.responsibility_id = fru.responsibility_id and
fnd.user_name = '&user_name' and
fru.responsibility_application_id = XXX;

The first run of the API will demonstrate updating the Quantity of Line 1 of the PO to 25. Submit the change API using sqlplus as follows :

set serveroutput ON;
DECLARE
l_result NUMBER;
l_api_errors PO_API_ERRORS_REC_TYPE;
BEGIN
-- This needs to be changed according to your environment setup.
FND_GLOBAL.apps_initialize ( user_id => XXXX,
resp_id => XXXXX,
resp_appl_id => XXX );
mo_global.init('PO'); -- need for R12
l_result := PO_CHANGE_API1_S.update_po (
X_PO_NUMBER => &po_num,
X_RELEASE_NUMBER => Null,
X_REVISION_NUMBER => &rev_num,
X_LINE_NUMBER => &line_num,
X_SHIPMENT_NUMBER => &shipment_num,
NEW_QUANTITY => 25,
NEW_PRICE => Null,
NEW_PROMISED_DATE => Null,
NEW_NEED_BY_DATE => Null,
LAUNCH_APPROVALS_FLAG => 'N',
UPDATE_SOURCE => 'API',
VERSION => '1.0',
X_OVERRIDE_DATE => Null,
X_API_ERRORS => l_api_errors,
p_BUYER_NAME => Null,
p_secondary_quantity => Null,
p_preferred_grade => Null,
p_org_id => &org_id
);
dbms_output.put_line ('l_result' || l_result);
IF (l_result <> 1) THEN
-- Display the errors
FOR i IN 1..l_api_errors.message_text.COUNT LOOP
dbms_output.put_line ( l_api_errors.message_text(i) );
END LOOP;
END IF;
END;

commit;

Regards,

Sadeesh