Best Of
Re: Performance Transactions in PO_IGT_PERF_DETAIL table have null in PO_DISTRIBUTION_ID column
Its been a while, so this has probably been figured out. But if helpful, I'll add.
"The Invoice gets created with a Invoice Header and Line no Distributions."
That is standard behavior when interfacing via the Payables Open Interface. The distributions records aren't created in the ap_invoice_distributions_all table, until Invoice Validation is executed on the Invoice, for imported invoices. The "distributions" will appear via the forms, but these are "logical" records based on the data in the ap_invoice_lines_all table, until invoice validation. I believe the distribution status shows as 'Preview' for the distributions in this case, vs 'Saved' when the records are actually created in the ap_invoice_distributions_all table.
Re: W4 PDF with Basic Authentication and SSL (HTTPS)
Please take a look at these Doc's
E-SSL: Offloading SSL to F5 Load Balancer (KB327435)
EPY: Updatable W-4 Feature Errors Using Basic Authentication and SSL and Using Load Balancer (KB502808)
E-PIA: PeopleSoft Load Balancer Support Guidelines (KB537361)
which states in the attached file Load_Balancer_Support_Guidelines.pdf
"Because the focus is on replicating bugs and configuring for basic environments, these complex load balancer issues have always been considered out of scope."
Will wait for other customers to respond and help you.
Regards,
Asif M -Oracle.
Re: adding support Identifiers
Now that the portal has changed, what is the recent method to request/add a new support identifier which exists within the same organization? Kindly share the steps.
Re: PER016 EEO-1 Employer Information report wrong column order?
Looks like it is bug 38208358 and development is waiting on the EEOC so no delivery date at this time.
Re: Temp tablespace 12.2
Hello,
Regarding the documentation note -
>>> ... So it looks like it always uses the shared temp tablespace in read/write instance. ... <<<
What it means is the order in which the Oracle internal algorithms searches for the temporary space. It does not mean that for read-write database only a shared temporary tablespace is being used. Rather it implies the priorities assigned to each of the categories of the temporary tablespace.
There will be other aspects that can come into play as well. Firstly the local temporary tablespace needs to created as 'bigfile' on each RAC node. There could be a possibility of the query that started on a particular node/instance could have slave processes running on other node(s)/instance(s). Next the intent is to normally use the local temporary tablespace as a 'spillover' area. So that means anything that could not be handled by the regular (shared) temporary tablespace is caught/spillover to the local temporary tablespace. There are situations wherein the local temporary tablespace is insufficient to handle then obviously it would make use of the shared temporary area.
The contents of the local temporary tablespace (of respective nodes/instances) are not visible across the other RAC nodes/instances. This is because even though the local temporary tablespace name could be the same but on each of these RAC instances they would be pointing to a different physical file. This also eliminates the need to synchronize the data (in local temp) across instances reducing the interconnect network traffic.
Last but not the least in your case the local temporary tablespace file is on a ASM diskgroup as being against disks local to the node. The ASM diskgroup is on a shared storage for the RAC cluster. As mentioned above the only variant being the respective files (of the local temp) are distinct for each of the RAC node/instance.
Hope this helps
Cheers
Suresh
Re: Temp tablespace 12.2
Thanks. I tested it doesn't use the local temp tablespace "ltemp" from the instead using the shared tablespace temp.
How can i make sure that it uses the local .
Re: Temp tablespace 12.2
Local temp tablespace got created successfully . We had enough space on the diskgroup had to give complete absolute path for the filename and two files got each on one instance.
'+OCP31_DGA_DTA01/OCP31C1/6F2CD03F10DD46ECE05358D15A0A6D8B/TEMPFILE/ltemp_01.dbf'
i assigned this local temp tablespace to the user now. does the user now uses the local or shared temp space in case of any sort or hash join operations?
1* select username,temporary_tablespace,local_temp_tablespace from dba_users where username like 'EREG04_WEB' order by 1
SQL> /
USERNAME TEMPORARY_TABLESPACE LOCAL_TEMP_TABLESPACE
-------------------- ------------------------------ ------------------------------
EREG04_WEB TEMP LTEMP
Thanks
Usage of Maps for PeopleSoft Expenses module
In PeopleSoft Expenses module - when we enter start location and end locatins - expense module uses maps and computes distance and shows route.
I have a couple of questons on this:
- Is PeopleSoft using Oracle Maps or Google Maps
- Is there a separate license/cost needed for the usage of this map feature.
Regards
Re: Nightly Automatic Tuning Advisor throws ORA-13602: The specified parameter CON_DBID_MAPPING is not v
@GoodyB The windows with OJVM has been released. The patch will be for 19.30 OJVMRU when you search for the patch.
@Afrul Gafurkhan What is meant by this is it suppresses the error, the fix that should be used is the patch, at this time all patches for 19.30 on Windows, Windows/OJVM, Solaris, Linux, and AIX.
Thanks,
Re: on hand quantity exists or there are open delivery transactions for this item
/* Onhand Quantity Exits Solution From Backend */
--CHECK PRE-APPROVED MOVE ORDERS/OPNE MOVE ORDER----
SELECT MTRL.LINE_ID,
MTRH.HEADER_ID,
MTRH.REQUEST_NUMBER,
MTRL.ORGANIZATION_ID,
FU.USER_NAME
FROM MTL_TXN_REQUEST_LINES MTRL, MTL_TXN_REQUEST_HEADERS MTRH, FND_USER FU
WHERE MTRL.INVENTORY_ITEM_ID = 101258
AND MTRL.ORGANIZATION_ID IN (88,91,92,93,94,96)
AND MTRL.LINE_STATUS = 7 --- Preapproved status
AND MTRL.HEADER_ID = MTRH.HEADER_ID
AND MTRL.CREATED_BY = FU.USER_ID;
-------------------------------------------------------------------------------
--THERE ARE DATA ONHAND AND/OR IN MTL_SUPPLY FOR THE PROBLEM ITEM
--if count > 0, this item is in on hand
SELECT COUNT(1) FROM MTL_ONHAND_QUANTITIES_DETAIL WHERE INVENTORY_ITEM_ID = 101258
AND ORGANIZATION_ID IN (88,91,92,93,94,96)
SELECT COUNT(1) FROM MTL_SUPPLY WHERE ITEM_ID = 101258
AND TO_ORGANIZATION_ID IN (88,91,92,93,94,96)
--OnHand Check
SELECT *
FROM MTL_ONHAND_QUANTITIES_DETAIL
WHERE INVENTORY_ITEM_ID = 101258;
--Interface Check
SELECT *
FROM MTL_MATERIAL_TRANSACTIONS_TEMP
WHERE INVENTORY_ITEM_ID = 101258;
--Cehcking Sourcing
SELECT *
FROM MTL_SUPPLY MS
WHERE ITEM_ID = 101258 ---Closed or cancel the requisition line
--Checking Demand
SELECT *
FROM MTL_DEMAND
WHERE INVENTORY_ITEM_ID = 101258;
--Checking open Move Order
SELECT *
FROM MTL_TXN_REQUEST_LINES
WHERE INVENTORY_ITEM_ID = 101258
AND LINE_STATUS = 7;
-- Solution
-- For on hand, please do misc issue.
---For mtl_supply, please go to supply/demand screen..find out all the POs or Reqs or Interorg shipments linked, then receive and deliver them.
Moktarul