INTFAPAM Creates Wrong Distrib_Seq_Num When Open And Serialized Receivers Are Vouchered.

(Doc ID 2152753.1)

Last updated on JUNE 22, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Intfapam creates wrong distrib_seq_num when open and serialized receivers are vouchered.

STEPS


Scenario I -- serial id is filled on the receiver just for 3 lines from a total of 23

1. Enable Serial Control for Item A006
2. Add a PO for the serialized Item, for Qty 23


- Receiving is required
- Standard Match
- Dispatch PO

3. Add a new receipt.

- Serial Control comes selected.
- Un-check Interface Receipt
- Fill in the serial id's only for 3 assets

4. Save the Receipt without completing all Serial Id's an warning message
appears:

" Item Serial Numbers have not been assigned¿ and the receipt is saved with
status ¿Open¿ and AM status ¿Pending¿

5. Add a Voucher using Copy PO Receipt

Note:

The open receipt is available for selecting and can be copied to the voucher.

6. Voucher has split distributions for the quantity on the receipt.
Asset details are copied to the Voucher with serial Id's being completed only
for 3 lines and without serial id¿s for 20 lines, since no serial id¿s info
has been filled on the receipt
7. Save the voucher
8. Run Matching - voucher matched
9. Post the voucher and load AM (INTFAPAM & AMPS1000)
10. Checking data

- PS_RECV_LN_ASSET - DISTRIB_SEQ_NUM looks ok (1,2,3..23)
- ps_distrib_line - DISTRIB_SEQ_NUM looks ok (1,2,3..23)
- PS_INTFC_PRE_Am - DISTRIB_SEQ_NUM is wrong (1, 2 x20, 3)
- PS_INTFC_PHY_A - DISTRIB_SEQ_NUM is wrong (1, 2 x20, 3)


Scenario II - No serial id has been filled on the receiver

1. Enable Serial Control for Item A006
2. Add a PO for the serialized Item, for Qty 23
- Receiving is required
- Standard Match
- Dispatch PO

3. Add a new receipt.

- Serial Control comes selected.
- Un-check ¿Interface Receipt
- No serial Id's has been entered

4. Save the Receipt without completing the Serial Id's  an warning message  appear

" Item Serial Numbers have not been assigned¿ and the receipt is saved with status Open and AM status Pending

5. Add a Voucher using Copy PO Receipt

Note:
The open receipt is available for selecting and can be copied to the voucher.

6. Voucher has split distributions for the quantity on the receipt as
expected.
7. Save the voucher
8. Run Matching ¿ voucher matched
9. Post the voucher and load AM (INTFAPAM & AMPS1000)
10. Checking data:

- PS_RECV_LN_ASSET - DISTRIB_SEQ_NUM looks ok (1,2,3..23)
- ps_distrib_line - DISTRIB_SEQ_NUM looks ok (1,2,3..23)
- PS_INTFC_PRE_Am - DISTRIB_SEQ_NUM is wrong (1, 2 x22, )
- PS_INTFC_PHY_A - DISTRIB_SEQ_NUM is wrong (1, 2 x22, ) - some ADQ
tranzaction are created

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms