People and Culture Blog

API to Check the Available credit On a Sales Order.

DECLARE l_header_id NUMBER; l_calling_action VARCHAR2 (200); l_msg_index NUMBER; l_error_message VARCHAR2 (2000); x_msg_count NUMBER; x_msg_data VARCHAR2 (200); x_result_out VARCHAR2 (200); x_return_status VARCHAR2 (200); BEGIN l_header_id := 885421; l_calling_action := ‘BOOKING’; x_msg_count…

Read More

API TO CANCEL PO invoice

API TO CANCEL PO invoice AP_CANCEL_PKG.IS_INVOICE_CANCELLABLE: —- CREATE OR REPLACE PROCEDURE XXDOYEN_INV_CANCELLABLE (p_inv_id IN NUMBER) is v_boolean BOOLEAN; v_error_code VARCHAR2(100); v_debug_info VARCHAR2(1000); begin v_boolean :=AP_CANCEL_PKG.IS_INVOICE_CANCELLABLE( P_invoice_id => p_inv_id, P_error_code =>…

Read More

Ways to Embrace Hybrid Cloud with the Oracle Cloud Infrastructure (OCI)

We are living in a time where automation takes over the human workforce to simplify the process. Many businesses have started to adapt to this culture and are aware of…

Read More

Working With Nested Table Oracle

1. Overview This document talks about the steps to working with Oracle nested tables.Nested table is awesome feature of Oracle. You can create table inside a table, Which means one column can…

Read More

Oracle AP Month End Close Request Set

1. Login to Oracle Enter User Name and Password and Click – Login SELECT System Administrator Responsibility and Press OK Button GO to Requests : Select  -> Set Enter Request…

Read More

Difference between AR and GL

User reported that they are getting differences in GL and AR for particular accounts. we noticed that the user is comparing with the custom reports like AR ageing and GL…

Read More

Error on updating customer taxpayer id

Proactively support team has identified an issue with duplicate party id. Support team has worked with oracle to get a fix for the same.01_sop-cm_ora_gdf_01-data-fix-spain-and-poland

Read More

Difference between Oracle EBS R12.1.3 and Oracle EBS R12.2.4

We have recently upgraded Oracle EBS 12.1.3 to Oracle EBS R12.2.4. There are lot of differences. 1)In R12.2 we have to kind of filesystems fs1(run filesystem) and fs2(patch filesystem) where…

Read More

ORA-29702: error occurred in Cluster Group Service operation

While trying to login in oracle database, after that ORA-29702 error coming. $sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 10 10:29:23 2021 Copyright (c) 1982, 2013,…

Read More

adop prepare phase failing with the error ![UNEXPECTED]Nodes are listed in the ADOP_VALID_NODES table but not in the FND_NODES table.

[applmgr@Doyen ~]$ adop phase=prepare Enter the APPS password: Enter the SYSTEM password: Enter the WLSADMIN password: Validating credentials. Initializing. Run Edition context : /oracle/EBSFS/fs1/inst/apps/TEST_Sunapps/appl/admin/TEST_Sunapps.xml Patch edition context: /oracle/EBSFS/fs2/inst/apps/TEST_Sunapps/appl/admin/TEST_Sunapps.xml Patch file…

Read More