People and Culture Blog

Checking The performance & Advantage of using BULK COLLECT

SET SERVEROUTPUT ON DECLARE TYPE t_bulk_collect_test_tab IS TABLE OF bulk_collect_test%ROWTYPE; l_tab t_bulk_collect_test_tab; CURSOR c_data IS SELECT * FROM bulk_collect_test; l_start NUMBER; BEGIN — Time a regular cursor for loop. l_start…

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

PO Promise Date/Need By Date Automation Based on Date Entered

This Blog is used to automate PO Promise Date/Need By Date Based on Date Entered in PO Line level/Shipment level by using Form Personalization Please follow the steps as per…

Read More

Oracle EBS – Query to get MultiOrg Info

————————————————————————————– Oracle EBS – Query to get MultiOrg Info ————————————————————————————– ————– Execute the below query into EBS database.—————————————- SELECT mp.organization_code org_code, org.organization_id org_id, org.NAME org_name, hl.location_id, hl.location_code, hl.address_line_1, hl.address_line_2, hl.address_line_3,…

Read More

WEBADI for Asset upload in EBS

web-adi-fa-loading-process     This document will explain how user can upload fixed asset using web Adi process.  How to Effectively Upload Data To Oracle Applications With Web ADI 

Read More

Translation

Translationtranslation

Read More

Charge Back

charge-back

Read More

User has closed FA Corp Books for Jul-23 Period, and after closing it, oracle cloud should show the Aug-23 month, But it is showing Sep-23 as below

User has closed FA Corp Books for Jul-23 Period, and after closing it, oracle cloud should show the Aug-23 month, But it is showing Sep-23 as below That means Aug’23…

Read More