Payables and Cash Management - EBS (MOSC)

MOSC Banner

Supplier Site Banking Details Update Via API

edited Jan 27, 2016 8:24AM in Payables and Cash Management - EBS (MOSC) 5 commentsAnswered

I have approximately 750 suppliers that have existing "Banking Details" attached to the supplier site.  For each supplier, the currently existing banking details record needs to be end-dated and a new banking details record needs to be created.

After reviewing several MOSC discussions and MOS documents, I came to the conclusion that this should be possible via API.  I have created the SQL script below to test this out on one supplier.  The script executes successfully, however it does not actually create a new banking details record in the database/application.  Does anyone see any issues with my script, or have other suggestions as to why a new banking record is not being created?

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 Payables 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