Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
What is Inventory Item Table in Oracle Fusion
The table containing inventory item details in Oracle Fusion is "EGP_SYSTEM_ITEMS_B". It has one composite primary key (INVENTORY_ITEM_ID, ORGANIZATION_ID). and here you can find a sample query to get the most used information about items in Oracle Fusion: Query Inventory Item in Oracle Fusion SELECRead more
The table containing inventory item details in Oracle Fusion is “EGP_SYSTEM_ITEMS_B“. It has one composite primary key (INVENTORY_ITEM_ID, ORGANIZATION_ID). and here you can find a sample query to get the most used information about items in Oracle Fusion:
Query Inventory Item in Oracle Fusion
In the above query, we have one parameter, “:P_INV_ORG_ID” to get the item information in a specific inventory organization.
You can refer to the Oracle doc to know all columns in this table.
Hope this help.
See lessHow to Initialize Oracle APPS session using SQL Developer
You can use this script to initialize a session in SQL Developer and to be able to select from multi-org views in Oracle EBS R12 DECLARE l_user_id NUMBER; l_resp_id NUMBER; l_app_id NUMBER; l_org_id NUMBER; l_err_num VARCHAR2(1000); l_err_msg VARCHAR2(1000); BEGIN SELECT user_id INTO l_user_id FROMRead more
You can use this script to initialize a session in SQL Developer and to be able to select from multi-org views in Oracle EBS R12
API to close workflow notifications in Oracle APPS R12
You can use the following script to close a workflow notification from the backend using API: ------------------------------------------ -- Description: API to close Workflow Notification in oracle EBS R12 -- nid - Notification Id -- resp - Respond Required? 0 - No, 1 - Yes -- responder - User or roRead more
You can use the following script to close a workflow notification from the backend using API:
In the above example we created a cursor that fetchs the open notifications in HRMS which is HRSSA workflow item type and we have used the NOTIFICATION_ID if we need to close specific notification. We have used WF_NOTIFICATION standard package to achieve our goal.
See lessQuery to Get Supplier Details in Oracle APPS R12
Hi @Beter, Please find below a query to get the master supplier informations: SELECT HOU.NAME OU_NAME ,APPS.ORG_ID ,APS.SEGMENT1 SUPPLIER_NUMBER ,APS.VENDOR_TYPE_LOOKUP_CODE SUPPLIER_TYPE ,APS.VENDOR_NAME SUPPLIER_NAME ,APS.VENDOR_NAME_ALT SUPPLIER_NAME_ALT ,APS.NUM_1099 TAXPAYER_ID ,APS.VAT_REGISTRRead more
Hi Beter, Please find below a query to get the master supplier informations:
Above query will list all suppliers details: OU_NAME, ORG_ID, SUPPLIER_NUMBER, SUPPLIER_TYPE, SUPPLIER_NAME, SUPPLIER_NAME_ALT, TAXPAYER_ID, TAX_REGISTRATION_NUM, SUPPLIER_ALLOW_WITHHOLDING_TAX, ACTIVE_CODE, VENDOR_SITE_ID, INACTIVE_DATE, SUPPLIER_SITE_CODE, SITE_CODE_ALT, SITE_ALLOW_WITHHOLDING_TAX, ADDRESS_LINE1, ADDRESS_LINE2, ADDRESS_LINE3, ADDRESS_LINE4 ,CITY, STATE, POST_CODE, SITE_PO_NOTIF_METHOD, and SITE_PO_EMAIL. And the list is open to add any other column/s you prefer. Note: If you are looking also about other details for the supplier you can find them in the list below:
Hope this helps.
See lessHow to Find Queries Running For More than 5 Minutes
To find the queries running for more than 5 or x of minutes you can try the below query and change the seconds parameter as per your need: Query: SELECT S.USERNAME ,Q.SQL_ID ,ROUND (S.LAST_CALL_ET, 2) TIME_IN_SECONDS ,ROUND (S.LAST_CALL_ET / 60, 2) TIME_IN_MINS ,S.SID ,Q.SQL_TEXT FROM GV$SESSION S,Read more
To find the queries running for more than 5 or x of minutes you can try the below query and change the seconds parameter as per your need:
Query:
Output:
Note: 300 is (5*60). change it as you want to.
See lessQuery to get posted AP invoice in Oracle APPS R12
There is a seeded standard function provided from oracle to identify whether the invoice is posted or not. Which is (AP_INVOICES_PKG.GET_POSTING_STATUS) . This function take the invoice_id parameter and return one of four values: 'Y' - Posted 'N' - Unposted 'S' - Selected 'P' - Partially Posted ThesRead more
There is a seeded standard function provided from oracle to identify whether the invoice is posted or not. Which is (AP_INVOICES_PKG.GET_POSTING_STATUS) .
This function take the invoice_id parameter and return one of four values:
‘Y’ – Posted
‘N’ – Unposted
‘S’ – Selected
‘P’ – Partially Posted
These values is the invoice posting status flag.
Example:
Output:
INVOICE_NUM
————————————————–
INVOICE_POSTING_FLAG
——————————————————————————–
ERS-9163-109073
Y
19879-781
N
ERS-4400-109091
Y
ERS-9164-109093
P
ERS-6970-109094
Y
ERS-6971-109095
See lessY
Directory Object vs BLOB
It depends on the number and size of files you want to store. If you have a small amount of files you can store them into the database however, the database size will get bigger by time. On the other side the directory you can assign a specific space you need based on your size of the files and youRead more
It depends on the number and size of files you want to store. If you have a small amount of files you can store them into the database however, the database size will get bigger by time. On the other side the directory you can assign a specific space you need based on your size of the files and you can leverage other advantages like to open the file write into it and so on.
This a brief and for sure there are other benefits for each option but hopefully my answer give you a little insight.
See lessIt’s possible to call an oracle API from custom schema ?
All custom objects should resides on the custom schema like tables, sequences. when it comes to procedures and functions if they will read from the custom objects we have to create it on the custom schema. but if you have a procedure that calls standard API this procedure should be created on APPS sRead more
All custom objects should resides on the custom schema like tables, sequences. when it comes to procedures and functions if they will read from the custom objects we have to create it on the custom schema. but if you have a procedure that calls standard API this procedure should be created on APPS schema.
See lessFont in RDF
I am wondering why to use a report builder template to create a PDF report layout while you have the XML publisher with all its facilities and the ease to design any template using MSWord. But generally, the update of the character set shouldn't have any impact on the report layout or output. Also,Read more
I am wondering why to use a report builder template to create a PDF report layout while you have the XML publisher with all its facilities and the ease to design any template using MSWord.
But generally, the update of the character set shouldn’t have any impact on the report layout or output. Also, is this issue exists in all reports or only in this report? try to delete this repeating frame or create a new one, the same as the one that has the issue, and observe the new one.
See lessHow to get Column Names from a Table in Oracle
To get the list of columns of a table in Oracle, we use to query the view "USER_TAB_COLUMNS" to get the columns of the tables or views owned by the current user. Or use the other view "USER_TAB_COLS". SELECT table_name ,column_name ,data_type ,data_length ,nullable ,data_default FROM user_tab_columnRead more
To get the list of columns of a table in Oracle, we use to query the view “USER_TAB_COLUMNS” to get the columns of the tables or views owned by the current user. Or use the other view “USER_TAB_COLS“.
in the above query, we selected 7 columns to retrieve the most important information that you might be looking for in table columns which are
Note: you have to specify the table name parameter in uppercase.
Note 2: If you use the above view, you will get all unhidden columns, but if you query the view “USER_TAB_COLS” you will get all columns, including hidden columns.
Another view is “ALL_TAB_COLUMNS” this one is the same as “USER_TAB_COLUMNS” except that the “ALL_TAB_COLUMNS” view has a column called “OWNER” in which you can specify the owner of the table that you want to get its columns list.
See less