Value Chain Planning - EBS (MOSC)

MOSC Banner

ASCP collection hook

edited Sep 2, 2016 5:00AM in Value Chain Planning - EBS (MOSC) 2 commentsAnswered

Hi

I am trying to utilise the collections hook to alter an attribute on the msc_system_items table based on certain criteria.

I have no problem with the coding - just not sure where to add it?

I see two packages - MSCCLCAS.pls & MSCCLCAB.pls - with the procedure CLEANSE as discussed in Oracle's doc > Data Hooks For Manipulating Data in Value Chain Planning (aka APS Advanced Planning and Scheduling) (Doc ID 976328.1)

Can someone please provide me a little guidance ?

The code I want to insert is:

update apps.msc_st_system_items msi

set msi.replenish_to_order_flag = 'Y'

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