DECLAREl_msg VARCHAR2(2000) := NULL;x_message_list Error_Handler.Error_Tbl_Type;x_return_status VARCHAR2(100);x_msg_count NUMBER := 0;l_rowcnt NUMBER := 0;x_session_key NUMBER;x_return_msg VARCHAR2 (2000);x_errors po_asl_api_error_rec;l_n_purchasing_org_id NUMBER := NULL;l_n_bec_org_Id NUMBER := NULL; l_api_version NUMBER := 1.0; l_init_msg_list VARCHAR2(2) := FND_API.G_TRUE; l_commit VARCHAR2(2) := FND_API.G_TRUE; --Table type to update the must_use_approved_vendor_flag l_item_tbl_typ ego_item_pub.item_tbl_type; x_item_table ego_item_pub.item_tbl_type; --Table type to do the substitute item assignment l_item_org_assignment_tbl EGO_ITEM_PUB.ITEM_ORG_ASSIGNMENT_TBL_TYPE; --Cursor… Continue reading ASL Creation – Copy from One Inv Org to Another
Category: Oracle Fusion
Account Payables Invoice Query In Oracle Fusion
AP Invoice is something Oracle used to pay the supplier for the goods or the services provided by them. You can say that creation and payment of AP Invoice is the last leg in P2P Cycle. So if you have implemented P2P Cycle, chances are that you will need to use Account Payables Invoice query… Continue reading Account Payables Invoice Query In Oracle Fusion
POZ_SUPPLIERS: Supplier Table In Oracle Fusion
POZ_SUPPLIERS is the table used by Oracle Fusion to store the data related to supplier. Supplier is someone you use to source the material or the services from, so it makes supplier one of the key entities in your business. So if you have implemented Purchasing/ Payables or P2P Cycle, it is inevitable that you… Continue reading POZ_SUPPLIERS: Supplier Table In Oracle Fusion
REGEXP_REPLACE In Oracle With Real Life Example
REGEXP_REPLACE: How to use the function in Oracle to replace a pattern with a predefined value along with a real life example.
REGEXP_INSTR in Oracle With Example
REGEXP_INSTR in Oracle: Syntax and Real Life example to better understand and implement in a query to find the special character position