Payables and Cash Management - EBS (MOSC)

MOSC Banner

ap_invoices_interface_s.NEXTVAL is used to insert into ap_invoices interface

Does Oracle use a different sequence id for Invoice Id in AP invoices all?

ap_invoices_interface_s.NEXTVAL is used to populate the interface table. We have many operationg units having invoice interface being used. recently I am getting an issue:

Inetgration orchestratiion connects to oracle database in the custom schmea and in the orchestration flow they use the oracle sequence ap_invoices_interface_s.NEXTVAL to load invoices into a staging table. From the staging table we already have invoice id and we are just reading that invoice id and writing to the ap invoices interface table. We are getting unique constraint error. since we are using ap_invoices_interface_s.NEXTVAL we ae of the opinion we should not be getting this error.

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