Receivables - EBS (MOSC)

MOSC Banner

AR Lockbox is not importing in the same order as the file.

edited May 8, 2017 5:03AM in Receivables - EBS (MOSC) 1 commentAnswered

How can i get the records imported in the ar_payments_interface table in the same order as presented in my inbound file

Here is how my input file looks:

1 = File header

2- Service header

5 - batch header

6 - check header

4 - check details

7 - Batch trailer.

However when the records are imported, they are imported as show in the screen below: i added attribute 15 as a seq.nextval in the ctl file

100DCB       00710000131704101200

2DCB       0071000013000000000040008000802

54130000023013170408DCB       0071000013

6413001000000046704012100024841230180610000000000076430

44130016019 2030008                       0000000467040

6413002000000172226401111070100095170220000000001027468

44130026010 2031614                       0000002299981

44130026020 VAR153980                     -000000269077

44130026030 VAR153994                     -000000198000

44130026040 VAR154030                     -000000110490

44130026059 VAR154443                     -000000000150

6413003000000065580806530027948004486880000000000735068

44130036010 2032029                       0000000699031

44130036020 0031504                       -000000006132

44130036039 0031505                       -000000037091

6413004000000025992506530027948004486880000000000735116

44130046010 2032027                       0000000561343

44130046020 0031644                       -000000125443

44130046039 0031645                       -000000175975

741300000230131704080040000003105037

54150000023013170409DCB       0071000013

6415001000000018738706111278833594816890000009000397743

44150016019 791611                        0000000187387

6415002000000329236410121901750080012940000000002884359

44150026019 2031861                       0000003292364

6415003000001437535208121853600001266910000000001510265

44150036010 0231665                       0000004483372

44150036020 02031666                      0000004126838

44150036030 02031667                      0000005771786

44150036040 DE-2383747                    -000000002718

44150036059 DE-2388268                    -000000003926

6415004000000653150306120975699400070660000000000752974

44150046010 2031045                       0000000780157

44150046020 2032057                       0000001918620

44150046030 2032197                       0000001914106

44150046049 2032198                       0000001918620

6415005000000338420105310156199005677370000000001373157

44150056010 2031373                       0000000911570

44150056020 0124727                       -000000182350

44150056030 0124719                       -000000005770

44150056040 2032380                       0000002745102

44150056059 0092166                       -000000084351

6415006000000098993702100002106056556250000000000003815

44150066019 2031992                       0000000989937

741500000230131704090060000028760744

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

EBS Receivables Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center