PL/SQL (MOSC)

MOSC Banner

How to write package that will use batch source and generate transaction number

in PL/SQL (MOSC) 2 commentsAnswered

Guru's

I have developed a package that has two procedures. One to load AR transaction data in a staging custom table and a second procedure to import the data from the custom staging table into the interface tables.

With this I have developed an integrator that allows me to load the data into the staging table. This part of the package works well. It is to be noted that my batch source I am using is setup to do autonumbering for the transaction number.

My issue is I dont know how to deal with the numbering aspect in the second part of the package? The package I have is for when you actually have to specify a transaction number so I need to change the procedure to cater for the autonumbering batch and this is where I am facing a problem. How to achieve this??

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center