Posts by Yarraguntla Surendra

Oracle EBS – Archive the file with Script

By using the bleow script, we can archive the file from specific folder to back up folder in the server location.   # =============================================================================+ export ora_login=$1 export ora_userid=$2 export login_name=$3…

Read More

SERVICE CONTRACT – Oracle External Table

This is the sample script to create the oracle external table to access the data from the file. prompt prompt creating TABLE XX_SC_EXT …..   CREATE TABLE “XX”.”XX_SC_EXT”    (…

Read More

Service Contract line price Adjustment Issue while modified the prices user manually.

Use the okc_price_adjustment_pub.create_price_adjustment API with appropriate input values to effect the adjusted prices manually.

Read More

Service Contract Header amount total field is not affected while user manually update the price or quantity in line level.

Use the oks_auth_util_pvt.check_update_amounts API to refresh the header amount after the line level modifications.

Read More

Service Contract Interface – Billing schedule issue where the amount field was not showing at stream level.

Parameter p_billing_sch needs to be passed as E instead of T to the API Create_Bill_Schedule API.

Read More